Introduction: The waybill number is a key reference for tracking shipments. To avoid errors and maintain consistency, the field will now be restricted to accept only alphanumeric characters and dashes.…
Read MoreIntroduction/ Issue: Oracle Cloud Redwood UI brings a modern interface, but certain key calculations like the “Total Amount” (sum of Released Amount and Agreed Amount) are not available out of…
Read MoreIntroduction: This blog has the SQL query and View query that can be used for Frozen Inventory Value Report–All Types in Oracle Apps R12. Cause of the issue: Business wants a PLSQL-based…
Read MoreIntroduction: Step by step process of creating OAuth 2.0 instance from OCI. Why we need to do: OAuth 2.0 is essentially a secure permission-granting framework — it lets one…
Read MoreIntroduction: Migrating personalization from ADF page (Classic UI) to Redwood UI Why we need to do: Oracle is modernizing its Fusion Applications UI/UX, and ADF pages are being phased…
Read MoreIssue: The AR transaction types are being wrongly picked up from the Sales order. Case 1: Sales order type “SAMPLE-TOYS” should generate AR transactions with Invoice-No charge receivables transactions type.…
Read MoreIntroduction: This blog has the PLSQL query that can be used to create Quality Test & Quality Test Values using oracle seeded API. Cause of the issue:…
Read MorePatching Oracle E-Business Suite (EBS) application tier technology components has always been a delicate balance of precision, downtime planning, and repeatability. To ease this process, Oracle provides a specialized utility:…
Read MoreERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manual Reconciliation – 1 to 1, 1 to…
Read Moredeclare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;
Read More