POiSON WORLD

First find the GL Ledger ID :

select * from Gl_Ledgers_v

Now select and find the period to confirm :

SELECT * FROM GL_PERIOD_STATUSES GLP
WHERE GLP.APPLICATION_ID = '200'/* PAYABLES */
AND GLP.SET_OF_BOOKS_ID = '2149'
AND GLP.CLOSING_STATUS = 'O'
AND GLP.PERIOD_NAME = 'SEP-22'

Once done update the period :

UPDATE GL_PERIOD_STATUSES GLP
SET GLP.CLOSING_STATUS = 'C'
WHERE GLP.PERIOD_NAME = 'SEP-22'
AND GLP.APPLICATION_ID = '200'/* PAYABLES */
AND GLP.SET_OF_BOOKS_ID = '2149';

Comments

comments

Tags: #dba_immam, #immam_dba, #woesofdba, Application DBA in Oracle Application, Close Payable Period, dba ali immam, Oracle Application, Oracle EBS, Query

This entry was posted on Tuesday, July 14th, 2026 at 1:35 pm and is filed under Oracle EBS Application, Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.