Prepare Phase Is Getting Failed Since PO PLL Files Compiled Error (FRM-30312) (Doc ID 2120455.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

Problem Statement
Adop patching is getting failed at prepare phase while patch synchronization.
The following Oracle Forms Oracle Forms library files did not generate successfully.

  au resource POXPOPOL.pll
  au resource POXOPROC.pll

Error
  ERROR generating library "resource/POXPOPOL.plx" from input file
  /d31/vup1/oracle/fs2/EBSapps/appl/au/12.0.0/resource/POXPOPOL.pll

  Results of library generation:
  (from file /d31/vup1/oracle/fs2/EBSapps/appl/au/12.0.0/resource/POXPOPOL.err
  AD Worker has deleted the original .err file)
  -------------------------------------------------------------------------
  Compilation errors on PO_LINES_C6:
  PL/SQL ERROR 306 at line 311, column 5
  wrong number or types of arguments in call to 'PO_LINES_POST_QUERY'
  PL/SQL ERROR 0 at line 311, column 5
  Statement ignored

  Compilation errors on PO_LINES_C4:
  PL/SQL ERROR 306 at line 178, column 12
  wrong number or types of arguments in call to 'GET_PO_AMOUNTS'
  PL/SQL ERROR 0 at line 178, column 12
  Statement ignored

  Failed to generate library.

  FRM-30312: Failed to compile the library.


  ERROR generating library "resource/POXOPROC.plx" from input file
  /d31/vup1/oracle/fs2/EBSapps/appl/au/12.0.0/resource/POXOPROC.pll
  Results of library generation:
  (from file /d31/vup1/oracle/fs2/EBSapps/appl/au/12.0.0/resource/POXOPROC.err
  AD Worker has deleted the original .err file)
  -------------------------------------------------------------------------
  Compilation errors on OUTSIDE_PROC_C3:
  PL/SQL ERROR 306 at line 65, column 12
  wrong number or types of arguments in call to 'GET_RESOURCE_DEFAULTS'
  PL/SQL ERROR 0 at line 65, column 12
  Statement ignored
  PL/SQL ERROR 306 at line 106, column 11
  wrong number or types of arguments in call to 'GET_RESOURCE_DEFAULTS'
  PL/SQL ERROR 0 at line 106, column 11
  Statement ignored
  PL/SQL ERROR 306 at line 151, column 12
  wrong number or types of arguments in call to 'GET_RESOURCE_DEFAULTS'
  PL/SQL ERROR 0 at line 151, column 12
  Statement ignored
  PL/SQL ERROR 306 at line 380, column 3
  wrong number or types of arguments in call to 'GET_OPERATION_DEFAULTS'
  PL/SQL ERROR 0 at line 380, column 3
  Statement ignored
  PL/SQL ERROR 306 at line 405, column 3
  wrong number or types of arguments in call to 'GET_RESOURCE_DEFAULTS'
  PL/SQL ERROR 0 at line 405, column 3
  Statement ignored

  Failed to generate library.

  FRM-30312: Failed to compile the library.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.