For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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
Comment
Hi Sridhar,
Resolution is documented in Oracle Supply Chain Management Cloud Functional Known Issues - Release 13 (update 18C) (Search for "Errors When Searching for Items.")
Thanks,
Ivan
Average Rating:



1 rating
|
Sign in to rate this