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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction This Post illustrates the steps required to get the AP – Employee invoices query FUSION Application Script to AP – Employee invoices query – FUSION SELECT gp.period_name,…
Read MoreIntroduction This Post is about to ORA -00980 Synonym Translation no longer valid Error in Oracle EBS R12. Error Message : ORA -00980 Synonym Translation no longer Valid. Error…
Read MoreIntroduction This Post illustrates the steps required to GL Transactions for AR Adjustments in Oracle EBS R12. Script to GL Transactions for AR Adjustments. SELECT NULL trans_type, ent.transaction_number invoice_num,…
Read More