Purchasing

Get Involved. Join the Conversation.

Posts

  • Piyush Bihany
    Access to Procurement/Purchasing Subject Area & Purchasing...45.0
    Topic posted July 30, 2019 by Piyush BihanyGold Medal: 3,500+ Points, tagged BI Publisher Reports, Fusion, How-To, Orders, OTBI 
    Title:
    Access to Procurement/Purchasing Subject Area & Purchasing Related Reports
    Summary:
    User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New Analysis
    Content:

    Client is live with Oracle Purchasing cloud and users have been creating PO on the Prod Instance.

    However there are few users who doesn't have the Buyer License (Buyer Role is not assigned) and don't have access to create and manage Purchase Order but still wants to review (view only access) for the Purchase order Data via Reports. 
     

    Client has additionally procured license for B84576 - Oracle Fusion Transactional Business Intelligence Cloud Service - Hosted Name, with an understanding that this will grant access to the users for BI Reports. 

    We have created a custom BI Role, and have added the following Privileges to the same: 
    BI Consumer Role 
    And have assigned the custom role to above listed users. 

    These users are unable to create a New Analysis (OTBI report) under the BI Page.

     
    Also for any existing OTBI Report, when the open the same, they are getting error as: 
    No Results 
    The specified criteria didn't result in any data. 

    However the same report is fetch data for other users, who are having Buyer role assigned. 

    Please advice, if in addition to creation of Custom Role for Oracle Fusion Transactional Business Intelligence Cloud Service, any other steps needs to be performed. 

    --

    PB

    Image:
  • 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 GangidiSilver Medal: 2,000+ 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
  • Balakrishna Chaturvedula
    Audit Report for Purchase Order ApprovalsAnswered5
    Topic posted December 16, 2017 by Balakrishna ChaturvedulaBronze Trophy: 5,000+ Points, tagged Approvals, BI Publisher Reports, How-To, Orders 
    Title:
    Audit Report for Purchase Order Approvals
    Summary:
    We are looking for a report which would show approval history for purchase orders
    Content:

    Hi All,

    We have built approval rules which span 2 to 10 levels. As part of audit, we need a report that would display approvers for every purchase order. I am looking for a standard report or a subject area which would fetch such details. Appreciate any pointers / suggestions. Thanks.

    Regards, Bala.

  • 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?

  • Mihai Antofi
    Change Order Total in Bi Publisher custom report2
    Topic posted February 19, 2019 by Mihai Antofi, tagged BI Publisher Reports, Orders 
    Title:
    Change Order Total in Bi Publisher custom report
    Summary:
    Pl/Sql Function to obtain the order total of a specific historical change order
    Content:

    Hi all,

    I am writing a custom report report where I have to bring the Ordered total on each change order for a given PO.

    I tried to use PO_BIP_HELPER.get_ordered_display function but it seem to always bring the Ordered Total of the latest change order, which is not what I am looking for.

    Is there any other function that I could use for this purpose?

    Thanks,

    Mihai

    Version:
    19A
    Code Snippet:
  • Nishanth B Jain
    Communicate Purchasing Documents via EmailAnswered45.0
    Topic posted October 30, 2018 by Nishanth B JainSilver Crown: 22,500+ Points, tagged BI Publisher Reports, Notifications, Supplier Communication 
    Title:
    Communicate Purchasing Documents via Email
    Content:

    Hello People,

    We wanted to know the process of document communication.

    we have setup like

    1. At supplier site communication method is None and on PO its None

    in this scenario communicate will work ? when we give email id after selecting communicate option in PO

    Thanks,

    Nishanth

     

  • Murali Gangidi
    Contract Notes in 'Enterprise Contracts-Contracts Real...25.0
    Topic posted October 25, 2018 by Murali GangidiSilver Medal: 2,000+ 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:
  • Venkat Srinivasan
    Digital Signature in PO document35.0
    Topic posted November 23, 2018 by Venkat Srinivasan, tagged BI Publisher Reports, Orders 
    Title:
    Digital Signature in PO document
    Summary:
    Digital Signature in PO document
    Content:

    How to achieve digital signature automatically in PO document print in Fusion Procurement?

    Version:
    R13