What is Period?
1.
An interval of time characterized by the occurrence of a certain condition,
event, or phenomenon: a period of economic prosperity.
2
Geology A unit of time, longer than an epoch and shorter than an era.
Significance
Of Opening Periods in Oracle apps:
TO
OPEN MONTHLY PERIODS OF DIFFERENT MODULES OR NEXT YEAR AND FOLLOW THE BELOW
STEPS
1.
HOW TO OPEN INVENTORY PERIODS (INV) :
Follow
the below given navigation path :
INVENTORY
- > ORACLE INVENTORY - > ACCOUNTING CLOSE CYCLE - > INVENTORY
ACCOUNTING PERIODS
2. HOW TO OPEN PAYABLE PERIODS (AP):
Follow the below given navigation path :
PAYABLES - > ORACLE PAYABLES - >
ACCOUNTING - > CONTROL PAYABLES PERIODS
3. HOW TO OPEN RECEIVABLE PERIODS (AR) :
Follow the below given navigation path :
RECEIVABLES - > ORACLE RECEIVABLES - >
CONTROL - > ACCOUNTING - > OPEN/CLOSE PERIODS
4. HOW TO OPEN GENERAL PERIODS (GL) :
Follow the below given navigation path :
GENERAL SUPER LEDGER - > SETUP - >
OPEN/CLOSE
5 Navigate to Purchasing
SuperUser->Setup->Financials->Accounting->Control Purchasing
Periods , then enter the Fiscal year and click Go button.
(If it prompts for selecting Operating
Unit,select it and click Go button.)
Query to get whether accounting period or
not?
SELECT application_id
into g_application_id
FROM fnd_application_tl
WHERE application_name =
'Receivables'
SELECT SET_OF_BOOKS_ID INTO P_SOB_ID
FROM GL_SETS_OF_BOOKS
P_ACCOUNTING_DATE IS YOUR period
FUNCTION validate_gl_accounting_date
(p_accounting_date IN DATE,
p_sob_id IN NUMBER)
RETURN BOOLEAN
IS
v_count NUMBER := 0;
BEGIN
SELECT COUNT ( * )
INTO v_count
FROM gl_period_statuses
gps
WHERE
gps.application_id = g_gl_application_id
AND
gps.set_of_books_id = p_sob_id
AND
gps.closing_status IN ('O', 'F')
AND
p_accounting_date BETWEEN NVL (gps.start_date,
p_accounting_date)
AND NVL (gps.end_date,
p_accounting_date);
IF v_count > 0
THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END validate_gl_accounting_date;
