General Ledger - EBS (MOSC)

MOSC Banner

How to check if an account has been disabled or not in R12?

edited Nov 18, 2013 7:56PM in General Ledger - EBS (MOSC) 4 commentsAnswered
Hi team,
I am getting the below error when the standard oracle api is referred.

Value 52350 has been disabled.

Code:   apps.fnd_flex_ext.get_ccid ('SQLGL',
                                  'GL#',
                                  50330,
                                --  TO_CHAR (SYSDATE, 'YYYY/MM/DD HH24:MI:SS'),
                               -- TO_CHAR (SYSDATE, 'YYYY/MM/DD HH24:MI:SS'),
                                 fnd_date.date_to_canonical(SYSDATE),                              
                                  '193-000-000000-52350-000-000000');

the above function is returning 0.
I tried replacing the account with a different value and the ccid is returned i.e '193-000-000000-50100-000-000000'

The account is valid and enabled in GL accounts form.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center