Today while applying a merged patch which contains 300 functional patches, the DBAs reported the following error:
ATTENTION: All workers either have failed or are waiting:
FAILED: file fpainvcr.ldt on worker 2.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
On checking the worker log and the request log they found:
Uploading from the data file /stage11i/ebiz/appl/fpa/11.5.0/patch/115/import/US/fpainvcr.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/stage11i/ebiz/appl/fpa/11.5.0/patch/115/import/fpacriteria.lct(115.2), /stage11i/ebiz/appl/fpa/
11.5.0/patch/115/import/US/fpainvcr.ldt) to stage tables
Dump LCT file /stage11i/ebiz/appl/fpa/11.5.0/patch/115/import/fpacriteria.lct(115.2) into FND_SEED_STAGE_CONFIG
Dump LDT file /stage11i/ebiz/appl/fpa/11.5.0/patch/115/import/US/fpainvcr.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FPA_OBJECTS_TL INVESTMENT_CRITERIA 1 , FPA_OBJECTS_TL INVESTMENT_CRITERIA 8 ) into FND_SEED_STAGE_ENTITY
Upload from stage tables
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 1, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 2, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 3, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 4, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 5, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 6, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 7, ORA-06508: PL/SQL: could not find program unit being called
Error loading seed data for FPA_OBJECTS_TL: OBJECT = INVESTMENT_CRITERIA, ID = 8, ORA-06508: PL/SQL: could not find program unit being called
On checking the lct file it has reference to a package called fpa_objects_pkg:
UPLOAD FPA_OBJECTS_TL
" begin
if (:UPLOAD_MODE = 'NLS') then
fpa_objects_pkg.TRANSLATE_ROW (
:ID,
:OBJECT,
:NAME,
:DESCRIPTION,
:OWNER );
We checked the status of fpa_objects_pkg and it was INVALID.
After compiling this object:
alter package fpa_objects_pkg compile body;
We restarted the failed worker and it completed without errors.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment