FTP 8.1.1.1 Process Fails With Memory Fault When Audit Enabled and Prepayment Included (Doc ID 2806565.1)

Last updated on MARCH 20, 2023

Applies to:

Symptoms

When running FTP 8.1.1.1 process with Audit enabled and Prepayment included, the process fails but there is no error in the log.

Error:

The following error occurs when running the same process via the command line:

Memory fault(coredump)

The following error occurs in the $FIC_DB_HOME/bin/nohup.out log:

Loading ppmt audit columns: 2
/app/ofsaa/ficdb/bin/ofstp: line 30: 7089: Memory fault 

The FTP debug log file ends abruptly after query on instrument table with the following last statements:

Module Logging OFS calculation module data: select        
select    a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID, 
               a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.CUSTOMER_ID, a.id_number, 
...
               a.HOLIDAY_CALC_OPTION_CD, a.ORIG_OFFSET_BAL, a.LRD_OFFSET_BAL 
from      FSI_PM_GENERATED_INSTRMTS a 
where    a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD 
and        a.PRODUCT_ID = :PRODUCT_ID 
and        as_of_date = to_date('09/ 13/ 2021', 'mm/ dd/ yyyy') 

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

Steps to Replicate:
1. Run FTP standard process with Transfer Pricing Rule or Adjustment Rule in 8.1.0.1 successfully.
2. Applied FTP 8.1.1.1.
3. Re-run the same process and it fails.

Changes

Cause

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