Error loading seed data for WF_ROLE: ROLE_NAME = ZZZ_LAST_DUMMY_ROLE,

I encountered an error while applying the newly merged 12.2.0 upgrade driver using the following command:

adpatch options=nocopyportion,nogenerateportion


The error message:
There are now 16687 jobs remaining (current phase=A73):
4 running, 0 ready to run and 16683 waiting.

FAILED: file oamdiagroles.ldt on worker 1 for product fnd username APPS.
FAILED: file umxroles.ldt on worker 2 for product fnd username APPS.
FAILED: file wfreprole.ldt on worker 3 for product fnd username APPS.
Completed: file b3664848.ldt on worker 4 for product fnd username APPS.

adworker log say:

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND :patch/115/import/afrole.lct @FND :patch/115/import/US/oamdiagroles.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /data/ora3/oracle/fs1/EBSapps/appl/admin/ORA3/log/US_oamdiagroles_ldt.log
Error calling FNDLOAD function.

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND :patch/115/import/afrole.lct @FND :patch/115/import/US/wfreprole.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /data/ora3/oracle/fs1/EBSapps/appl/admin/ORA3/log/US_wfreprole_ldt.log
Error calling FNDLOAD function.

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @FND :patch/115/import/afrole.lct @FND :patch/115/import/US/umxroles.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /data/ora3/oracle/fs1/EBSapps/appl/admin/ORA3/log/US_umxroles_ldt.log
Error calling FNDLOAD function.

US_oamdiagroles_ldt.log says:
Uploading from the data file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/oamdiagroles.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7), oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/oamdiagroles.ldt) to staging tables
Dumping LCT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7) into FND_SEED_STAGE_CONFIG
Dumping LDT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/oamdiagroles.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_SECURITY_GROUPS STANDARD , WF_ROLE UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for WF_ROLE: ROLE_NAME = ZZZ_LAST_DUMMY_ROLE, ORA-06508: PL/SQL: could not find program unit being called

US_umxroles_ldt.log says:
Uploading from the data file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7), oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt) to staging tables
Dumping LCT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7) into FND_SEED_STAGE_CONFIG
Dumping LDT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_SECURITY_GROUPS STANDARD , WF_ROLE ZZZ_LAST_DUMMY_ROLE ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for WF_ROLE: ROLE_NAME = ZZZ_LAST_DUMMY_ROLE, ORA-06508: PL/SQL: could not find program unit being called

US_wfreprole_ldt.log says:

Uploading from the data file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/wfreprole.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7), oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/wfreprole.ldt) to staging tables
Dumping LCT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7) into FND_SEED_STAGE_CONFIG
Dumping LDT file oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/wfreprole.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_SECURITY_GROUPS STANDARD , WF_ROLE ZZZ_LAST_DUMMY_ROLE ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for WF_ROLE: ROLE_NAME = ZZZ_LAST_DUMMY_ROLE, ORA-06508: PL/SQL: could not find program unit being called

Thanks in advance for your help.

Regards


Prihatno

[ErmanArslansOracleBlog]

That ZZZ_LAST_DUMMY_ROLE seems like an internal role and it is there for temporary reasons. Don't chase the dummy role itself — it's not the problem, it's just where the broken call surfaces.

I think you may need to log a SR for this, but compiling invalids, and check the prereq actions may help in these cases.

Check ->

 - Status of the Workflow packages in APPS: WF_LOCAL_SYNCH, WF_DIRECTORY, WF_CORE, WF_ENTITY_MGR, WF_USER_ROLE_ASSIGNMENTS_PKG. Any one of these being INVALID explains the symptom.
  - Total invalid object count in APPS before the driver was started — this should have been zero. If it wasn't, that's your real starting problem.
  - Whether all prereq patches listed in the 12.2.0 upgrade readme + MOS Doc ID 1320300.1 (R12.AD.C / R12.TXK.C upgrade) and the Workflow prereqs were applied successfully, with no Errors logged lines in their
   adpatch logs.
  - Whether adgrants.sql (the version shipped with the 12.2.0 upgrade) was run as SYS before the driver — required, easy to miss.
  - Whether the failing driver was merged with admrgpch — if yes, that's likely your problem; run the 12.2.0 upgrade driver unmerged.
  - Whether options=nocopyportion,nogenerateportion was actually called for by the upgrade readme for this driver and this step — usually it isn't.
  - A bdump/udump or alert log entry around the time of failure that names the specific program unit — that pinpoints exactly which package is broken.