R12: AGIS - 'Intercompany Import Program' Fails With Error ORA-01086: savepoint 'FUN_TRX_VAL_AND_INSERT_PUB' (Doc ID 1920948.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After applying <Patch 18237720>, Intercompany Import Program fails with the errors below:

ORA-01086: savepoint 'FUN_TRX_VAL_AND_INSERT_PUB' never established in this session or is invalid
ORA-01400: cannot insert NULL into ("FUN"."FUN_TRX_BATCHES"."CREATED_BY")

The FUN interface tables FUN_INTERFACE_HEADERS, FUN_INTERFACE_DIST_LINES, FUN_INTERFACE_BATCHES are populated from a custom source.

<Patch 18399924:R12.FUN.B> was applied and did not resolve the issue.

 

Note that depending on what fields were missed for updates by the custom program, the error message may vary as in the example below:

ORA-01086: savepoint 'FUN_TRX_VAL_AND_INSERT_PUB' never established in this session or is invalid
ORA-01400: cannot insert NULL into ("FUN"."FUN_TRX_BATCHES"."LAST_UPDATED_BY")

This one relates to LAST_UPDATED_BY column instead of CREATED_BY.

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