Posts

Posts

  • Sachin Mistry
    R13 UPGRADE - After R13 upgrade Ship to Address is not...55.0
    Topic posted September 5, 2018 by Sachin MistryGold Medal: 3,500+ Points, tagged Agreements, BI Publisher Reports, Business Intelligence in Procurement > Purchasing public
    Title:
    R13 UPGRADE - After R13 upgrade Ship to Address is not printing on PO PDF Template
    Summary:
    R13 UPGRADE - After R13 upgrade Ship to Address is not printing on PO PDF Template
    Content:

    Curious if you have run into this issue. Our PO pdf template is no longer printing ship to address. We have logged SR however if anyone has run into similar issue and found a resolution. We will appreciate your feedback.

  • Sathya Kannan
    Procurement - Procure to Pay Real TimeAnswered4
    Topic posted October 16, 2019 by Sathya KannanBlue Ribbon: 750+ Points, tagged Business Intelligence, Create Requisition, How-To, Orders, OTBI, Payables, Requisition Processing, Setup, White Paper in Procurement > Purchasing public
    Title:
    Procurement - Procure to Pay Real Time
    Summary:
    Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POs
    Content:

    Hi,

    We would like to create an OTBI report using the Procurement - Procure to Pay Real Time analysis, but the receipt number (available under Invoice column) created for the Purchase orders is not displayed.

    Does anyone know the solution for this?

     

    Regards,

    Sathya Kannan

  • Jim Van Tongerloo
    PO PDF in Language of SupplierAnswered45.0
    Topic posted July 26, 2019 by Jim Van TongerlooGold Trophy: 10,000+ Points, tagged BI Publisher Reports, Business Intelligence, Fusion, Orders in Procurement > Purchasing public
    Title:
    PO PDF in Language of Supplier
    Summary:
    PO PDF in Language of Supplier
    Content:

    Hi,

    I'm looking for the functionality to have the PO PDF print depending on the Supplier (address) language.

    Currently I've made a default template in French under the locale 'English', a template in Dutch under locale 'Dutch' and a template in French under the locale 'French'.

    The Supplier address language is Dutch.

    When viewing the PDF on a PO for this supplier, it keeps taking a French version, because the user preference language is in French?

    Is it not supported to have PO PDF based on Supplier language?

    Thanks.

    Version:
    R13 19B
  • Koteswararao Yenikepalli
    Need a table name for the schedule process ess job names4
    Topic posted July 9, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged BI Publisher Reports, Business Intelligence, SQL, White Paper in Reporting and Analytics for SCM public
    Title:
    Need a table name for the schedule process ess job names
    Summary:
    Need a table name for the schedule process ess job names
    Content:

    We are not able to get the exact name from the ess job name we are able to get the alternative names but need the excat name in the ESS job schedue page

     

     

    Version:
    19A
    Image:
  • Hemant Gupta
    R13 SCM and Procurement OTBI subject areas to database...44.9
    Topic posted October 9, 2018 by Hemant GuptaRed Ribbon: 250+ Points, tagged Business Intelligence, Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM public
    Title:
    R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet
    Summary:
    R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet
    Content:

    This spreadsheet is published by Oracle OTBI Development. 

    Release: R13.18C, R13.19A, R13.19B, R13.19C

    Information Covered:

    - Documents Fusion SCM and Procurement OTBI subject areas, the corresponding View Objects and database tables and columns. 

    - This spreadsheet also documents subject area security duty roles and job roles

    Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.
     

  • 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
  • Sabarish Ganda
    How to Reassign or add two approvers at a time for a BIP...Answered45.0
    Topic posted April 16, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Approvals, Approvals/Notification, Business Intelligence, FAQ, Fusion, How-To, Notifications, Setup in Procurement > Purchasing public
    Title:
    How to Reassign or add two approvers at a time for a BIP Approvals
    Content:

    Recently, we updated our Purchase Order Approvals and Requisition Approvals from ADF to BIP notifications. 

    In older approval notifications we use to have a option for AdHoc add participant, where we can have series of Approvers.

    But with the update, I dont see Adhoc Option and I dont see any option to add two approvers in Serial.

    Please check the attached image.

    Version:
    Oracle Fusion R13
    Image:
  • Renan Robles
    Need a Purchase Order Revision History Report45.0
    Topic posted March 12, 2019 by Renan RoblesBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Orders in Procurement > Purchasing public
    Title:
    Need a Purchase Order Revision History Report
    Summary:
    We need to see amounts changed in our purchase orders
    Content:

    We cannot find a report that shows details of change order amounts. We would like to see the details found on the PO when you go to Revision History. Here you can see amount changed, date, initiator and more. I would even like to see cost center and more details if possible. I believe there should be a standard report showing Revision History. Change History could also work. Can anyone help?

  • 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.
  • Deepak Padhy
    Query to See the Approver Name on Whom a PO is Pending For...45.0
    Topic posted August 24, 2018 by Deepak PadhySilver Medal: 2,000+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, How-To, Notifications in Procurement > Purchasing public
    Title:
    Query to See the Approver Name on Whom a PO is Pending For Approval
    Summary:
    Query to See the Approver Name on Whom a PO is Pending For Approval
    Content:

    Most of the time we get an SR with requirement to see or extract on which approval level a PO is pending currently for approval. And customer wants a Query for this. Below is the Query we have prepared which will give on whom the PO is currently pending for approval. You can prepare an OTBI report to get the extract of all open POs and you can modify the query as per what column you need.

     

    SELECT poh.segment1
    ,approval_instance_id, assignees, wf.outcome, wf.state ,wf.workflowpattern, wf.title, wf.componentname, wf.compositename, pov.change_order_status
    FROM
    fusion.po_versions pov, fusion.po_headers_all poh  , fa_fusion_soainfra.wftask wf
    WHERE pov.po_header_id = poh.po_header_id
    and pov.change_order_status = 'PENDING APPROVAL'
    and pov.approval_instance_id=wf.compositeinstanceid
    and poh.segment1=  '1004752' -- PO Number
    and state='ASSIGNED'
    and assignees is not null
    and workflowpattern not in ('AGGREGATION', 'FYI')
    and componentname='DocumentApproval'

     

    Thanks

    Deepak.