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 MoreThe 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 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 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 MoreOpen 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’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 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 MorePurchase 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 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 MorePayables Accounting Entries Report Description The report lists in detail any transactions that have been accounted with error and all entries that could not be transferred to the general ledger…
Read More