Posts

Posts

  • Arijit Pramanik
    PO Print PDF by business unit25.0
    Topic posted January 7, 2019 by Arijit PramanikSilver Medal: 2,000+ Points, tagged BI Publisher Reports, Notifications, Supplier Communication in Procurement > Purchasing public
    Title:
    PO Print PDF by business unit
    Summary:
    PO Print PDF by business unit
    Content:
    Can we setup separate PO Print PDF by business unit? If so, is there a setup to achieve this
  • Anil Nair
    How to setup different PO PDF formats based on Sold to Legal...35.0
    Topic posted January 1, 2019 by Anil NairBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Requisition Processing, Setup in Procurement > Purchasing public
    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 in Procurement > Purchasing public
    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.

  • Boyuan Zhu
    How to Find Purchase Orders Associated with a Sales Order5.0
    Topic posted December 20, 2018 by Boyuan ZhuGold Medal: 3,500+ Points, tagged BI Publisher Reports, How-To, Orders in Procurement > Purchasing public
    Title:
    How to Find Purchase Orders Associated with a Sales Order
    Content:

    Customers integrating Purchasing with other applications may need to retrieve details for purchase orders associated with a sales order. You can create and call a BI report using PublicReportWSSService to fetch the associated order details. 

    1. Create the data model in BI Publisher with parameter param_sales_order and a new data set.
    2. Use the following query in the dataset to select orders associated with the sales order. Add any additional attributes you need to the query. 
      SELECT ph.SEGMENT1 OrderNumber,
      pl.LINE_NUM LineNumber,
      pd.DISTRIBUTION_NUM DistributionNumber
      FROM po_headers_all ph, po_lines_all pl, po_distributions_all pd, por_req_distributions_all prd, por_requisition_lines_all prl
      WHERE prd.REQUISITION_LINE_ID = prl.REQUISITION_LINE_ID
      AND pd.REQ_DISTRIBUTION_ID = prd.DISTRIBUTION_ID
      AND pd.PO_HEADER_ID = ph.PO_HEADER_ID
      AND pd.PO_LINE_ID = pl.PO_LINE_ID
      AND prl.SALES_ORDER_NUMBER = :param_sales_order
      
    3. Create a report that uses the data model as the source. 
    4. Run the report using the runReport operation in PublicReportWSSService (see 2086077.1 for WSDL information). 
    Document:
  • Sanjay Shah
    Drill down from Analysis to Data Model syntax using action...
    Topic posted December 12, 2018 by Sanjay ShahGreen Ribbon: 100+ Points, tagged BI Publisher, BI Publisher Reports, OBIEE Answers, OTBI in Reporting and Analytics for SCM public
    Title:
    Drill down from Analysis to Data Model syntax using action Link Go Webpage
    Summary:
    Drill down from Analysis to Data Model syntax using action Link Go Webpage.
    Content:

    Hello,

      I am trying to drill down from Analysis to xdo (Data Model) Bi Publisher Report.  Using the following syntax  using action link Go WebPage., but I want to dynamically pass the value,

    Syntax I am Using in Action link.  

    saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2F~avbodd01%2FOXX_NEG_PO_REPORT.xdo&bipParams={"P_STATUS":"Open"}  -- Here instead of hard coded value (Open), I want to pass the status value from the Analysis Column.

     

    I would appreciate for your help, or let me know if there is other alternative.

    Thanks.

     

    Version:
    R13
  • Arijit Pramanik
    Can you specify the tables for Sourcing Award?3
    Topic posted December 3, 2018 by Arijit PramanikSilver Medal: 2,000+ Points, tagged BI Publisher Reports, Customization in Procurement > Sourcing public
    Title:
    Can you specify the tables for Sourcing Award?
    Summary:
    Can you specify the tables for Sourcing Award?
    Content:

    Can you specify the tables for Sourcing Award?

  • Venkat Srinivasan
    Digital Signature in PO document35.0
    Topic posted November 23, 2018 by Venkat Srinivasan, tagged BI Publisher Reports, Orders in Procurement > Purchasing public
    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
  • Arijit Pramanik
    Can we change the negotiation award output export from xml...25.0
    Topic posted November 22, 2018 by Arijit PramanikSilver Medal: 2,000+ Points, tagged BI Publisher Reports, Negotiation Award in Procurement > Sourcing public
    Title:
    Can we change the negotiation award output export from xml to xls?
    Summary:
    Can we change the negotiation award output export from xml to xls?
    Content:

    Can we change the negotiation award output export from xml to xls?

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

  • 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