Daily Archives: July 30, 2026

Query to get the details of Invoice and Supplier Payment Method Mismatch in fusion.

WITH   FUNCTION f_payment_method_at_supplier (     p_vendor_id IN NUMBER   ) RETURN VARCHAR2 IS     payment_method VARCHAR2(250); — — This function will tell us payment method from supplier…

Read More

Query to get Sales Order in fusion.

SELECT dha.source_order_id AS sourcetransactionidentifier, dha.order_number AS sourcetransactionnumber, dha.source_order_system AS sourcetransactionsystem, dha.transactional_currency_code AS transactionalcurrencycode, TO_CHAR(dha.ordered_date,’YYYY/MM/DD HH24:MI:SS’) AS transactionon, dha.order_type_code AS transactiontypecode, dha.legal_entity_id AS requestinglegalentity, dha.partial_ship_allowed_flag AS partialshipallowedflag, dha.freeze_price_flag AS freezepricing, dha.freeze_shipping_charge_flag…

Read More

Managing REST Service Activities in Oracle E-Business Suite Using Ant Scripts

Introduction  Oracle E-Business Suite (EBS) provides the Integrated SOA Gateway (ISG) to expose business logic as REST and SOAP web services. As organizations promote integrations across Development, Test, UAT, and…

Read More

Using DBVERIFY (DBV) to Validate Oracle Datafiles in Oracle Database 19c Standalone

Introduction  Oracle Database stores all user and system data in datafiles. Although Oracle performs automatic integrity checks during normal database operations, physical corruption can still occur due to hardware failures,…

Read More