Adworker jaipaymentdff.sql Error "cannot insert NULL into ("JA"."JAI_AP_TDS_PAYMENTS"."BANK_NAME")" (Doc ID 2185552.1)

Last updated on MARCH 05, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India AP Localizations

Object jaipaymentdff.sql Failing during Patch "22384627:R12.JAI.B"  application.

ERROR
-----------------------

adworker2 log
observed error message :-
Start time for file is: Wed Aug 10 2016 14:15:15

sqlplus -s APPS/***** @/titu7i/applmgr/1200/ja/12.0.0/patch/115/sql/jaipaymentdff.sql &un_ap &batchsize 4 16
Connected.
declare
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("JA"."JAI_AP_TDS_PAYMENTS"."BANK_NAME")
ORA-06512: at line 92

Time when worker failed: Wed Aug 10 2016 14:15:17
Time when worker started job: Wed Aug 10 2016 14:15:17
Start time for file is: Wed Aug 10 2016 14:15:17

sqlplus -s APPS/***** @/titu7i/applmgr/1200/ja/12.0.0/patch/115/sql/jaipaymentdff.sql &un_ap &batchsize 4 16
Connected.
declare
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("JA"."JAI_AP_TDS_PAYMENTS"."BANK_NAME")
ORA-06512: at line 92

STEPS
-----------------------
Patch application issue.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with applying India Localization Patches.

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