You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GL_PERIOD_STATUSES in BIP not up to date?

edited Jun 22, 2023 9:12AM in General Ledger & Intercompany 3 comments

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!