Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, May 9, 2008

ORA-06508 during patches which call worker fpainvcr.ldt

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.

No comments: