R12.1.3 : After patches p18374341 and p19295828. This generates an error when compiling CLEF081BSLDR
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 -
Line | Code | Error |
---|---|---|
165 | gd_trx_date DATE; | PLW-07204: conversion away from column type may result in sub-optimal query plan |