My Oracle Support Banner

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:

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

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
Symptoms
Changes
Cause
Solution
References


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