Rebuilding XDO objects (Failed worker on 12.1.1 upgradation)

To build XDO objects if you face table or view not found during patching and if worker fails with status Failed on XDOLoader.class on product xdo on user xdo

Then try this:
First verify the application has been licensed with xdo.
1. select object_name,object_type,owner from dba_objects where object_name like 'XDO%';
you should have returned with 153 rows.
2. Select application_id,application_short_name from apps.fnd_application where application_short_name = 'XDO';

3.Recreate objects in XDO using
goto:
$XDO_TOP/patch/115/odf

use the command:
adodfcmp odffile=XDOTMGR.odf userid=applsys/apps changedb=yes priv_schema=system/manager mode=tables touser=apps/apps logfile=xdotables.log

adodfcmp odffile=XDOTMGR.odf userid=applsys/apps changedb=yes priv_schema=system/manager mode=indexes touser=apps/apps logfile=xdoindexes.log

adodfcmp odffile=XDOTMGR.odf userid=applsys/apps changedb=yes priv_schema=system/manager mode=sequences touser=apps/apps logfile=xdosequenc.log

adodfcmp odffile=XDOTMGR.odf userid=applsys/apps changedb=yes priv_schema=system/manager mode=views touser=apps/apps logfile=xdoviews.log

Rerun the patch or restart the failed worker.