Fusion Global Payroll: Payroll Batch Loader Error "ORA-20001: Another Party of Party Usage Code (EXTERNAL_PAYEE) already for the given Registry ID (300000089)." (Doc ID 2202640.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Global Payroll - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to Create Third-Party Organization using Payroll Batch Loader (PBL),the following error occurs:

Sql exception while calling PAY_BATCH_LDR_PKG.PLSQL_BATCH_LINE_TRANSFERjava.sql.SQLException: ORA-20001: Another Party of Party Usage Code (EXTERNAL_PAYEE) already for the given Registry ID (300000089).
ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 2026
ORA-06512: at line 1


Load Batch Process:

1. Navigator > Payroll > Checklist
2. Select ‘Submit a Payroll Flow’
3. Select LDG from the List of values > select ‘load batch from’ from the Flow Pattern > click ‘NEXT’
4. Define Payroll Flow and batch name > click ‘Next’ button
5. Click ‘Next’
6. Click ‘Next’
7. Click ‘Submit’
8. Click ‘Ok and View Checklist’
9. Go to task
10. Click ‘+’ icon to add/upload a file
11. Click ‘browse’ to select the file that you are going to upload
12. Click ‘OK’
13. Click ‘DONE’
14. File was successfully loaded
15. Click ‘Go to task’ arrow to go to ‘Processes and report

Transfer Batch Process:

1. Go to task pane > Payroll Flows > Select a Submit a Process or report
2. Select LDG from the list of values then select ‘Transfer Batch’ from the flow pattern > click ‘next’
3. Define payroll flow and batch name > click ‘next’
4. Click ‘next’
5. Click ‘next’
6. Click ‘submit’
7. Click ‘OK and view checklist’
8. Validate ‘transfer batch’ tasks, status is error

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms