My Oracle Support Banner

ORA-01400 running ar120recppu.sql cannot insert NULL into XLA..XLA_AE_HEADERS JE_CATEGORY_NAME (Doc ID 1340090.1)

Last updated on APRIL 10, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.