Query to get Lease assets – Oracle EBS to Fusion
Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query: SELECT fb.book_type_code…
Read MoreCustomer 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 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 MoreCREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG
CREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG PRIMARY CATALOG HOSTNAME 192.168.1.33 192.168.1.21 DB PORT 1521 1525 DB NAME VIYANI CATDB In Oracle, A catalog is a collection of…
Read More