Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

aptoltax.sql fails on all workers while applying 6678700

edited Sep 24, 2012 11:17AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 9 commentsAnswered ✓
Anyone seen this issue?

I am trying to apply patch 6678700 and all workers stop running while running aptoltax.sql. I tried to recreate this trigger but it failed with Info: 1 trigger had errors on compile.  Last error message: 9/1     PLS-00306: wrong number or types of arguments in call to 'UPDATEEXPENSESTATUSCODE'
9/1     PL/SQL: Statement ignored

 Start time for file is: Mon Sep 24 2012 12:33:00

sqlplus -s APPS/***** @/d11/oracle/TEST/apps/apps_st/appl/ap/12.0.0/patch/115/sq
l/aptoltax.sql &un_ap &batchsize 15 16
Updating  the total tax amount in the header

DECLARE
*
ERROR at line 1:
ORA-20001: Updating column total_tax_amount : ORA-04098: trigger
'APPS.OIE_UPDATE_EXP_STATUS' is invalid and failed re-validation

Tagged:

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