22D: Error in Report Based on Custom Subject Area "JBO-26028: View object ItemEFFBIFlattenedVO does not include a primary key attribute InventoryItemId of entity base ItemAllPEO" (Doc ID 2927410.1)

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

On : 11.13.22.10.0 version, Analytics

When attempting to run an existent analysis based on custom subject area based on a custom object, the following error occurs.

ERROR
-----------------------
[nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-26028: View object ItemEFFBIFlattenedVO does not include a primary key attribute InventoryItemId of entity base ItemAllPEO. [[
[nQSError: 43119] Query Failed:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Sales > Workspace > Drilldown into an account
2. Go to report tab where it will load Report
3. Error occurs
Query Status: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-26028: View object ItemEFFBIFlattenedVO does not include a primary key attribute InventoryItemId of entity base ItemAllPEO. [[
[nQSError: 43119] Query Failed:



Observations:
- if they enter in a sandbox created after 22D update, they do not get the error and report runs fine.
- The CSA works fine if there is no ItemPartNumber_c object attributes outside sandbox
- When outside the sandbox, the Item attributes shows different names. Example, Item Number shows as ItemBasePEOItemNumber

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.