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

MOSC Banner

After 19329720:R12.OWF.B WF_MAINTENANCE package is invalid PLS-00436 Cannot Reference Fields of BULK

edited Nov 20, 2014 1:05PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

Hello,

Running: ORACLE RDBMS Version: 10.2.0.4.0.

1)

Recently applied patches:

17774755:12.1.0

Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 1 [RPC1]

19329720:R12.OWF.B

Latest Recommended Patch Collection for OWF 12.1.3+

(Supplies wfmtn9b.pls  120.12.12010000.12)

2)

After applying these the WF_MAINTENANCE package is invalid.

Compile errors:

PACKAGE BODY WF_MAINTENANCE                                          

PL/SQL: SQL Statement ignored                                                                                                                                                                                       

PLS-00436: implementation restriction: cannot reference fields              

of BULK In-BIND table of records                                            

PLS-00382: expression is of wrong type                                      

                                                                                                            

3)

aderrchk.sql is attached.

4)

Error line from package:

select a.line,a.text

from user_source a , user_errors b

where a.name='WF_MAINTENANCE'

and a.name=b.name

and a.line=b.line

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