Patch 17774755 (RPC1) Failed Generating HZ_IMP_LOAD_PARTIES_PKG

Support logged this thread on behalf of the customer.

Hello Support,

HZ_IMP_LOAD_PARTIES_PKG invalid after applying R12.1.3 RUP1 17774755. I believe this is because we are at database version 10.2.0.4 and that these lines are referencing something only available in 11g.

SELECT a.line, a.text

FROM user_source a, user_errors b

WHERE a.name='HZ_IMP_LOAD_PARTIES_PKG'

AND a.name=b.name

and a.line=b.line;

LINE            TEXT

2792      EXECUTE IMMEDIATE v_sql

2792      EXECUTE IMMEDIATE v_sql

2821      EXECUTE IMMEDIATE v_sql

2821      EXECUTE IMMEDIATE v_sql

2852      EXECUTE IMMEDIATE v_sql

2852      EXECUTE IMMEDIATE v_sql

2881      EXECUTE IMMEDIATE v_sql