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.
Oracle MSCA/ MWA – Create Custom Page Read More »
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 Order Tables in Oracle Apps 11i and R12 Read More »
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 »
Emailing concurrent request output is a common requirement in any business. You can email a concurrent request output in Oracle Apps using Delivery Options while submitting the requestor using API FND_REQUEST.ADD_DELIVERY_OPTION or FND_DELIVERY. You should use this API when you are submitting a concurrent request from the backend using PL/SQL. I will explain how to
FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output Read More »
Oracle apps provide an option to define a concurrent program with a host as an execution option. For Linux, you can create a shell script and define the program on it. Many times a new developer ends with a Program exited with status 127 error while running the host-based concurrent program. In this article, let’s explore
Why you get program exited with status 127 error in Oracle Apps concurrent program Read More »
Oracle Apps uses OAF as one of the Technology to create a user interface. OAF is basically an HTML page that uses JavaScript and Java to process transactions. These transactions involves querying database, running SQL and PL/SQL packages from the OAF page. As OAF is used to design a user interface, a slow page frustrates
How to Enable Trace for OAF page in Oracle Apps Read More »
FND_FILE is a built-in package provided in Oracle Apps/E-Business Suite to write log and output files in PL/SQL concurrent program. This is actually a wrapper on UTL_FILE to write files on the Unix server. You can open the log and output file using navigation View -> Requests -> Find. Select the respective request on the
FND_FILE – create log and output file in Concurrent Program (Oracle Apps) Read More »