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

Last updated on MARCH 08, 2017

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

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

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