testoag

Query to find Is an employee also a buyer or not In Oracle Apps R12? Query - SELECT pa.agent_id, papf.person_id, papf.employee_number, papf.email_address,        pa.category_id, pa.location_id, papf.effective_start_date,        papf.effective_end_date   FROM po_agents pa, per_all_people_f papf, hr_all_organization_units haou  WHERE pa.agent_id = papf.person_id    AND papf.business_group_id = haou.business_group_id    AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                            AND papf.effective_end_date --AND    email_address = 'user@oag.com' --AND PAPF.EFFECTIVE_END_DATE > SYSDATE --AND HAOU.BUSINESS_GROUP_ID = 100 “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, Bu...

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

Error "You have exceeded the transaction quantity".  Applies to:  Information in this document applies to any platform. FORM:RCVRCERC.FMB - Enter Receipts GUI FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI FORM:RCVTXERE.FMB - Enter Returns GUI FORM:RCVTXECO.FMB - Enter Corrections GUI "You have exceeded the transaction quantity" Symptoms: "You have exceeded the transaction quantity" Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG Steps: Go to Receiving Screen Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005) Go to Lot/Serial form Enter lot number and qty as 7200.00001 (which was rounded to 5 digits) The message "you have exceeded the transaction quantity " Cause Can Be-: a) Restriction of precision support up to 6 decimal places was added for the quantity field  b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to...

Resolving Period Close Pending Transaction R12 (Doc ID 1069492.1) APPLIED ON:- Oracle Cost Management - Version 12.0.0 and later Oracle Shipping Execution - Version 12.0.0 and later Oracle Purchasing - Version 12.0.0 and later Oracle Work in Process - Version 12.0.0 and later Oracle Inventory Management - Version 12.0.0 and later PURPOSE:- Troubleshooting Pending Transactions TROUBLESHOOTING STEPS:- 1 -: VIEWING PENDING TRANSACTIONS 2-:  UNPROCESSED MATERIAL TRANSACTIONS 3-:  Uncosted Material/WSM Transactions 4-:  Pending WIP Costing transactions 5-:  Pending WSM interface 6-:  Pending LCM Interface Transactions Resolution Recommended Transactions 1-:  Pending Receiving Transactions 2-:  Pending Material Transactions 3-:  Pending Shop Floor Move 4-:  UNPROCESSED SHIPPING TRANSACTIONS Conclusion: The key steps to resolving pending transactions are: -Locate the transactions -Find the error message to determine what is preventing the tr...