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

Last updated on APRIL 04, 2025

Applies to:

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

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