ASCP: Planning Data Pull Errors With ORA-04063: View "APPS.MRP_AN3_SALES_ORDERS_V" Has Errors (Doc ID 2702199.1)

Last updated on AUGUST 18, 2020

Applies to:

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

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