How can add a month in the calendar or defining new fiscal year in oracle apps R12
Or
How can add an Adjustment Period in Calendar
How can add a month in the calendar or defining new fiscal year in oracle apps R12
Or
How can add an Adjustment Period in Calendar
Go to General Ledger ,Vision Operation (USA) < Setup
Then Setup < Financials < Calendars < Accounting
Now Query (F11) "Accounting" then press Ctrl + F11
Now Go to File < New and add a new line Accordingly.
Fill all mandatory field as required.
Now Save
Finally, Your's Month added in Calendar.
Note -: Use the following Query to check the status of the Periods Details accordingly :
select a.period_name,
a.period_num,
a.gl_status,
b.po_status,
c.ap_status
from
(select period_name, period_num,
decode(closing_status,'O','Open',
'C','Closed',
'F','Future',
'N','Never',
closing_status) gl_status
from gl_period_statuses
where application_id = 101
and start_date >= '01-JAN-98
and end_date < '01-JAN-99'
and set_of_books_id = &&set_of_books_id) a,
(select period_name,
decode(closing_status,'O','Open',
'C','Closed',
'F','Future',
'N','Never',
closing_status) po_status
from gl_period_statuses
where application_id = 201
and start_date >= '01-JAN-15'
and end_date < '01-JAN-16'
and set_of_books_id = &&set_of_books_id) b,
(select period_name,
decode(closing_status,'O','Open',
'C','Closed',
'F','Future',
'N','Never',
closing_status) ap_status
from gl_period_statuses
where application_id = 200
and start_date >= '01-JAN-15'
and end_date < '01-JAN-16'
and set_of_books_id = &&set_of_books_id) c
where a.period_name = b.period_name
and a.period_name = c.period_name
order by a.period_num
“A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide .
