GL Transactions for Payments
SELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHAR (aca.check_date) invoice_date, …
Read MoreGL Transactions for AR
SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl.line_number) ponum_inv_linenum, rcl.description line_desc, TO_CHAR (rcl.quantity_invoiced) requestor_qty_inv, TO_CHAR…
Read MoreGL Transactions for AR Adjustments
SELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_customer_trx_all WHERE customer_trx_id = aaa.customer_trx_id) invoice_date, …
Read MoreGL Transactions for AP
SELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type, ent.transaction_number invoice_num, TO_CHAR (aia.invoice_date) invoice_date, TO_CHAR (pod.po_number) ponum_inv_linenum, …
Read MoreExtract for Payments – Check and EFT
SELECT papf.employee_number employee_number , aps.vendor_name payee_name , ieba.bank_account_num bank_account_number ,…
Read MoreSteps to Create Excel for Apps Report
GL Wand needs no desktop installation and it is very user friendly for creating many financial reports. It is a very good reporting tool for Oracle E-Business suite. Pre-Requisites :…
Read MoreERROR ORA -00980 Synonym Translation no longer valid
Error Message : ORA -00980 Synonym Translation no longer Valid. Error Area : it is related Database (Table/view) not related to forms When it happens : Synonym is in inconsistent…
Read MoreOATS Installation issue – Struck/Hang for Long Time
Installation Issue : ‘ Spawning C:OracleATSbindeploy.bat C:OracleATSinstalloats.ear’ and never completes for Long Time ( even for Days) When it Happen : While Installing OATS Software Action Needs to Taken…
Read MoreCreate a User in Oracle Load Testing (OLT)
How to Create a User for ORACLE Load Testing LogIn Clink on Start Button ? Oracle Application Testing Suite ?Administrator Login with Administrator User as shown below Note: Ensure DataBase…
Read MoreXML Publisher Report in Oracle Transportation Management (OTM)
Please follow the below steps to create XML Publisher Report in Oracle Transportation Management: Query Template Format Template Report Adding to SHIPMENT_MANAGER Report Group Now report appears under Shipment Management…
Read More