Time when worker started job: Fri Mar 31 2023 16:32:49
Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @JTF:patch/115/import/jtfamvit.lct @IBE:patch/115/import/US/ibeitems.ldt –
Connecting to APPS……Connected successfully.
Calling FNDLOAD function.
Returned from FNDLOAD function.
Log file: /dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl/admin/RGP6/log/US_ibeitems_ldt.log
Error calling FNDLOAD function.
Time when worker failed: Fri Mar 31 2023 16:32:50
rgp6app(oracle):/dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl
Error found in /dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl/admin/RGP6/log/US_ibeitems_ldt.log
Error loading seed data for JTF_AMV_ITEM: ITEM_ID = 8126, ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Error loading seed data for JTF_AMV_ITEM: ITEM_ID = 8128, ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Error loading seed data for JTF_AMV_ITEM: ITEM_ID = 8130, ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Fix:
To implement the solution, please execute the following steps:
1. Connect to Mid-tier node to directory: $JTF_TOP/patch/115/sql
2. sqlplus apps/apps_pwd
@jtfiimt.sql jtf icybay
@jtfiaitd.sql jtf icybay
@jtfiaitn.sql jtf icybay
@jtfiaitt.sql jtf icybay
@jtfiappr.sql apps
@jtfiaibu.sql jtf icybay apps
@jtfntsci.sql jtf icybay
@jtftkimi.sql jtf icybay
3. Verify all status columns are with VALID status
select index_name, domidx_status, domidx_opstatus, funcidx_status, status from dba_indexes where index_type=’DOMAIN’ and index_name like ‘JTF_AMV_ITEMS%’;
Metalink Reference: Upgrade Driver Failed Error loading seed data for JTF_AMV_ITEM – ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (Doc ID 2435119.1)
Orama.blog 