Projects - EBS (MOSC)

MOSC Banner

PAXCPGAL_SINGLE module: PRC: Generate Asset Lines for a single project.

edited Sep 25, 2013 6:48AM in Projects - EBS (MOSC) 1 commentAnswered
Hello DEV,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center