Generate Trading Partner Keys: ORA-01476 Error (Doc ID 760994.1)

Last updated on JUNE 28, 2017

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.

Symptoms

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:

MSCTPTK module: Generate Trading Partner Keys

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


Steps:
Create Data files for TradingPratner.dat and TradingpartnerSite.dat and load using Self Service
data Load

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms