Planning Data Pull Worker Failed - 'Error pulling data from MRP_AP_PO_SHIP_RCV_SUPPLY_V - ORA-01476: divisor is equal to zero (Doc ID 2297673.1)

Last updated on JULY 24, 2024

Applies to:

Symptoms

For a 12.1.3 EBS source instance
- APS Destination could be 12.1.3 or higher

PDP Worker failed for full data collection

running full collections we had a PDP worker fail
29-APR 00:04:22 : Task Number is 35
29-APR 00:04:22 : Global RN (msc_cl_pull.v_lrn): -1
29-APR 00:04:22 : Procedure MSC_CL_SUPPLY_PULL.LOAD_PO_SUPPLY started.
29-APR 00:04:45 : Error pulling data from MRP_AP_PO_SHIP_RCV_SUPPLY_V to MSC_ST_SUPPLIES.
29-APR 00:04:45 : ORA-01476: divisor is equal to zero
ORA-02063: preceding line from APS_TO_EBS
29-APR 00:04:45 : ORA-01476: divisor is equal to zero
ORA-02063: preceding line from APS_TO_EBS
29-APR 00:04:45 : Error_Stack...
29-APR 00:04:45 : ORA-01476: divisor is equal to zero
ORA-02063: preceding line from APS_TO_EBS

29-APR 00:04:45 : Error_Backtrace...
29-APR 00:04:45 : ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-06512: at "APPS.MSC_CL_PULL", line 1809
 
CAUSE is PO Data Corruption - ideally this condition cannot not exist in the applications
HOWEVER --- the BUSINESS IMPACT is production down for single corrupt line and is hard to find and quickly correct the issue.

Per discussions with Collections DEV is asked to see if we can change the view to ignore the bad lines to avoid this production down business impact
MRP_AP_PO_SHIP_RCV_SUPPLY_V is built using view - MRP_AP_PO_SHIP_RCV_V - and this view could be modified to ignore 0 qty rows to help prevent PROD Down issue.

ERROR
-----------------------
ORA-01476: divisor is equal to zero

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner
2. Collection
3. Oracle System -> Standard Collection

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot run collection and causes production down situation for all orgs in the global plan

Cause

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