ORA-01400 running ar120recppu.sql cannot insert NULL into XLA..XLA_AE_HEADERS JE_CATEGORY_NAME

(Doc ID 1340090.1)

Last updated on JULY 20, 2011

Applies to:

Oracle Receivables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.


Running Hotpatch and developed the following error message when migrating 2003 data from 11.5.10 to 12.1.3 instance when running the following script :  ar120recppu.sql

ERROR at line 1:
ORA-01400: cannot insert NULL into ("XLA"."XLA_AE_HEADERS"."JE_CATEGORY_NAME")
ORA-06512: at line 74


Missing column information in ar_cash_receipts_all table for column TYPE.


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