Get Involved. Join the Conversation.


  • 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 
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Procurement Custom Reports: ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;

     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) 


    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.
    Doc 26739757 - BI EFF DOCUMENTATION[This section is not visible to customers.]
    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)


    Sridhar Tumati


    Release 13 18C
  • Achala Munasinghe
    Amend PO Communication E-mailAnswered5
    Topic posted December 13, 2017 by Achala MunasingheGold Medal: 3,500+ Points, tagged FAQ, How-To, Notifications, Orders, Setup, Supplier Communication, Tip, White Paper 
    Amend PO Communication E-mail

    Hi All,

    I have requirement to change the email body used for Purchase Order Communication. Because the standard message does not contain other than following;

    "Review the purchasing document and any files that are attached to the message"

    Here I want to add the signature used in company email.

    Appreciate your expertise support






  • Patrick Daniels
    An easier way to navigate Oracle to find ERP resources!5.0
    Topic posted October 28, 2018 by Patrick DanielsSilver Medal: 2,000+ Points, tagged How-To, Tip 
    An easier way to navigate Oracle to find ERP resources!
    Know which Oracle ERP Cloud resources to use - and when - in a single page dashboard view!

    Check out these product specific Quick Link charts. 

    These make navigating Oracle much easier!

    We appreciate any feedback you have,

    Oracle Customer Care

  • Nishanth B Jain
    Approval Rule Migration64.0
    Topic posted October 3, 2018 by Nishanth B JainBronze Crown: 15,000+ Points, tagged Approvals, FAQ, Setup, Tip, White Paper 
    Approval Rule Migration

    Hello People,

    Is there a way to migrate approval rules from one instance to other.?

    Some notes talk about SOA Composer, not sure how it works for SaaS.



  • Anil Nair
    Approved Supplier List (ASL)35.0
    Topic posted December 13, 2018 by Anil NairBronze Medal: 1,250+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, Create Requisition, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, White Paper 
    Approved Supplier List (ASL)
    Approved Supplier List (ASL)


    We have a requirement to restrict any purchasing (Req/Orders) for specific suppliers (Blacklisted).

    The approved supplier list functionality doesn't allow any restriction on Order creation when category and supplier from ASL is used.

    There are no Inventory items for now only categories.

    Also, i'm unable to find the source document - Blanket Purchase Agreements, there is only Contract Purchase Agreement in the drop down list under ASL source documents.The Generate Approved supplier list also doesn't show any agreement numbers.

    Please share if you have come across customers with similar requirement.

    Many thanks.


  • Rich Lines
    Auto receipt PO below a set value15.0
    Topic posted May 2, 2019 by Rich LinesBlue Ribbon: 750+ Points, tagged Fusion, How-To, Orders, Setup, Tip 
    Auto receipt PO below a set value
    Is it possible to create a rule for this

    Is it possible to create a rule/s in Oracle Fusion that would automatically receipt ALL lines on a purchase order IF the overall value is below a certain amount?

    We have 3 way matching set up BUT our organisation struggles with PO's not being receipted by the requester (this delaying payment to the supplier etc.)

    We would like to know if there is a way to for example auto receipt ALL the lines on a PO where the total value of that PO is £100.00 or less.


    Oracle Fusion release 19B
  • Palash Kundu
    Automated Testing tool for Oracle Cloud Procurement and SSP1
    Topic posted March 12, 2018 by Palash KunduSilver Medal: 2,000+ Points, tagged Fusion, Tip 
    Automated Testing tool for Oracle Cloud Procurement and SSP
    Any suggestion on Automated Testing tool for Oracle Cloud Procurement and SSP


    Please wanted to check with other customers for Any suggestion on Automated Testing tool for Oracle Cloud Procurement and Oracle Cloud Self Service Procurement




  • Max Basandrai
    Topic posted March 4, 2019 by Max BasandraiBlue Ribbon: 750+ Points, tagged Create Requisition, FAQ, Fusion, How-To, Orders, Requisition Processing, Setup, Tip 
    Set Up Budgets in Requisitions

    Is there a way to set up Budgets to show in Purchase Requisitions in R13

    R13 19A
  • Boyuan Zhu
    Change Default Attachment Category25.0
    Topic posted May 8, 2018 by Boyuan ZhuGold Medal: 3,500+ Points, tagged Agreements, How-To, Orders, Tip 
    Change Default Attachment Category

    The default attachment category when uploading attachments is "From Supplier". Buyers that regularly upload attachments of a different category can change the category name so that the desired category shows as the first and default entry in the LOV.

    1. In Setup and Maintenance, navigate to the task Manage Attachment Categories.

    2. Search for the module Common Purchasing Entities. The results are the avaialable attachment categories.

    3. Rename the user name for the attachment category you want to have as the default. For example, change "To Approver" to "1 - To Approver", and it will default as the first entry in the LOV.

  • Boyuan Zhu
    Control Component Visibility on Purchasing Pages by Role5.0
    Topic posted July 5, 2018 by Boyuan ZhuGold Medal: 3,500+ Points, tagged How-To, Tip 
    Control Component Visibility on Purchasing Pages by Role

    Purchasing pages are secured by job roles out of the box. You can implement more fine-grained control to show or hide page components based on job role using Page Composer. The expression #{securityContext.userInRole[‘<role_code>']} returns true if the user has the job role, and you can use this condition to control the visibility of components. 

    For example, the View PDF button on the View Order page is visible not only to buyers but also to requesters and AP clerks when they drill into the order from their respective pages. The following steps show how to modify the View PDF button to be visible only to buyers. 

    1. Enter a sandbox and navigate to the View Order page. 
    2. Take the Customize Pages action and select Source from the View dropdown.
    3. Find the commandButton: View PDF component. 
    4. The existing EL expression for Visible is true. You can change the expression to #{securityContext.userInRole['ORA_PO_BUYER_JOB']}

    Setting the View PDF button to be visible only to buyers

    viewpdf.png (148KB)