EMEA Add on Localization : SEED DATA : Patch 29505295 failed with error "Error loading seed data" (Doc ID 2548380.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Symptoms

On : 12.2.8 version, Patch Application Issues

Reported Issue
-----------------
Patch 29505295 relating to EMEA Add-on Localization(CLE) Product SEED data for Conc Programs, Value Sets, Profiles, Form Functions, Messages, Localization
DFF/GDFF, Forms personalization is failing with an error. 
CLE related FNDLOAD jobs failed with "Error loading seed data" and ORA-01403


Error from patch log
----------------------
1. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF332VATSP, STAGE_NAME = stage20, SEQUENCE = 20, ORA-01403: no data found
2. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF350REQSET, STAGE_NAME = STAGE10, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF350REQSET, ORA-01403: no data found
3. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF145INFRS, STAGE_NAME = STAGE10, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF145INFRS, ORA-01403: no data found
4. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF311RS, STAGE_NAME = STAGE20, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF311RS, ORA-01403: no data found
5. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF281RS296, STAGE_NAME = STAGE50, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF281RS296, ORA-01403: no data found
6. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLE_F314_PMA_OA, STAGE_NAME = STAGE10, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLE_F314_PMA_OA, ORA-01403: no data found  
7. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF262ILOFREQSET, STAGE_NAME = 10, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF262ILOFREQSET, ORA-01403: no data found
8. Error loading seed data for STAGE_PROG: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF065RS296, STAGE_NAME = STAGE30, SEQUENCE = 10, ORA-01403: no data found
    Error loading seed data for REQ_SET_LINKS: APPLICATION_SHORT_NAME = CLE, REQUEST_SET_NAME = CLEF065RS296, ORA-01403: no data found

 ( above mentioned are not the complete message. owing to space constraint, placing only the actual error text)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. adop phase=finalize
2. Patch is failing with an error.
    [WARNING] Only continue if you are sure it is safe to do so - continuing without first resolving the failure may lead to inconsistency and data loss.
    To reapply the patches in the existing session, answer 'N'.
    To ignore the failure and continue processing, answer 'Y'.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the patching cycle without warning/ errors

Cause

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