Data definition and templates are the main backbone of XML Publisher reports in Oracle Apps. Each data and template definition is unique. Once defined, you… Read More »How to Delete Data Definition and Template in XML Publisher (Oracle Apps)
Oracle BIP (Business Intelligence Publisher) is a reporting tool that allows users to create, manage, and deliver various types of reports, such as operational, financial,… Read More »How to Burst BI Publisher report to UCM (Content Server) in Oracle Cloud (Fusion)
Latin American Countries like Mexico, Brazil and others have country-specific requirement (legal, financial, or cultural contexts) commonly called as localization. For example, in Mexico SAT… Read More »Localization in Oracle Cloud: An Insight into Latin America Cloud Local Solution (LACLS)
The Workflow Background Process is a concurrent program in Oracle Apps that helps you to process workflow activities that are typically deferred, timed out, or… Read More »Workflow Background Process in Oracle Apps: In-Depth Overview
Oracle Mobile Supply Chain Applications (MSCA) enables automated mobile user operations. You can receive PO, RMAs, internal requisitions, and in-transit shipments. order picking, labeling, and… Read More »Oracle MSCA/ MWA – Create Custom Page
FND_GLOBAL.APPS_INITIALIZE is an API in Oracle Apps to initialize the session. This is required to set up global variables, profile values, and the global security… Read More »How to initialize session in Oracle Apps using FND_GLOBAL.APPS_INITIALIZE
Move orders are basically requests for the movement of material within a single organization. You create a move order, approve and then transact it. Data… Read More »Move Order Tables in Oracle Apps 11i and R12
Move orders play an important role in a warehouse or facility. They help planners and facility managers to request the movement of material for purposes… Read More »Which are the different Move Order Type in Oracle Apps?
A Move Order in Oracle Apps has statuses like Incomplete, Approved, or Pre Approved, etc. Oracle maintains information about move order in MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES… Read More »Move Order Header and Line Status (1,2,3…9) in Oracle Apps
DUP_VAL_ON_INDEX is a pre-defined exception in PL/SQL which is raised when a program attempts to store duplicate values in a database column that is constrained by… Read More »DUP_VAL_ON_INDEX Exception in PL/SQL