My Oracle Support Banner

Subledger Process Migration To Higher Environment Failure (Doc ID 2973662.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

Migrated Sub ledger process xxxxx, in target the new id generated is yyyyyy.

But migration process is failing due to FSI_SUB_LED_SRC_RUN_DTLS_FK as the underlying process did not update object definition id table FSI_SUB_LED_SRC_RUN_DTLS.

The underlying Tables are:
FSI_SUB_LED_SRC_RUN_DTLS
FSI_SUB_LEDGER_RUN_VERSIONS
FSI_SUB_LEDGER_RUN_DETAILS

ERROR
-----------------------
offline_migration.log

Java.sql.BatchUpdateException: ORA-02291: integrity constraint (ATOMIC.FSI_SUB_LED_SRC_RUN_DTLS_FK) violated - parent key not found

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.