FTP Process Fails With No Errors When 'Instrument Charge/Credit (Adj)' Selected With No Adjustment Rule (Doc ID 2942250.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

When running an FTP process, data is not getting populated in the target tables.  The Transfer Pricing Engine logs ends with the following SQL:

Module Logging OFS Access module data: select
select  REV_TABLE_CLASS_ASSIGNMENT.table_name,
        REV_TABLE_CLASS_ASSIGNMENT.owner,
        REV_TABLE_CLASS_ASSIGNMENT.table_classification_cd
from    REV_TABLE_CLASS_ASSIGNMENT
where   TABLE_NAME=UPPER('FSI_D_BORROWINGS')
AND     TABLE_CLASSIFICATION_CD=600

Module Logging OFS Access module data: /* TableDesc* TPInstrument::MakeTableDesc() */

Module Logging OFS Access module data: /* GetTRateCol() */

Module Logging OFS Access module data: /* GetTRateCol() */

Checking the nohup.out in $FIC_DB_HOME/bin, there is an entry for the FTP Process with a memory fault:

Connection to the following database was successful: <ATOMIC>
Running TP, Process ID: 200703
ID_TYPE = 204
/<OFSAA Home>/ficdb/bin/ofstp: line 30: 24998: Memory fault(coredump)

There is no message for a successful completion: "INFORM : Engine execution Successful".

Cause

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