Expense report ORPHAN Record deletion with Script
Expense report ORPHAN Record deletion with Script Sometimes, we can see that the expense report can have some orphan events and this is system bug which will happen very…
Read MoreSynchronizing the Expense Report Status
Synchronizing the Expense Report Status Normally when any employee submits the expense report, it will go to the supervisor for approval and after the approval it will go for audit…
Read MoreAutomate configuration with the Data loader
Automate configuration with the Data loader Sometimes, data may be huge and need to push the data to the oracle applications. Either it may be transactional data and master…
Read MoreAccounts Payables Trial Balance Mismatch
Accounts Payables Trial Balance Mismatch Normally we will do the reconciliation between AP to GL to make sure our liability account/control account is matching in both Payables and General Ledger.…
Read MoreActive Suppliers with Payment terms and Payment Methods in EBS R12
Active Suppliers with Payment terms and Payment Methods in EBS R12 Business team or the vendor team will look for the active vendors which are associated with the payment…
Read MoreAutomate your payments from Oracle to Financial Institution
Automate your payments from Oracle to Financial Institution The overall purpose of the blog is to import payments information from Payables module to Bank of America web bank interface. There…
Read MoreSQL for Inactive Customer Open balance
SQL for Inactive Customer Open balance select * from apps.ap_expense_report_headers_all where report_header_id = ”; select * from hz_cust_accounts where account_number like ‘07724.0M978%’; select hca.account_number ,count(rct.trx_number) ,substr(to_char(rct.trx_Date,’DD/MM/YYYY’),4,2) ,sum(rgl.amount) ,sum(amount_due_remaining) OPEN_BL ,sum(rgl.amount)-sum(amount_due_remaining)…
Read MoreSQL to Extract Chart Of Accounts Mapping Records
SQL to Extract Chart Of Accounts Mapping Records- SELECT DISTINCT GL_FV.flex_value source_flex_value, CFH.parent_flex_value, CFH.child_flex_value_low, CFH.child_flex_value_high, GL_CSM.single_value target_flex_value, ‘N’ summary_flag FROM apps.fnd_flex_values GL_FV, apps.gl_cons_flex_hierarchies CFH, apps.gl_cons_segment_map GL_CSM WHERE GL_CSM.coa_mapping_id = 1320…
Read MoreSQL for Customer Accounts with PO and Bill To Location
SQL for Customer Accounts with PO and Bill To Location SELECT hcsa.LOCATION, hca.account_number ,oeh.order_number,oeh.cust_po_number FROM apps.hz_cust_site_uses_all hcsa, apps.hz_cust_acct_sites_all hcas, apps.hz_party_sites hps, apps.hz_parties hp, apps.hz_cust_accounts hca, apps.oe_order_headers_all oeh WHERE 1…
Read MoreSQL for Customer Account with Price List
SQL for Customer Account with Price List select hca.account_number ,hp.party_name , hps.party_site_number –,hl.city –,hl.state ,qplh.name price_list_name ,trim(to_char(qplh.start_date_active,’DD-Month’))||’-‘||trim(to_char(qplh.start_date_active,’YYYY’)) price_list_effective_date –,qplh.end_date_active ,msib.segment1 bill_code ,msib.description Bill_code_desc ,qpll.operand rate from apps.hz_cust_accounts hca , apps.hz_parties…
Read More