Purge Element Batch Error Lines/ How to Register Procedure in Oracle ERP?

While uploading an element entry batch using Web ADI and getting few Error lines, you can use the following Procedure to remove lines which contains errors. So that you can transfer successful lines.


Oracle ERP Payroll Delete Error Lines From Element Batch Entry 

Step 1: Create Following Procedure

CREATE OR REPLACE PROCEDURE APPS.ERROR_BATCH_LINE_DELTE_GTM
    (
    ERRBUF          OUT    VARCHAR2,
    RETCODE       OUT    VARCHAR2,
    BATCH_ID_P  IN        NUMBER                                      
    ) IS

BEGIN

    DELETE FROM PAY_BATCH_LINES WHERE BATCH_LINE_STATUS='E' AND BATCH_ID=BATCH_ID_P;
 
    COMMIT;
   
END;


Step 2: Now Register Procedure to EBS to make it available for the user:

Application Developer > Concurrent > Executable

Application Developer > Concurrent > Program

Parameter Form:

Note that your procedure have 3 parameters:

1 - ERRBUF is output parameter used for System Error Buffer. (Do not assign any value to this parameter)
2 - RETCODE is output parameter used to return Error Code.  (Do not assign any value to this parameter)
3 - BATCH_ID_P is input parameter used to Delete the specified batch. (Assign a value to this parameter)

Create a LOV which show batch element names and return Batch Id. Then assign to Program.