Benefits of Oracle Cloud Fusion ERP – Financials
Are you looking for a modern and streamlined approach to financial management? Oracle Cloud Fusion ERP – Financials could be the solution for you. Here are six benefits of Oracle…
Read MoreHow Oracle Cloud A1 and platformOS are impacting DevOps?
To extend its PaaS (platform-as-a-service) creator community to Oracle Cloud Infrastructure’s Ampere A1 computing from Arm, Oracle Cloud Infrastructure (OCI) has announced a strategic agreement with platformOS. PlatformOS makes it…
Read MoreCREATE A NEW PARTITION IN RUNNING ORACLE LINUX SERVER
Description: Already we have created partition while installed the operating system. But after installation, we need a new one partition means we have to do some configuration in it. So…
Read MoreQuery 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 More