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 DECEMBER 04, 2019

Applies to:

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

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