R12:Unable to Create Operating Unit From HR or Accounting Setup Manager (ASM)
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 12.0 and later
Oracle Human Resources - Version 12.0.0 and later
Information in this document applies to any platform.
This issue occurs both in HR and the Accounting Setup Manager.
Scenario 1: On the Organization form, when attempting to create an Operating Unit, the legal entity LOV does not have any values.
Scenario 2: In Accounting Setup Manager, when attempting to create an Operating Unit, an error is received:
java.sql.SQLException: ORA-20001 The type of organization is invalid. ORA-06512: at "APPS.HR_ORGANIZATION_API", line 5857 ORA-06512: at line 1
The following query returns no rows:
ENABLED_FLAG ,START_DATE_ACTIVE, END_DATE_ACTIVE
WHERE LOOKUP_TYPE = 'ORG_TYPE' AND LOOKUP_CODE in ('OU','BG' );
This is a fresh installation of Release 12.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms