ASCP: Planning Data Pull Errors With ORA-04063: View "APPS.MRP_AN3_SALES_ORDERS_V" Has Errors
(Doc ID 2702199.1)
Last updated on SEPTEMBER 22, 2021
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run the Data Collections, the following error occurs in the Planning Data Pull/Worker (MSCPDP/MSCPDPW)...
ERROR
-----------------------
13-AUG 08:07:52 : Error pulling data from MRP_AN3_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
13-AUG 08:07:52 : ORA-04063: view "APPS.MRP_AN3_SALES_ORDERS_V" has errors
ORA-02063: preceding line from TEBS1
13-AUG 08:07:52 : ORA-04063: view "APPS.MRP_AN3_SALES_ORDERS_V" has errors
ORA-02063: preceding line from TEBS1
13-AUG 08:07:52 : Error_Stack...
13-AUG 08:07:52 : ORA-04063: view "APPS.MRP_AN3_SALES_ORDERS_V" has errors
ORA-02063: preceding line from TEBS1
13-AUG 08:07:52 : Error_Backtrace...
13-AUG 08:07:52 : ORA-06512: at "APPS.MSC_CL_PULL", line 7060
ORA-06512: at "APPS.MSC_CL_PULL", line 1808
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Collections
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue with planning.
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 |