Order Management Subject Areas Failing - Errors: Definition oracle.apps.publicFlex.scm.doo.headerCategories.analytics.view.HeaderBIEffEFFBIFlattenedVO of type View Definition is not found. (HY000) (Doc ID 2727974.1)

Last updated on JULY 11, 2023

Applies to:

Symptoms

Order Management subject area doesn't work:

Order Management - Order Headers Real Time
Order Management - Order Details Real Time

View Display Error
 
Odbc driver returned an error (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-25002: Definition oracle.apps.publicFlex.scm.doo.headerCategories.analytics.view.HeaderBIEffEFFBIFlattenedVO of type View Definition is not found. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Distributed Order Orchestration - Order Headers Real Time"."Orchestration Orders Details"."Order Number" s_1 FROM "Distributed Order Orchestration - Order Headers Real Time" FETCH FIRST 75001 ROWS ONLY

Cause

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