How to use View GL_JE_JOURNAL_LINES_V in R12
Hi
I've been trying to use view GL_JE_JOURNAL_LINES_V in GL to retrieve data in SQL Developer. I know in R12 Oracle uses MOAC you have to set org context. I've used mo_global.init but there is no app_short_name for GL, tried mo_global.set_policy_context('A',null) but it still returns no data. I been able to use it in AR and AP (SQLAP) but not the GL view.
Anybody have any ideas?
Thanks,
Shaun
I've been trying to use view GL_JE_JOURNAL_LINES_V in GL to retrieve data in SQL Developer. I know in R12 Oracle uses MOAC you have to set org context. I've used mo_global.init but there is no app_short_name for GL, tried mo_global.set_policy_context('A',null) but it still returns no data. I been able to use it in AR and AP (SQLAP) but not the GL view.
Anybody have any ideas?
Thanks,
Shaun
1