My Oracle Support Banner

R12: Error For Account Assignment in FSG Row Set/Content Set: ORA-01400: cannot insert NULL (Doc ID 1547072.1)

Last updated on JULY 12, 2019

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Trying to setup Account assignments in the Row Set or Content Sets, data cannot be entered and saved.

The following errors are generated:

ORA-01400:  cannot insert NULL into
("RG"."RG_REPORT_AXIS_CONTENTS"."LEDGER_SEGMENT_TYPE")

ORA-01400:  cannot insert NULL into
("RG"."RG_REPORT_CONTENT_OVERRIDES"."LEDGER_SEGMENT_TYPE")

1. You checked and Ledger flexfield segment is enabled for the 'GL Ledger Flexfield' structure.

2. Also, the Freeze Flexfield Structure flag is enabled for the 'GL Ledger Flexfield' structure.

3. The afffckff.sql script ($FND_TOP/sql/afffckff.sql) reports there are issues for the Reporting Attributes:General Ledger Acct flexfield.

4. Ran glgv05.sql script as per Note 787177.1.

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