GL 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 MoreTOOL-TIP FOR THE REPORT COLUMN
The tool-tip displaying report column while hovering on the another report column. STEP 1: l ENAME, DEPARTMENT and MANAGER is the report Column. l Make the ENAME column’s display type…
Read MorePerformance Using hint
Performance issue. The issue was due to joins across remote sites where oracle optimizer might Wrongly choose the driving site. This can be resolved by using driving site hint. It is always good to do all manipulations in one site and fetch the final Results to the target site. QUERY EXCEUTED IN DATA BASE 2 Select t1.column1, t2.column2, t2.column3 From table1 t1, xxsc.table2@db1todb2 t2 Where t1.column1 = t2.column1 Query which was taking around 47 msecs for execution. QUERY EXCEUTED IN DATA BASE 2 Select /*+driving_site(t2)*/ t1.column1, t2.column2, t2.column3 From table1 t1, xxsc.table2@db1todb2 t2 Where t1.column1 = t2.column1 Query which was taking around 15 msecs for execution.
Read MoreQuery to find open invoices with the Supplier and PO details
Query to find open invoices with the Supplier and PO details SELECT i.invoice_num “Invoice Number”, (SELECT MAX (pha.segment1) po_number FROM apps.ap_invoices_all aia, apps.ap_invoice_lines_all aila, apps.ap_invoice_distributions_all aida,…
Read More