Oracle Application Blog

Exporting Plan Data in Oracle Fusion Supply Chain Planning

Introduction/ Issue:  In Oracle Fusion Supply Chain Planning, planners often need to extract plan measure data from demand or supply plan layouts for reporting and analysis outside the application. Instead…

Read More

Oracle ERP Cloud Period Close Procedures & Runbook Considerations

Introduction/ Issue:  Oracle ERP Cloud customers have a need to close their books every period, quarter and/or year.   This paper provides guidance on the period-end close procedures for Oracle Cloud…

Read More

Oracle Forms Personalization – Validating a Record Input

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 More

How to Customize the Purchase Agreement Page in Oracle Redwood UI

 Introduction/ 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 More

Frozen Inventory Value Report–All Types in Oracle Apps R12.

Introduction: 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 More

OAuth 2.0 Setup from OCI

Introduction: 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 More

Personalization Migration: ADF to Redwood Page

Introduction: 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 More

AR Transaction Type Mapping from Sales Orders

Issue:  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 More

Procedure to create Quality Test & Quality Test Values in OPM through API

    Introduction: 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 More

Streamlining Oracle EBS Application Tier Patching with ETPAT-AT

Patching 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 More