Customer Contact Details in EBS
Introduction: This blog has the SQL query that can be used to pull the data Organization contact details. Cause of the issue: Business wants to reach the organization contact…
Read MoreSQL Loader using External table
Introduction: This blog has the SQL loader using external Table. Cause of the issue: Business wants to load the data with a field having multiple line we can use this…
Read MorePANCARD Validation – PL/SQL Function
1. Overview When we give PANcard, We are returning PANcard is valid or not. 2. Technologies and Tools Used The following technology has been used to achieve the expected output.…
Read MoreDynamic List of values (LOV)
1.Overview LOVs can be displayed by end user request (when an LOV is available), Most of the user does not know the item have LOV option. For this we add…
Read MoreService contract reconciliation Report
SELECT okha.sts_code,okha.scs_code,okha.date_approved,okha.estimated_amount, xscb.price_list_id, xscb.customer_bill_to_number, xscb.customer_ship_to_number, xscb.contract_number, xscb.contract_type, xscb.cognomen, xscb.start_date, xscb.end_date, qslh.NAME AS price_list_name, ood.organization_code AS inventory_org_code, hou.NAME AS operating_unit_name, customer, xscb.payment_term, NULL price_list, line_item, DECODE (TRIM (xscb.err_msg), ‘/’, ‘SUCCESS’, xscb.err_msg)…
Read MoreAR invoice details
Introduction: This SQL query is used to fetching the details of an institution Based on their requirements overview: this query gives AR invoice details ELECT SUM(rcl.unit_selling_price* rcl.quantity_invoiced) FROM…
Read MoreAP PO Accrual Reconciliation Process
Introduction: Oracle Payables – Version 12.1.3 and later Information in this document applies to any platform. Cause of the issue: This note provides basic step to setup and run the AP…
Read MoreFetching and Parsing Data from Other Online Source To Oracle Database Using Web service in Oracle Apex
Overview This Document will Explain How to Fetch and Parse Data from Other Online Source To Oracle Database Using Web service in…
Read More