R12 GL : SET_OF_BOOKS_ID column of table gl_automatic_posting_sets has been removed in R12 ?
Hi there,
INTO v_ABCD
FROM gl_automatic_posting_sets
WHERE set_of_books_id = variableX
AND autopost_set_name = V_XYX;
SET_OF_BOOKS_ID column of table gl_automatic_posting_sets has been removed in R12.1.3 .
What is the workaround suggested by Oracle for this . Though there is column set_of_books_id_11i provided, we need some other workaround for this.
Our query is like :
SELECT autopost_set_idINTO v_ABCD
FROM gl_automatic_posting_sets
WHERE set_of_books_id = variableX
AND autopost_set_name = V_XYX;
Thanks,
Amol J.
1