Create 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 MoreOpenReceipt Report DescriptionThis Open Receipt Re…
Open Receipt Report Description This Open Receipt Report is used to review a list of receipts which are in open status for the date range that you specify. SELECT coll.coll_name…
Read MoreLearning Pentaho It’seasy to start and learn Penta…
Learning Pentaho It’s easy to start and learn Pentaho on its own. In-build sample code and easy to connect various database with drag and drop option base on Java. Adding…
Read MoreAR Selected InvoicesPrintDescriptionQueries t…
AR Selected Invoices Print Description Queries to get AR Selected Invoices. /* Adjustments */ SELECT line_adjusted adj_line, tax_adjusted adj_tax, freight_adjusted adj_freight, adj.amount adj_amount, l1.meaning adj_type, l2.meaning…
Read MorePurchaseOrder (With Requisition Preparer) D…
Purchase Order (With Requisition Preparer) Description To fetch the Purchase Order along with Requisition Preparer details we can use the following queries. /* Query 1 To Fetch Cancel PO*/ SELECT…
Read MoreAccounts Payable Trial BalanceReportDescriptionAcc…
Accounts Payable Trial Balance Report Description Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payables equal those in the general ledger. Before closing a…
Read More