Apps

How To Download & Install Oracl...

Which are the different Move Order Type in Oracle Apps?

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 »

Move Order Header and Line Status (1,2,3…9) 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 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 …

Move Order Header and Line Status (1,2,3…9) in Oracle Apps Read More »

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output

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 Workflow Error – 1700: Could not connect with username/password ‘abc/[email protected]’ (‘ORA-28040: Message 28040 not found; product=RDBMS; facility=ORA’)

1700: Could not connect with username/password ‘abc/[email protected]’ (‘ORA-28040: Message 28040 not found; product=RDBMS; facility=ORA’) error is specific to Oracle Workflow when you try to connect Workflow builder client to remote Oracle Database. Why this error is coming? That is what we are going to brainstorm in this article. Let’s get started… Why error? The latest …

Oracle Workflow Error – 1700: Could not connect with username/password ‘abc/[email protected]’ (‘ORA-28040: Message 28040 not found; product=RDBMS; facility=ORA’) Read More »

Why you get program exited with status 127 error in Oracle Apps concurrent program

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 …

Why you get program exited with status 127 error in Oracle Apps concurrent program Read More »

How to create log and output file using FND_FILE in Oracle Apps Concurrent Program

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 …

How to create log and output file using FND_FILE in Oracle Apps Concurrent Program Read More »

How to Create, Disable user, Add Responsibility and Reset Password in Oracle Apps from Backend

FND_USER_PKG is built-in API in Oracle apps for user management from the back-end. In this article, I will share how to use this API for common user management task like user creation, reset password, adding and deleting responsibility. There are many methods available, but mostly we will focus on common methods. create_user Use this API …

How to Create, Disable user, Add Responsibility and Reset Password in Oracle Apps from Backend Read More »

FNDLOAD and XDOLoader to Manage, Download and Upload files

FNDLOAD and XDOLoader are utilities provided in Oracle Apps to download/upload AOL object definition and template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publisher database tables. Oracle XML Publisher Oracle XML Publisher is XML and template-driven tool to design reports in Oracle Applications. You can use Microsoft Word/Excel or Adobe PDF …

FNDLOAD and XDOLoader to Manage, Download and Upload files Read More »