12.2 Merged Upgrade Driver Fails During FndXdfCmp XDF Generation With Error 'Exception occured Unable to get the database connection using schema username/passwordORA-28000: The account is locked' (Doc ID 2698349.1)

Last updated on AUGUST 07, 2020

Applies to:

Symptoms

During an upgrade from R12 to 12.2, while applying the merged 12.2 upgrade driver multiple xdf files failed and we can see the following in a log file from adpatch.

ATTENTION: All workers either have failed or are waiting:

FAILED: file task_in_obj_tbl.xdf on worker 1.
FAILED: file res_asgmt_out_obj_tbl.xdf on worker 2.
FAILED: file budget_in_obj_tbl.xdf on worker 3.
FAILED: file task_line_obj.xdf on worker 4.
FAILED: file task_line_obj_tbl.xdf on worker 5.
FAILED: file delete_task_out_obj.xdf on worker 6.
FAILED: file GMD_SAMPLES_REC_TYPE.xdf on worker 7.
FAILED: file proj_cp_req_obj.xdf on worker 8.
FAILED: file proj_ret_status_obj_tbl.xdf on worker 9.
FAILED: file task_line_out_obj.xdf on worker 10.
FAILED: file budget_out_obj_tbl.xdf on worker 11.
FAILED: file task_out_obj.xdf on worker 12.
FAILED: file task_out_obj_tbl.xdf on worker 13.
FAILED: file res_assgn_perd_act_obj.xdf on worker 14.
FAILED: file budget_in_obj.xdf on worker 15.
FAILED: file task_line_out_obj_tbl.xdf on worker 16.
FAILED: file delete_task_out_obj_tbl.xdf on worker 17.
FAILED: file project_out_obj.xdf on worker 18.
FAILED: file project_out_obj_tbl.xdf on worker 19.
FAILED: file project_res_assign_obj.xdf on worker 20.
FAILED: file project_task_per_comp_obj.xdf on worker 21.
FAILED: file project_res_assign_obj_tbl.xdf on worker 22.
FAILED: file delete_res_asgmt_out_obj_tbl.xdf on worker 23.
FAILED: file project_task_period_act_obj.xdf on worker 24.
FAILED: file project_task_planned_obj.xdf on worker 25.
FAILED: file res_asgmt_out_obj.xdf on worker 26.
FAILED: file project_task_earned_obj.xdf on worker 27.
FAILED: file task_in_obj.xdf on worker 28.
FAILED: file budget_out_obj.xdf on worker 29.
FAILED: file project_task_act_obj.xdf on worker 30.
FAILED: file delete_res_asgmt_out_obj.xdf on worker 31.
FAILED: file project_task_est_obj.xdf on worker 32.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

In adworkerXXX.log, we found ORA-28000 as follows.

Changes

Performing E-Business Suite upgrade to 12.2 per the following documentation:

https://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580874.htm

Oracle E-Business Suite Upgrade Guide / Perform the Upgrade
11. Run the American English upgrade patch driver (required)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.