R12.2 Apps DBA. Powered by Blogger.

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

No comments :
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.
CAUSE
This issue will occur only when forms with older version and newer version generated in same patching cycle and the older version of form is incompatible with recent database changes.
SOLUTION
 To implement the solution, please execute the following steps:
Abort the failed prepare phase
adop phase=abort
Perform fs_clone
adop phase=fs_clone
Re-perform prepare
adop phase=prepare

No comments :

Post a Comment

Note: only a member of this blog may post a comment.