Script Oklamtax.sql Failed due to Mandatory Columns Missing (Doc ID 2188798.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Patch Application Issues

When upgrading from R11i to r12.2,

the following okl scripts are erroring now:

Start time for file is: Thu Jul 07 2016 12:09:44

sqlplus -s APPS/***** @/...../EBSapps/appl/okl/12.0.0/patch/115/sql/oklupdinvfrmtid.sql &un_okc &batchsize 25 32'
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at line 259


sqlplus -s APPS/***** @/....../EBSapps/appl/okl/12.0.0/patch/115/sql/oklamtax.sql '
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("OKL"."OKL_TAX_SOURCES"."APPLICATION_ID")
ORA-06512: at line 49


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applying the upgrade driver for R12.2


Changes

 

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