Skip to main content

How to add month in a GL Calendar - Oracle Apps R12

 Go to General Ledger ,Vision Operation (USA) < Setup 





Then Setup < Financials < Calendars < Accounting




Query (F11) "Accounting"  then press Ctrl + F11 







 Go to File < New and add a new line Accordingly.



Enter all mandatory field as required.




Now Save 






Finally,  Month added in Calendar.

 following Query cab help  to check the status of the Period Details -


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

Labels:

Comments

Post a Comment

Popular posts from this blog

Query to find concurrent programs associated to Responsibility - Oracle Apps R12

 Query to Find Programs associated to Responsibility SELECT frt.responsibility_name, frg.request_group_name,     frgu.request_unit_type,frgu.request_unit_id,     fcpt.user_concurrent_program_name     FROM fnd_Responsibility fr, fnd_responsibility_tl frt,     fnd_request_groups frg, fnd_request_group_units frgu,     fnd_concurrent_programs_tl fcpt     WHERE frt.responsibility_id = fr.responsibility_id     AND frg.request_group_id = fr.request_group_id     AND frgu.request_group_id = frg.request_group_id     AND fcpt.concurrent_program_id = frgu.request_unit_id     AND frt.LANGUAGE = USERENV('LANG')     AND fcpt.LANGUAGE = USERENV('LANG')     AND fcpt.user_concurrent_program_name = :conc_prg_name     ORDER BY 1,2,3,4
Post a Comment
Read more

Query to find Open PO Periods - Oracle Apps R12

 Query to Find Open PO Periods for Month End Closure SELECT sob.name "Set of Books" ,   fnd.product_code "Product Code" ,   ps.PERIOD_NAME "Period Name" ,   ps.START_DATE "Period Start Date" ,   ps.END_DATE "Period End Date" ,   DECODE(ps.closing_status, 'O','O - Open' ,                             'N','N - Never Opened' ,                             'F','F - Future Enterable' ,                             'C','C - Closed' ,'Unknown') "Period Status" FROM gl_period_statuses ps ,   Apps.GL_SETS_OF_BOOKS sob ,   FND_APPLICATION_VL fnd WHERE ps.application_id      IN (201) -- 101 GL & 201 PO  AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID AND fnd.application_id        = ps.appl...
Post a Comment
Read more

Query to Add Responsibility - Oracle apps R12

Use below query to add responsibility from backend   DECLARE     v_user_name        VARCHAR2 (20) := 'USERNAME';     v_req_resp_name    VARCHAR2 (50) := 'System Administrator';     v_description      VARCHAR2 (100) := 'Adding Responsibility to user using script';     v_appl_shrt_name   VARCHAR2 (20);     v_appl_name        VARCHAR2 (50);     v_resp_key         VARCHAR2 (50); BEGIN     SELECT fav.application_short_name,            fav.application_name,            frv.responsibility_key       INTO v_appl_shrt_name, v_appl_name, v_resp_key       FROM FND_APPLICATION_VL fav, FND_RESPONSIBILITY_VL frv      WHERE frv.application_id = fav.application_id            AND frv.responsibili...
Post a Comment
Read more