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

MOSC Banner

R12.1.3 : After patches p18374341 and p19295828. This generates an error when compiling CLEF081BSLDR

edited Jun 28, 2018 8:31AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hello,

I have applied patches p18374341 (bug 17936597) and p19295828. Objects in these patches have added parameter currency_code to the insert_row procedure.

This parameter is missing on our version of some CE programs:
> CE_SQLLDR_ERRORS_PKG
    /* $Header: ceslerrs.pls 120.0 2002/08/24 02:37:49 appldev noship $ */
    /* $Header: ceslerrb.pls 120.0 2002/08/24 02:37:45 appldev noship $ */
> CE_STAT_LINES_INF_PKG
    /* $Header: cestalis.pls 120.1 2002/11/12 21:25:44 bhchung ship $ */
    /* $Header: cestalib.pls 120.1 2002/11/12 21:25:24 bhchung ship $ */

Then now I have invalids :

 

  Object Name - CLEF081_BANK_STATEMENT_LOADER

  Object Type - PACKAGE BODY

  Error -      

 

LineCodeError
  165   gd_trx_date DATE;   PLW-07204: conversion away from column type may result in sub-optimal query plan
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