Posts

Posts

  • Ramesh Radhakrishnan
    "Update Supplier Keyword Search Index and Source to...4
    Topic posted June 9, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Audit, Business Intelligence, FAQ, How-To, Sourcing Programs, Supplier Creation, Tip in Procurement > Supplier Management public
    Title:
    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors
    Content:

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes  and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1)
    Version:
    R13-19B
  • Hong Gao
    Access to Supplier BI Reports45.0
    Topic posted September 25, 2018 by Hong GaoGold Medal: 3,500+ Points, tagged Business Intelligence, Security, Tip in Procurement > Supplier Management public
    Title:
    Access to Supplier BI Reports
    Summary:
    Function security for accessing supplier related OTBI reports
    Content:

    As part of supplier administration and management, internal users want to leverage Oracle Transactional Business Intelligence (OTBI) to review seeded reports as well as construct ad-hoc reports to meet business requirements. Seeded job roles like Supplier Administrator or Supplier Manager has all the function security set up out of the box to satisfy the reporting needs for managing suppliers. However, from time to time, you may want to grant other functional users the ability to review and build reports related to supplier data.

    To achieve that, here are a couple of function security considerations.

    1) there are currently four BI subject areas that are dedicated to supplier and supplier profile data: Supplier - Supplier Real Time, Supplier Registration - Supplier Real Time, Supplier - Profile Change Request Real Time, and Supplier Import - Supplier Real Time.  Content in these subject areas are all secured by duty role Supplier Master Data Transaction Analysis Duty. If your reporting need requires information from these subject areas, this duty role is necessary to access the content.

    2) apart from the duty role above, to have the ability to build an ad-hoc report, the user would also need to have the BI Author role.  

    Within the four supplier content subject areas, there are a few seeded reports:

    a) Supplier Export Reports (catalog path: /Shared Folders/Procurement/Embedded Content/): this folder contains seeded reports that can be used to extract data to populate the import supplier FBDI templates for mass update:

    •  
    • Export supplier data for import template
    • Export supplier addresses data for import template
    • Export supplier business classifications data for import template
    • Export supplier contacts data for import template
    • Export supplier contact addresses data for import template
    • Export supplier products and services category data for import template
    • Export supplier site assignments data for import template
    • Export supplier sites data for import template
    • Export supplier site third-party relationships data for import template

    b) Listing of Supplier Profile Change Requests (catalog path: /Shared Folders/Procurement/Supplier Profile Change Request/Transactional Analysis Samples/): this report allows users to search and report on profile change requests across the supply base.

    User can access the seeded reports by browsing through Catalog.  However, to properly view the data in these reports, user will also need to have the Supplier Master Data Transaction Analysis Duty.

    A special note for supplier portal users:

    • While collaborating with suppliers through Supplier Portal, it's important to note that supplier portal user does not have a navigation path to Report and Analytics work area to build ad-hoc reports.  On Supplier Portal landing page, there is an infolet for Transaction Reports.  From there, user can drill down to an OTBI dashboard with seeded reports on their transactions.
  • Rushi Joshi
    Add static text in FYI: Approved Supplier Registration...155.0
    Topic posted September 9, 2019 by Rushi JoshiSilver Medal: 2,000+ Points, tagged Business Intelligence, Fusion, How-To in Procurement > Supplier Management public
    Title:
    Add static text in FYI: Approved Supplier Registration Request email
    Summary:
    Require to add a static text in the email body that a requester receives when a supplier requested by them earlier gets finally approved.
    Content:

    Hello everyone,

    Can anyone guide how to add a static text in an FYI email received by a requester when their requested supplier gets finally approved. Attached is the current email formate.

     

    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 in Procurement > Purchasing public
    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 in Procurement > Purchasing public
    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.

  • Mohammad Alhindawi
    Approval cycle for the suppliers master data creation6
    Topic posted March 11, 2019 by Mohammad AlhindawiRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Business Intelligence, Create Requisition, Customization, FAQ, Financials, Fusion, How-To, Import, Orders, Payables, Public Sector, Requisition Processing, Security, Setup, Sourcing Programs, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account, Tip, Web Services, White Paper in Procurement > Supplier Management public
    Title:
    Approval cycle for the suppliers master data creation
    Summary:
    Approval cycle for the suppliers master data creation
    Content:

    Is there an approval cycle for the suppliers master data creation in the app?

    Version:
    Oracle Fusion Procurement Cloud
  • 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 in Procurement > Purchasing public
    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
  • Nishanth B Jain
    Award Negotiation Export3
    Topic posted February 13, 2019 by Nishanth B JainBronze Crown: 15,000+ Points, tagged BI Publisher Reports, Business Intelligence, Customization, FAQ, How-To, Negotiation Award, Negotiation Creation, Setup, Sourcing Programs, Spreadsheet Related in Procurement > Sourcing public
    Title:
    Award Negotiation Export
    Content:

    Hello,

    Can we edit Award By Spreadsheet. Is there any report for this?

    If yes, where we can find the data model for this export.

    Thanks,

    Nishanth

    Image:
  • Adam Doyle
    BI Subject Area for Approved Supplier Lists5.0
    Topic posted May 10, 2019 by Adam DoyleRed Ribbon: 250+ Points, tagged Business Intelligence, Procurement, Reporting and Analytics in Reporting and Analytics for SCM public
    Title:
    BI Subject Area for Approved Supplier Lists
    Summary:
    It would be help to have data related to Approved Supplier Lists as a subject area in BI
    Content:

    It would be help to have data related to Approved Supplier Lists as a subject area in BI.  This is needed for various analysis and reports we are trying to do.  Also, having it join with purchase agreement subject areas would be ideal.

    Version:
    R13
    Document:
    ASL.docx (113KB)
  • 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 in Procurement > Purchasing public
    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?