HR_7220_INVALID_PRIMARY_KEY on Complete of Balancing Segment Value Assignments (Doc ID 746945.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle General Ledger - Version 12.0.6 and later
Oracle Human Resources - Version 12.0.6 and later
Information in this document applies to any platform.
*** Checked for relevance on 06-JAN-2012***


Symptoms

When attempting to "Complete" Balancing Segment Value Assignments, the following error occurs:


ERROR
java.sql.SQLException: ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4872
ORA-06512: at "APPS.GL_LEDGERS_PKG", line 111
ORA-06512: at line 1

-- Steps To Reproduce:
1. responsibility <some general ledger super user responsibility>
2. navigation : Setup > Finanacials > Accounting Setup manager > Accounting Setups
Ledger > Balancing Segment Value Assignments >
3. Change status to Complete and error pops

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