Procedure :- “ADD_LIST_ELEMENT‘” Using the following procedure Syntax ADD_LIST_ELEMENT(list_id ITEM, list_index VARCHAR2, list_label VARCHAR2, list_value VARCHAR2); Syntax Specifications list_id: Specifies the unique ID that Oracle Forms assigns…
Read MoreCreate a Timer: Declare a variable of timer data type. Initialize a variable with one second number data type. Use a CREATE_TIMER built-in with the timer’s name, interval and it’s…
Read MoreIntroduction: In Oracle Order Management, We have two Shipping methods post Sales Order creation, Full Shipment and Partial Shipment. They are carried out by specifying the quantity while creating Shipment in OMS (Fusion). In this blog we will…
Read MoreIntroduction: Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF pages have traditionally been used to develop enterprise-grade web applications…
Read MoreOracle Cloud Infrastructure’s Identity and Access Management (IAM) service now supports explicit deny policies, providing administrators with the ability to explicitly block unwanted actions and enforce more precise access controls…
Read MoreIntroduction/ 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 MoreIntroduction/ 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 MoreIntroduction: 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 More