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 can not use the same name/code for others. First, you define the data definition and then the template. So, when you want to delete, you need to follow the reverse […]
How to Delete Data Definition and Template in XML Publisher (Oracle Apps) Read More »
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, and analytical reports, based on data from different sources like databases, web services, or applications. It can deliver the output to different channels like printers, Fax, email, WebDav, HTTP, FTP,
How to Burst BI Publisher report to UCM (Content Server) in Oracle Cloud (Fusion) Read More »
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 provides a INPC fator to apply to asset depreciation amounts and generate accounting according SAT requirements. These are legal, financial requirments and differs county to county. For specific regional needs,
Localization in Oracle Cloud: An Insight into Latin America Cloud Local Solution (LACLS) Read More »
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 stuck. Workflow activities involve Order Management Approval, PO Approval, etc. These are important flows in business. This program makes sure that these are processed. There are a total of four
Workflow Background Process in Oracle Apps: In-Depth Overview Read More »
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 shipping support for Orders created in Oracle Order Management using hand-held radio frequency (RF) devices and lift truck-mounted RF scanners. There are already standard oracle MSCA/MWA pages for these operations.
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 context for a database session. In simple terms, when you want to call any Oracle Apps public API outside the EBS environment like SQL * Plus, Toad, or SQL Developer, use
How to initialize session in Oracle Apps using FND_GLOBAL.APPS_INITIALIZE Read More »
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 flows from different tables during the overall process. Here we are going to see the minimum basic information of the Move Order Table in Oracle Apps. The purpose here is
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 like replenishment, material storage relocations, and quality handling. In Simple terms, Move orders are requests for the movement of material within a single organization. Move Orders are manual or automatic
Which are the different Move Order Type in Oracle Apps? Read More »
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 tables. The first is the header table and the second is the lines table. HEADER_STATUS is the column in MTL_TXN_REQUEST_HEADERS and LINE_STATUS in the MTL_TXN_REQUEST_LINES table which shows the header and
Move Order Header and Line Status (1,2,3…9) in Oracle Apps Read More »
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 a unique index. The name itself explains what this exception is all about. Duplicate Value on Index column The main reasons for the DUP_VAL_ON_INDEX exception are: Unique Index Constraint: When a