My Oracle Support Banner

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 NOVEMBER 11, 2020

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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