Column type LONG vs EBS 12.2

Hi,

Following the result of the script EBS Online Patching Database Compliance Checker (ADZDDBCC.sql) I have the result that we need to convert all LONG to CLOB.

We have a problem with the table FF_FORMULAS_F.

1. The colomn FORMULA_TEXT had the format LONG.

2. I had to change it to CLOB.

3. Now the package BEN_PD_FORMULAS_PKG does not compile because there is a command to_lob(FORMULA_TEXT)

select -999999, -999999, 'COPY_FF',1, to_lob(formula_text)

  from  ff_formulas_f

  where formula_id = p_formula_id

  and   p_effective_start_date between effective_start_date and effective_end_date;