My Oracle Support Banner

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 878853.1)

Last updated on DECEMBER 13, 2021

Applies to:

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


When try to complete the General Ledger Accounting Setup,
receive the following 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:

Genereal Ledger Super User responsibility >
Setup >
Financials >
Accounting Setup Manager >
Accounting Setups >
Accounting Setup Manager screen >
attempt to complete Accounting Setup


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

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