Routing Revisions Not Importing During Data Conversion - Error: BOM_RTG_REV_START_DATE_INVALID (Doc ID 1965332.1)

Last updated on JANUARY 28, 2015

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Importing Routing data from legacy systems using "Oracle Bill and Routing Interface" (BMCOIN) does not always import associated revisions for large data volumes.

Note: Initially the users saw no errors looking in MTL_INTERFACE errors but

Error
Further review found that an error "BOM_RTG_REV_START_DATE_INVALID" was raised in MTL_RTG_ITEM_REVS_INTERFACE:

What is working
The 1000 Routings were then resubmitted via BMCOIN in datasets of @200 Routings with their associated revisions. No changes to data or configurations were made to the import data.
When importing with smaller datasets, the revisions imported into Oracle with their Routing.

EXPECTED BEHAVIOR
The system should handle large data volumes.
Expect valid errors if data fails to process.

STEPS
1. Data extracted from legacy systems are being populated to the Oracle Open Bill/Routing interface tables. Routings include multiple revisions.
2. Total number of Routings in dataset: @2500
3. All valid routings imported to Oracle, but @1000 Routings did not have their associated revisions imported.
4. The 1000 Routings that did not have their revisions iimported were removed from the instance via standard Oracle application processes (Delete Groups).
5. The 1000 Routings were then resubmitted via BMCOIN in datasets of @200 Routings with their associated revisions. No changes to data or configurations were made to the import data.
6. When importing with smaller datasets, the revisions imported into Oracle with their Routing.

BUSINESS IMPACT
Large volumes of routings fail to convert but works fine in smaller batches.
* Although works for smaller data sets, concerned going llive as no errors and just find missing data so major inconsistencies.
This has a direct impact on go-live activities.
- Do you have a Complete Loss of Service? -- Yes
- Is this a Test or Production Environment? -- Test - User Acceptance Test
- Is there a workaround? NO

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