PAXCPGAL_SINGLE module: PRC: Generate Asset Lines for a single project.
Customer on 12.1.3 encounters the following error when they run the PAXCPGAL_SINGLE module: PRC: Generate Asset Lines for a single project.
MSG-00001: Calling summarize_proj
MSG-00001: ORA-04098: trigger 'APPS.PA_EFC_PRJ_AST_LINE_DTLS_AIUD' is invalid and failed re-validation
Analysis
-----------------
SELECT *
FROM dba_objects
shere object_Type = 'TRIGGER'
and object_name like 'PA%' and status = 'INVALID';
OBJECT_NAME
PA_EFC_DRFT_INV_DETAILS_AIUD
PA_EFC_CUST_ERDL_ALL_AIUD
PA_EFC_EXP_ITEMS_ALL_UD
PA_EFC_PRJ_AST_LINE_DTLS__AIUD
PA_EFC_CUST_RDL_ALL__AIUD
PA_EFC_DRAFT_REVS_ALL_AIUD