At Accounting Setup java.sql.SQLException: ORA-20001: HR_7220_INVALID_PRIMARY_KEY: ORA-06512 APPS.HR_ORGANIZATION_API APPS.GL_LEDGERS_PKG

(Doc ID 1499995.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle Human Resources - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle General Ledger - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms


When User is trying to complete the balancing segment value assignments, they are getting the error

For R12.1:

java.sql.SQLException: ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4910
ORA-06512: at "APPS.GL_LEDGERS_PKG", line 112
ORA-06512: at line 1

 

For R12.0:

 

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


Note! Difference in line number.

 

STEPS TO REPRODUCE
--------------------------

1. Log into General Ledger

2. Navigate to
Setup >
Financials >
Accounting Setup Manager >
Accounting Setups >
Accounting Setup Manager screen >
attempt to complete Accounting Setup

3. Query the ledger and update balancing segment value assignments

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