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

MOSC Banner

Patch 16303269 fails on file porep.odf

edited Jun 23, 2014 5:37AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hi All

We try to apply a patch 16303269 and we are getting error as -


The definition of the view PO_ALERT_CONTRACT_VIEW2 is incorrect.

The view text is incorrectly defined as:

SELECT ph.po_header_id, NVL(SUM(DECODE(c.minimum_accountable_unit, NULL,

ROUND ((pll.quantity - NVL(pll.quantity_cancelled, 0)) *

NVL(pll.price_override, 0), c.precision ), ROUND ((pll.quantity -

NVL(pll.quantity_cancelled, 0)) * NVL(pll.price_override, 0) /

c.minimum_accountable_unit ) * c.minimum_accountable_unit ) ), 0) FROM

PO_LINE_LOCATIONS_ALL PLL,PO_LINES_ALL PL,FND_CURRENCIES C,PO_HEADERS PH

WHERE ph.currency_code = c.currency_code AND pl.po_header_id =

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