testoag

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',       ...

How can Open Oracle Apps General Ledger Period in Oracle Apps R12 Or  Step to Open Oracle Apps General Ledger  Period   in Oracle Apps R12 Note -: Whenever you do Receive inventory transactions, you often get errors if your Inventory/ purchasing/ GL periods are not open. Here is the navigation where you can set up the periods for your material receipts: Go to Setup > Financial > Accounting > Open and Close periods -OR- Setup > Open and Close periods Click On Open/Close  Select Ledger Name and Period Accordingly  Click On Open Periods  Choose Target Period  Once Check the Concurrent Program Status. Now Your's General Ledger Period Opened.  Ensure that the  GL Period has Open status. How can Open Oracle Apps Inventory  Period   in Oracle Apps R12 Or  Step to Open Oracle Apps Inventory  Period   in Oracle Apps R12 Go to Inventory >  Accounting close cycle > Inventory Accounting Periods Choose Re...

Complete relation Query for SLA(Sub Ledger Accounting _XLA), AP(Account Payable) and GL(General Ledger) Links in oracle apps r12  Or  Link Between AP(Account Payable), GL(General Ledger) and SLA(Sub Ledger Accounting _XLA) SELECT DISTINCT GJH.PERIOD_NAME, TRUNC (GJH.CREATION_DATE) GL_DATE,                 GJH.JE_SOURCE, GJH.JE_CATEGORY, GJH.CURRENCY_CODE,                 GJL.DESCRIPTION, GJL.REFERENCE_5, GJL.REFERENCE_10,                 GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, GJL.EFFECTIVE_DATE,                 GJL.REFERENCE_1, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3,                 GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7,                 AERLA.JUSTIFICATION, AERLA.PROJECT_NUMBER,             ...

How to release REC EXCEPTION [Receiving Exception] hold on invoices in R12 Follow given steps to implement the solution in your instance follow the below steps: 1-: Go to Purchasing Application 2-: Receipts and query the Receipt [which is created against the PO] 3-: Now Check Receiving Exception check box is unchecked. [It should be unchecked] Note -: if Receiving Exception check box is not available then do the Show Field and choose Receiving Exception then check. 4-: Now revalidate the invoice to release the hold. Solution For -: How to release REC EXCEPTION [Receiving Exception] hold on invoices Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1] For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide