How to check if an account has been disabled or not in R12?
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.
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.
0