What is the use of errbuf and RETCODE in oracle apps?

What is the use of errbuf and RETCODE in oracle apps?

Use errbuf to return any error messages, and retcode to return completion status. The parameter retcode returns 0 for success, 1 for success with warnings, and 2 for error.

What does Retcode mean?

RETCODE: is used to get the status of the concurrent program. It can take any of the following values. 0 – Concurrent Program is successful. 1 – Concurrent program completed with warning.

How do you register a procedure as a concurrent program?

This is my step-by-step:

1. create package in pl/sql.
2. create procedure in pl/sql.
3. test the procedure > working fine, txt file created in the database server directory.
4. create concurrent executable.
5. create concurrent program.
6. assigned program to request.
7. run the request > completed normal.

What are the two parameters that are mandatory for PL SQL type concurrent program?

2 Mandatory Parameters in PL/SQL for Concurrent Program

• 0 – Concurrent Program is completed Normal.
• 1 – Concurrent program is competed with Warning. Status for these programs is shown in Yellow color.
• 2 – Concurrent Program is errored. Status of these programs is shown in Red color.

What is a concurrent program in Oracle Apps?

In Oracle Applications, concurrent programs are system batch jobs that retrieve and push data between Oracle applications and the database. Concurrent programs can be comprised of a single request or a request set containing more than one concurrent program.

How do I register a procedure as a concurrent program in Oracle Apps?

2. Name: Enter the concurrent program /set name….

1. Create Procedure: Let’s create a procedure that will take input as Item name and returns the respective Item ID.
2. Create Executable: Navigation: System Administrator / Application Developer responsibility > Concurrent > Executable.
3. Create Program:
4. Assign to Request Group:

What is the use of Sqlcode?

The function SQLCODE returns the number code of the most recent exception. For internal exceptions, SQLCODE returns the number of the associated Oracle error. The number that SQLCODE returns is negative unless the Oracle error is no data found, in which case SQLCODE returns +100 .

What is create concurrent program in Oracle Apps with example?

Create Concurrent Program

1. Navigate to concurrent program (CP) screen.
2. Eneter Name for CP. Short Name should be same as short name of executable. (It’s Best Practice).
3. Check the enable check box. Select executable name from LOV.
4. Select the output format for CP.
5. Define Parameter. For each Parameter. Select the Value Set .

How do I create a concurrent program in Oracle Apps?

Create Concurrent Program: Link to it executable defined in previous step. Enter Parameters and link Value Sets. Assign the registered Concurrent Program to a request group.

How do I register a stored procedure in Oracle Apps?

Register PL SQL stored procedure in Oracle Apps

1. Create procedure.
2. Create Executable.
3. Create Program.
4. Add this program to the required request group.