Accounting Setups Manager: Updating Balancing Segment Value Assignments Throws java.sql.SQLException:ORA-20001 , ORA-06512 at apps.HR_ORGANIZATION_API
Last updated on JANUARY 31, 2017
Applies to:Oracle Human Resources - Version 12.1.3 and later
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Accounting Setup Manager (ASM)
Accounting Setup Manager: Balancing Segment Value (BSV) assignment was end-dated by user mistake. The requirement is to change this End Date incorrectly entered, allowing further usage of the BSV for the ledger. After performing the change, the ASM page throws:
java.sql.SQLException:ORA-20001: FND_GENERIC_MESSAGE You do not have access privilege to any operating unit ORA-06512 at apps.HR_ORGANIZATION_API Line 4926 ORA-06512 at APPS.GL_LEDGERS. PKG Line 112
STEPS TO REPRODUCE:
1. Navigate to Accounting Setup Manager > Query for the ledger
2. Navigate to Balancing Segment Value assignments, see the End Date field populated incorrectly for one of the BSVs
3. Attempt to change this End Date and hit 'Apply' button - the process would normally trigger 'General Ledger Accounting Setup Program' but instead it throws error
Upgraded from 11i to R12.
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