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

Database /

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

Database /

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 headquartered

How to download Software/Tools from Oracle Site for Free Read More »

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output

Apps /

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/pqr@database’ (‘ORA-28040: Message 28040 not found; product=RDBMS; facility=ORA’)

Apex /

1700: Could not connect with username/password ‘abc/pqr@database’ (‘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. What is 1700: Could not connect with

Oracle Workflow Error – 1700: Could not connect with username/password ‘abc/pqr@database’ (‘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

Apps /

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 »

FND_FILE – create log and output file in Concurrent Program (Oracle Apps)

Apps /

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 »

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

Apps /

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 »