How can be add month in calendar or defining new fiscal year in oracle apps R12
How can add month in calendar or defining new fiscal year in oracle apps R12
Or
How can add an Adjustment Period in Calendar
How can add month in 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 add 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 .
