GL_PERIOD_STATUSES in BIP not up to date?
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
LEDGER_ID in (300000004628029)
CLOSING_STATUS in ('O', 'F')
I am seeing the following showing this period is open:
Any ideas please what I am doing wrong?