Skip to main content

Posts

Showing posts from April, 2016

How can be add month in calendar or defining new fiscal year in oracle apps R12

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 applica