Accounting Setups Manager: Updating Balancing Segment Value Assignments Throws java.sql.SQLException:ORA-20001 , ORA-06512 at apps.HR_ORGANIZATION_API (Doc ID 2045139.1)

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)

Symptoms

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:

 

ERROR:

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

Changes

Upgraded from 11i to R12.

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