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.
ar120recppu.sql

Symptoms

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

Changes

Missing column information in ar_cash_receipts_all table for column TYPE.

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