Generate Trading Partner Keys: ORA-01476 Error
(Doc ID 760994.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On an R12.0.4 Test Instance (Centralized Planning, with dataload from Legacy):
While loading TradingPartner.dat and TradingPartnerSites.dat file using Self Service Data load the following Concurrent Programs are Failing
1. Planning ODS Load
2. Generate Items and Category Sets Keys
3. Generate Trading Partner Keys
Note the following errors in the log file:
ORACLE error 1476 in FDPSTP
Cause: FDPSTP failed due to ORA-01476: divisor is equal to zero
ORA-06512: at "APPS.MSC_CL_SETUP_ODS_LOAD", line 5085
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 6700
ORA-06512: at line 1
Create Data files for TradingPratner.dat and TradingpartnerSite.dat and load using Self Service
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