Custom Subject Area Publish Failing With Error :ADFService11G - JBO-26104 : JBO-25109: Object xxxx of type Entity Usage is not found (Doc ID 2990001.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

On : 11.13.23.07.0 version, Analytics

User created custom subject area's for custom objects, created successfully, submit and Publish is also success, but when user is trying to add any columns from the Custom Subject Area through OTBI, throwing below error.
ERROR
-----------------------

View Display Error
 
Error during query processing (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-26104: An error occurred while converting pers def cust for def oracle.apps.crm.analytics.extensibility.applicationModule.ExtensibilityAM, ADFSO BaseLabel newCertifiedLabel_02-Nov-2023 05:03:58:532 +0000, ADFSO ActualLabel newCertifiedLabel_02-Nov-2023 05:03:58:532 +0000 RootCause (oracle.jbo.NoObjException): JBO-25109: Object Application_c of type Entity Usage is not found in Application_cPVO. (HY000)
SQL Issued:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigator > Application Composer > Create new Custom Subject Area > throws error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report with newly created Custom Subject Area

Cause

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