My Oracle Support Banner

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

Last updated on NOVEMBER 15, 2018

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

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

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