P45 Not Being Produced - "The HRX GB P45 ADDRESS RECORD record is not extracted because the required EMPLOYEE_POSTCODE data element is missing" (Doc ID 2250981.1)

Last updated on APRIL 03, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Global Payroll

When attempting to run P45, the following error occurs.
P45 not being produced for an employee who was a leaver 9/9/16 so we expected a P45 to be produced in October but no P45 was produced and we could not identify why. Testing done in January has now allowed us to identify that there was an error buried in the log files that the postcode was missing. His Primary Address is not a UK Address as he has now moved to the Czech Republic but he does have a valid Czech postcode.

ERROR
-----------------------
"Name PAY_REPPR_MISSING_REQ_ELEMENT
Token1 EMPLOYEE_POSTCODE
Token2 HRX GB P45 ADDRESS RECORD
Token3 null
The HRX GB P45 ADDRESS RECORD record is not extracted because the required EMPLOYEE_POSTCODE data element is missing.
Name PAY_PAYPROC_UNKNOWN_ERR
Token1 null
Token2 null
Token3 null
A system error occurred during processing.
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-20001: Formula EXT_HRX_GB_P45_ADDRESS_RECORD, line 177, user-defined function error The HRX GB P45 ADDRESS RECORD record is not extracted because the required EMPLOYEE_POSTCODE data element is missing.. Details: A function call raised an error during formula execution.
ORA-06512: at "FUSION.FF_EXEC", line 3769
ORA-06512: at "FUSION.FF_EXEC", line 3779
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2055
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1937
ORA-06512: at line 1

Token3 20
Error ORA-20001: Formula EXT_HRX_GB_P45_ADDRESS_RECORD, line 177, user-defined function error The HRX GB P45 ADDRESS RECORD record is not extracted because the required EMPLOYEE_POSTCODE data element is missing.. Details: A function call r
Name null
Token1 null
Token2 null
Token3 null
ORA-20001: Formula EXT_HRX_GB_P45_ADDRESS_RECORD, line 177, user-defined function error The HRX GB P45 ADDRESS RECORD record is not extracted because the required EMPLOYEE_POSTCODE data element is missing.. Details: A function call raised an error during formula execution.
ORA-06512: at "FUSION.FF_EXEC", line 3769
ORA-06512: at "FUSION.FF_EXEC", line 3779
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 2055
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1937
ORA-06512: at line 1

PLSQL Log Messages
End PLSQL Log Messages

oracle.apps.hcm.batchProcesses.core.publicProcess.SystemExtract.Process(SystemExtract.java:313)
oracle.apps.hcm.batchProcesses.core.publicProcess.PayObjArchWU.Process(PayObjArchWU.java:122)
oracle.apps.hcm.batchProcesses.core.publicProcess.BatchProcessWU.runProcess(BatchProcessWU.java:152)
oracle.apps.hcm.batchProcesses.core.publicProcess.ProcPayAction.Process(ProcPayAction.java:1262)
oracle.apps.hcm.batchProcesses.core.publicProcess.ProcArchPayAct.Process(ProcArchPayAct.java:247)
oracle.apps.hcm.batchProcesses.core.publicProcess.ProcPayAction.runProcess(ProcPayAction.java:563)
oracle.apps.hcm.batchProcesses.core.publicProcess.BatchProcessPA.runProcess(BatchProcessPA.java:2182)
oracle.apps.hcm.batchProcesses.core.publicProcess.BatchProcWorkerPA.Process(BatchProcWorkerPA.java:119)
oracle.apps.hcm.batchProcesses.core.publicProcess.PayProcHandler.InternalStartup(PayProcHandler.java:381)
oracle.apps.hcm.batchProcesses.core.publicProcess.PayProcHandler.execute(PayProcHandler.java:491)
oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.executeHelper(ExecutableWrapper.java:99)
oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(ExecWrapperBase.java:163)
oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.execute(ExecutableWrapper.java:86)
oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:392)
oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)
oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:242)
oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run 45
2. Check log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot issue the P45 for the employee (mandatory)

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