HCKT Hard Limit Reached Events in Fusion
Introduction This Post illustrates the steps required to HCKT Hard Limit Reached Events in Fusion Script to HCKT Hard Limit Reached Events in Fusion Purpose Purpose of the report is to…
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 period, you can compare the…
Read MorePurchase Order (With Requisition Preparer)
Introduction To fetch the Purchase Order along with Requisition Preparer details, we can use the following queries. /* Query 1 To Fetch Cancel PO*/ SELECT action_date cancel_po_date FROM po_action_history pah WHERE pah.object_id = :poh_po_header_id AND ( ( …
Read MoreAR Selected Invoices Print
Introduction This script is used Queries to get AR Selected Invoices. Query to using for AR Selected Invoices print. /* Adjustments */ SELECT line_adjusted adj_line, tax_adjusted adj_tax, freight_adjusted adj_freight, adj.amount adj_amount, l1.meaning…
Read MoreProject Details – Auditor Query – FUSION
Introduction This Post illustrates the steps required to get Project Details in fusion Application. Script to Project Details in FUSION SELECT DISTINCT PPA.project_status_code ,HOU.name organization_name ,PPA.description ,OCT.name contract_type ,PPT.project_type ,PPA.segment1…
Read MoreOpen Receipt Report
Introduction This Open Receipt Report is used to review a list of receipts which are in open status for the date range that you specify. Script used for Open Receipt…
Read MoreQuery for Project Unbilled Balances – FUSION
Introduction This Post illustrates the steps required to get Project Unbilled Balances in Fusion Application. .Script to Project Unbilled Balances in Fusion Application. WITH FUNCTION get_rev_todate_amt ( p_contract_id IN NUMBER,…
Read MoreQuery to find open invoices with the Supplier and PO details
Introduction This Post is about Query to find open invoices with the Supplier and PO details in Oracle EBS R12. Script to find open invoices with the Supplier and…
Read MoreQuery to get the Menu and Submenu list against a responsibility in oracle apps
Introduction This Post illustrates the steps required to get the Menu and Submenu list against a responsibility in Oracle EBS R12. Script t0 get the Menu and Submenu list against a…
Read MoreQuery to AP Supplier Invoices in FUSION
Introduction This Post illustrates the steps required to get the AP Supplier Invoices in – FUSION Application Script to AP Supplier Invoices query – FUSION SELECT gp.period_name, (SELECT ‘Q’ ||…
Read More