PAYUSETW Fails to Generate with "wrong number or types of arguments in call to 'GET_OR_UPDATE'"
(Doc ID 2575304.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle HRMS (US) - Version 12.2 to 12.2 HRMS RUP14 [Release 12.2]Oracle HRMS (US) - Version 12.1.1 to 12.1 HRMS RUP13 [Release 12.1]
Information in this document applies to any platform.
Symptoms
Problem Statement:
Generating PAYUSETW.fmx fails with the error below.
ERROR generating form "forms/US/PAYUSETW.fmx" from input file /XXX/fs1/EBSapps/appl/au/12.0.0/forms/US/PAYUSETW.fmb
Compiling procedure P_STATE_DETAIL...
Compilation error on procedure P_STATE_DETAIL:
PL/SQL ERROR 306 at line 17, column 3
wrong number or types of arguments in call to 'GET_OR_UPDATE'
PL/SQL ERROR 0 at line 17, column 3
Statement ignored
PL/SQL ERROR 306 at line 32, column 3
wrong number or types of arguments in call to 'GET_OR_UPDATE'
PL/SQL ERROR 0 at line 32, column 3
Statement ignored
Plus a bunch more errors just like this in the same file.
Compiling procedure P_STATE_DETAIL...
Compilation error on procedure P_STATE_DETAIL:
PL/SQL ERROR 306 at line 17, column 3
wrong number or types of arguments in call to 'GET_OR_UPDATE'
PL/SQL ERROR 0 at line 17, column 3
Statement ignored
PL/SQL ERROR 306 at line 32, column 3
wrong number or types of arguments in call to 'GET_OR_UPDATE'
PL/SQL ERROR 0 at line 32, column 3
Statement ignored
Plus a bunch more errors just like this in the same file.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Apply patch:29813756 (Q2 2019 SPWL & JIT STATUTORY UPDATE)
- Form fails to generate.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |