Purchasing

Get Involved. Join the Conversation.

Posts

  • Boyuan Zhu
    Updated Navigate to Purchasing Transactions from Reports...5.0
    Topic posted May 31, 2019 by Boyuan ZhuGold Medal: 3,500+ Points, tagged BI Publisher Reports, Business Intelligence, How-To, White Paper 
    Title:
    Updated Navigate to Purchasing Transactions from Reports Whitepaper
    Content:

    You can construct and include links to purchasing documents in your reports using the Navigate to Purchasing Transactions from Reports feature. The whitepaper for the feature has been updated with new instructions on how to add links to Oracle Fusion Transactional Business Intelligence reports. 

    Please find the whitepaper on My Oracle Support: Navigate to Purchasing Transactions from Reports (note 2444555.1).

  • Sabarish Ganda
    How to Reassign or add two approvers at a time for a BIP...Answered45.0
    Topic posted April 16, 2019 by Sabarish GandaSilver Medal: 2,000+ Points, tagged Approvals, Approvals/Notification, Business Intelligence, FAQ, Fusion, How-To, Notifications, Setup 
    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:
  • *** E S
    Need the concept/logic behind why Retroactive pricing is...1
    Topic posted March 29, 2019 by *** E SGreen Ribbon: 100+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services, White Paper 
    Title:
    Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price Break and not with Cumulative Price Break in BPA on Procurement Cloud ?
    Summary:
    We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.
    Content:

    Hi all,

    Based on my research,

    For a retroactive pricing to reflect, it is suggested to choose price break type as Non-Cumulative.

    Need to understand the relation between Price Break and Retroactive Pricing, an explanation with a Business example would help.

    Please refer this document ID in My Oracle Support - (Doc ID 2259539.1) 

    Thank you,

    *** E S

     

     

    Version:
    19A (11.13.19.01.0)
  • chetan kumar
    Receipt Number field blank on OTBI report from Procure to...Answered4
    Topic posted March 25, 2019 by chetan kumarBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Security 
    Title:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Summary:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Content:

    Hi All,

    we built a OTBI report based on "Procure to Pay" subject area, receipt number field is blank,Could anyone check what would be the reason.

    Regards,

    Chetan

  • Renan Robles
    Need a Purchase Order Revision History Report35.0
    Topic posted March 12, 2019 by Renan RoblesBlue Ribbon: 750+ Points, tagged BI Publisher Reports, Business Intelligence, Orders 
    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?

  • Anil Nair
    How to create UNSPSC reports1
    Topic posted February 5, 2019 by Anil NairRed Ribbon: 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.

  • Minna Muikku
    Unable to navigate to PO from report, link not working35.0
    Topic posted February 1, 2019 by Minna MuikkuSilver Medal: 2,000+ Points, tagged Business Intelligence, How-To 
    Title:
    Unable to navigate to PO from report, link not working
    Summary:
    I tried to create a link as per Doc ID 2444555.1 but the link takes me to a blank "View Order" page
    Content:

    Hi all,

    In 18C a new feature was introduced where you can set up a link in OTBI analysis to navigate to purchase order straight from the report ("Navigate to Purchasing Transactions from Reports") I tried to create a link as instructed, but all I got is a blank "View" page. 

    Here's a link to the release note 18c where the feature is described; https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/r13-2018-procurement-wn.htm#F3686

    Here's the note that gives the steps in detail: Navigate to Purchasing Transactions from Reports (Doc ID 2444555.1)

    Here's what I did:

    1. I have a report that has attributes 'Order Number' and 'PO Header Id' (from subject area Procurement - Purchasing Real Time)

    2. I changed the data format of the 'PO Header Id' attribute to not have any decimals (because this usually creates issues in deep links)

    3. For attribute 'Order Number', I changed the column formula to (xxxx is hostname) '<a href= https://xxxx/fndSetup/faces/deeplink?objType=PURCHASE_ORDER&objKey=poH eaderId='|| CAST("Purchase Order Header Detail"."PO Header Id" AS char)||'>'||"Purchase Order Header Detail"."Order"||'</a>'  and changed the data format to 'Treat text as HTML' (as advised on the note). 

    After this, when I click the PO number on the report, the link should  take me to the View Order page of the certain order, but all I get is blank view order page (see screenshot attached)

    I must have gotten some steps wrong. I believe this cannot be a role/data access issue. Any tips?

     

     

     

     

     

  • Anil Nair
    How to setup different PO PDF formats based on Sold to Legal...35.0
    Topic posted January 1, 2019 by Anil NairRed Ribbon: 250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Requisition Processing, Setup 
    Title:
    How to setup different PO PDF formats based on Sold to Legal Entity
    Summary:
    How to setup different PO PDF formats based on Sold to Legal Entity
    Content:

    We have a requirement to setup different PO PDF formats based on the Sold to Legal Entity on the purchase order.

    There are 5 LE's linked to 1 BU

    Each legal entity has their own specific PO Print PDF format which is sent to the supplier when a Purchase Order is created.

    Please advice how we can handle this requirement.

  • Atul Kumar
    Manage Purchasing Document Lifecycle - Validate15.0
    Topic posted December 20, 2018 by Atul KumarBronze Medal: 1,250+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, Payables, Requisition Processing, Security, Setup, Supplier Communication, Tip, Web Services, White Paper 
    Title:
    Manage Purchasing Document Lifecycle - Validate
    Summary:
    Diagnostic is failing for Test name Manage Purchasing Document Lifecycle - Validate
    Content:

    Hi

    Getting below error while running diagonostics test on Test name Manage Purchasing Document Lifecycle - Validate even after running it from procurement page. Please let me know if you faced the same issue?

     

    Critical: Thread 15027: An error occurred while executing test: oracle.apps.prc.po.diagnostic.internal.PoDocumentActivity: Could not invoke test. Reasons could be because (a) The associated application ProcurementApp is not running (b) Credential Store and Permissions have not been set up correctly (c) The test is being invoked from outside the J2EE context.
    oracle.apps.fnd.appltest.diagfwk.common.DiagfwkException: Could not invoke test. Reasons could be because (a) The associated application ProcurementApp is not running (b) Credential Store and Permissions have not been set up correctly (c) The test is being invoked from outside the J2EE context. at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.runTestViaMBean(TestRunner.java:324) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.run(TestRunner.java:224) at oracle.apps.fnd.appltest.diagfwk.engine.impl.TestRunner.doRun(TestRunner.java:152) at oracle.apps.fnd.appltest.diagfwk.engine.DiagRunnable.run(DiagRunnable.java:68) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:745)
    Fix Information: An unexpected error was encountered. Please contact your system administrator.

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