ESIC Error Code 255 and ORA-01400: cannot insert NULL into ("FSI_PROCESS_RUN_HISTORY"."EXECUTED_BY") Errors Running FTP Processes Through ESIC (Doc ID 1591252.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.6 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.10 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

On OFSAAI 7.2.10, when running either Oracle Financial Services Funds Transfer Pricing (FTP) Standard Process or Cash Flow Edits in ESIC, the ESIC gives errors. The ofstp and ofsbc logs show the following error:

ERROR
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 01400: cannot
insert NULL into
("OFSAUSER"."FSI_PROCESS_RUN_HISTORY"."EXECUTED_BY") Driver
Function: drv_oci::Execute() SQL Statement:
insert into fsi_process_run_history values(274093, to_date ('08/
31/ 2013', 'MM/ DD/ YYYY'), '', SYSDATE, NULL)


Module Logging OFS errors: (203105) Oracle drv_oci error: Disconnect: Not all ORACLE driver
copies destroyed!

The ESIC returns failure error code as well:

Processing Date:.......... 20130831
Batch Id:................. OFSA72_CFE_FTP_CEND
External Batch Run Id:.... OFSA72_CFE_FTP_CEND_ESIC_20130830134110

**2013-08-30 13:41:11** Step 01: Initialize External Batch: OFSA72_CFE_FTP_CEND_ESIC_20130830134110
**Executing: /app/reveleusofs/ficapp/icc/bin/esic -JI -UOFSAMTH -P -ROFSA72_CFE_FTP_CEND_ESIC_20130830134110 -IOFSA72 -BOFSA72_CFE_FTP_CEND -D20130831 -F/tmp
**2013-08-30 13:41:12** Step 01: Initialize External Batch: OFSA72_CFE_FTP_CEND_ESIC_20130830134110... Complete!

**2013-08-30 13:41:12** Step 02: Execute External Batch: OFSA72_CFE_FTP_CEND_ESIC_20130830134110
**Executing: /app/reveleusofs/ficapp/icc/bin/esic -JXB -UOFSAMTH -P -ROFSA72_CFE_FTP_CEND_ESIC_20130830134110 -IOFSA72 -WC

ERROR: ESIC Batch Execution Failed OFSA72_CFE_FTP_CEND_ESIC_20130830134110 20130830134116
ERROR: ESIC exit code = 255

The batches all complete successfully if run directly from the UI without errors. It also appears they execute in spite of the errors.

The issue can be reproduced at will with the following steps:

1. Run FTP Process or Cash Flow Edit process from ESIC
2. Check for ESIC error return code
3. Check generated log/FusionApps debug log for errors

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