Purchasing

Get Involved. Join the Conversation.

Posts

  • Sridhar Tumati
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was...15.0
    Topic posted November 19, 2018 by Sridhar TumatiBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Tip, White Paper 
    Title:
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Summary:
    Procurement Custom Reports: ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Content:

     Hi All,

    After Upgrading to Release 13 18C, All the custom Reports developed using Procurement Purchasing Real time subject area having item Description. field results error as below:

    State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO was not correctly resolved in view def InventoryItemRefPVO. Locate the resolution error and address the issue. (HY000)

    We raised  SR and Oracle Support Provided the solution as per below docment:

    FA OTBI - After 18C Patch Errors on OTBI SCM, Produrement Subject areas erroring out ItemEFFBIFlattenedVO; FulfillLineDetailBIEffEFFBIFlattened (Doc ID 2470931.1) 

    Bug 28895661 : FA OTBI ANALYSIS FAILING AFTER 18C UPDATE - ACCESSOR ITEMEFFBIFLATTENEDVO WAS NOT CORRECTLY RESOLVED

    EGO_ITEM_EFF:
    To deploy Item extensible flexfields, do the following:

    1. In the Setup and Maintenance work area, open the task panel and click Search.
    2. Search for and select the Manage Extensible Flexfields task.
    3. On the Manage Extensible Flexfields page, search for the Item Extended Attributes flexfield (flexfield code EGO_ITEM_EFF).
    4. Select the Item Extended Attributes row. From the Actions menu, select ‘Refresh & Deploy Offline’

    This action starts the Item extensible flexfield deployment process.
    5. Monitor the Offline Status column, which shows the status of the deployment process.
    DOO EFF
    Doc 26739757 - BI EFF DOCUMENTATION[This section is not visible to customers.]
    Steps:
    1. Please run the ESS program: Publish Extensible Flexfield Attributes.
    2. In the Manage Extensible Flexfield UI, force deploy the doo header, fulfill line, fulfill line details EFF regardless of whether the customer uses these EFFs or not by invoke Actions->Refresh & Deploy Offline
    3. After deployment, in the same EFF UI, invoke Actions->Download Flexfield
    Archive to download the artifacts, and make sure the directory structure is like: oracle.apps.publicFlex.scm.doo.fulfillLineCategories.analytics
    4. Bounce SCM’s UI and Service Server (Open SR for the bounce)

    Regards,

    Sridhar Tumati

     

    Version:
    Release 13 18C
  • Murali Gangidi
    Approval Aging Report including all approvers and timestamp...35.0
    Topic posted November 19, 2018 by Murali GangidiBronze Medal: 1,250+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, Fusion 
    Title:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice).
    Summary:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice)
    Content:

    Hello Gurus,

     

    Is there seeded report or any OTBI Subject Area's to join or BIP Query which will get the Approval details of  all approvers and timestamp  for Purchase Order , Contracts and Invoices. Need custom report  to pull all Open and Pending Approval PO's, Contract's and Invoices in one report. Trying to explore the options and if any one can help on this.

  • Annette Massie
    Approved requisitions not generating PO'sAnswered8
    Topic posted July 26, 2019 by Annette MassieRed Ribbon: 250+ Points, tagged BI Publisher Reports, Business Intelligence, Public Sector 
    Title:
    Approved requisitions not generating PO's
    Content:

    We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

    SELECT prh.requisition_number
    ,prl.line_number
    ,prl.line_status
    ,prl.req_po_instance_id
    ,prl.reqs_in_pool_flag
    ,ph.segment1 AS po_number
    ,prh.emergency_po_number
    ,prl.reqtopo_automation_failed
    ,prl.reqtopo_auto_failed_reason
    ,msg.context AS failed_reason_text
    ,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1,
    NULL) AS SOLDTO_LE_ID
    ,prh.pcard_id
    ,prl.line_type_id
    ,prl.pcard_flag
    ,prl.requisition_header_id
    ,prl.requisition_line_id
    ,prl.prc_bu_id AS req_line_prc_bu
    ,prh.prc_bu_id AS req_header_prc_bu
    ,prl.req_bu_id
    ,prl.assigned_buyer_id
    ,prl.negotiated_by_preparer_flag
    ,prl.negotiation_required_flag
    ,prl.source_document_type
    ,prl.source_doc_header_id
    ,prl.vendor_id
    ,prl.vendor_site_id
    ,prl.line_location_id
    ,prl.item_id
    ,prl.category_id
    ,prl.amount
    ,prl.quantity
    ,prl.unit_price
    ,ph.document_creation_method
    ,ph.prc_bu_id AS po_prc_bu
    ,ph.document_status
    ,ph.po_header_id
    FROM po_headers_all ph
    ,po_lines_draft_all pl
    ,por_requisition_lines_all prl
    ,por_requisition_headers_all prh
    ,fnd_messages_b msg
    WHERE ph.po_header_id(+) = pl.po_header_id
    AND prl.po_line_id = pl.po_line_id(+)
    AND prl.requisition_header_id = prh.requisition_header_id
    AND prh.requisition_number IN ('RQ17135')
    AND prl.reqtopo_auto_failed_reason = msg.message_name(+)
    ORDER BY prl.requisition_header_id, prl.line_number; 

    Version:
    19B
  • Dev Thota
    BPM Worklist: How long will the Approval History store in...2
    Topic posted August 29, 2018 by Dev ThotaGold Trophy: 10,000+ Points, tagged Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Public Sector, Requisition Processing, Security, Setup 
    Title:
    BPM Worklist: How long will the Approval History store in the system?
    Summary:
    BPM Worklist: How long will the Approval History store in the system?
    Content:

    BPM Worklist: How long will the Approval History store in the system?

  • Manavalan Ethirajan
    Build your own report using new Procure to Pay Subject Area15.0
    Topic posted January 18, 2018 by Manavalan EthirajanSilver Medal: 2,000+ Points, tagged Business Intelligence 
    Title:
    Build your own report using new Procure to Pay Subject Area
    Content:

    A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject area to create your own ad-hoc report. You can review the brief summary of the feature here.

    You can review the feature description in the following release readiness materials and documentation.

    Please feel free to post any questions or comments here.

  • Murali Gangidi
    Contract Notes in 'Enterprise Contracts-Contracts Real...25.0
    Topic posted October 25, 2018 by Murali GangidiBronze Medal: 1,250+ Points, tagged Agreements, BI Publisher Reports, Business Intelligence, Fusion 
    Title:
    Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI Analysis
    Summary:
    Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI Analysis
    Content:

    Hi All,

    Is there any folder/dimension where can we find the Notes that is entered on the Enterprise Contracts at Header level in n OTBI Subject Area 'Enterprise Contracts-Contracts Real Time'.

      Which tables that this notes section refers to in Contracts Module. Attached screenshot for reference.

     

    Image:
  • Eren Göktepe
    Edit Purchase Order Email Approval Notification2
    Topic posted October 16, 2019 by Eren GöktepeRed Ribbon: 250+ Points, tagged Approvals/Notification, Business Intelligence, Notifications 
    Title:
    Edit Purchase Order Email Approval Notification
    Summary:
    I try to edit PO template but .rtf validation failed in Word
    Content:

    Hi,

    I downloaded .rtf document for editing template. I clicked 'validation template' button. 

    I faced error in the below

     

    RTF Validation Failed

    Run XDO Start
    Oct 16, 2019 12:10:56 PM
    oracle.xdo.XDOException: 1 >= 1
    at oracle.xdo.template.rtf.RTFParser.generate(RTFParser.java:165)
    at oracle.xdo.template.rtf.RTF2XSLParser.generateXSL(RTF2XSLParser.java:343)
    at oracle.xdo.template.RTFProcessor.process(RTFProcessor.java:347)
    at RTFValidation.runRTFValidation(RTFValidation.java:121)
    at RTFValidation.main(RTFValidation.java:88)
    Version:
    Oracle Cloud Application 19C
    Image:
  • Ramesh Radhakrishnan
    Enable Requested Delivery date feild in OTBI reports3
    Topic posted May 9, 2018 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Business Intelligence, How-To 
    Title:
    Enable Requested Delivery date feild in OTBI reports
    Summary:
    Enable Requested Delivery date feild in OTBI reports
    Content:

    How to Enable Requested Delivery date feild in OTBI reports?

    Thanks

    Ramesh

  • Harshith Eshwar Shaila
    How Purchasing Module interacts with other Oracle modules.25.0
    Topic posted September 4, 2019 by Harshith Eshwar ShailaBronze Medal: 1,250+ Points, tagged Agreements, Approvals, BI Publisher Reports, Business Intelligence, Create Requisition, Financials, General Ledger, Orders, Payables, Requisition Processing, Setup, Tip, Web Services, White Paper 
    Title:
    How Purchasing Module interacts with other Oracle modules.
    Content:

    Hi all, 

    Is there any Doc IDs/Link/ whitepapers or any other Detailed Documentation on understanding how Purchasing Module interacts with other Oracle modules in Procurement, SCM, Financials..etc, from data flow perspective.

    Regards,

    Harshith E S

  • Anil Nair
    How to create UNSPSC reports1
    Topic posted February 5, 2019 by Anil NairBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Setup, White Paper 
    Title:
    How to create UNSPSC reports
    Summary:
    How to create UNSPSC reports
    Content:

    We have client requirement to setup the UNSPSC codes structure along with the commodity (category) codes in Oracle Procurement.

    The procurement category hierarchy ( hierarchy levels) along with functional area catalog (categories) in Oracle fusion will partially meet this requirement but there is no field for UNSPSC codes.

    - Which field can be used for the UNSPSC codes?

    - How can I build a report using the procurement hierarchy levels and categories assigned to each level?

    - Is it possible to develop a report on level 1 and report spend on categories under level 1? Aggregated report based on the top category level.

    - Is it possible to drill down from level 1 to level 3 to analyse spend at each UNSPSC level.

    UNSPSC example is given below. 

    Level 1   - Information Technology Broadcasting and Telecommunications (43000000)

    Level 2   - Software (43230000)

    Level 3 - Finance accounting and enterprise resource planning ERP software (43231600)

           Level 4 (category) - Financial analysis software (43231604)

     

    Thanks.