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 »

How to Install SQL Developer on Linux (Red Hat, Fedora, Oracle, Centos, Rocky Linux)

SQL Developer is a free and integrated development tool that you can use to develop and manage Oracle Database. It even works with cloud databases as well. This tool offers all the features developers need to design, develop, and debug PL/SQL applications. This is a cross-platform application which means it is available for Windows, macOS, …

How to Install SQL Developer on Linux (Red Hat, Fedora, Oracle, Centos, Rocky Linux) Read More »

How to download Software/Tools from Oracle Site for Free

Oracle provides most of the developer tools free to use for learning and education purposes. You only need Oracle Account to download this software. So in this article, let’s see how to download software from Oracle. Note:- You can not use these software for commercial purposes. Software/Tools by Oracle Oracle Corporation, a multinational computer technology company …

How to download Software/Tools from Oracle Site for Free 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 »