GL_PERIOD_STATUSES in BIP not up to date?
Hi Guys
I must be doing something wrong because I am not seeing the same values in the oracle backend database via BIP that I am seeing in the Oracle Front End.
In the front end I am seeing this indicating May-23 is closed:
But when I run this SQL query in BIP for the same ledger id:
SELECT * from GL_PERIOD_STATUSES
where
LEDGER_ID in (300000004628029)
and
CLOSING_STATUS in ('O', 'F')
--GL ONLY
and APPLICATION_ID=200
I am seeing the following showing this period is open:
Any ideas please what I am doing wrong?
Thank you!
Tagged:
0