Cannot Compile APXWTRXF.fmb (Doc ID 1966534.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Payables - Version 12.2.4 and later
Oracle Applications DBA - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Goal

Problem Summary
---------------------------------------------------
Cannot compile APXWTRXF.fmb

Problem Description
---------------------------------------------------
After upgrading from 11.5.10.2 to 12.2.4 translation synchronization patch was applied which failed generating form APXWTRXF.fmb
I tried to generate the US version of this form with adadmin and it fails with the same error:

Compiling package body AP_PAYCARD_TRX_FEE_HEADER...
Compilation error on package body AP_PAYCARD_TRX_FEE_HEADER:
PL/SQL ERROR 201 at line 28, column 37
identifier 'AP_PAYCARD_TRX_FEE_HEADER' must be declared
PL/SQL ERROR 0 at line 28, column 1
SQL Statement ignored
PL/SQL ERROR 201 at line 39, column 33
identifier 'AP_PAYCARD_TRX_FEE_HEADER' must be declared
PL/SQL ERROR 0 at line 39, column 2
SQL Statement ignored
PL/SQL ERROR 201 at line 67, column 13
identifier 'AP_PAYCARD_TRX_FEE_HEADER' must be declared
PL/SQL ERROR 0 at line 67, column 1
SQL Statement ignored
PL/SQL ERROR 201 at line 76, column 37
identifier 'AP_PAYCARD_TRX_FEE_HEADER' must be declared
PL/SQL ERROR 0 at line 76, column 1
SQL Statement ignored
PL/SQL ERROR 201 at line 85, column 33
identifier 'AP_PAYCARD_TRX_FEE_HEADER' must be declared
PL/SQL ERROR 0 at line 85, column 2
SQL Statement ignored

The cause of the error is the missing AP_PAYCARD_TRX_FEE_HEADER table.

I found bug 20128604 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=20128604] with the same problem. It seems the solution would be to apply patch 15965337, which creates the missing table, but this patch is for R12.1 OIE.B, not for R12.2 OIE.C.

Please give me which patch fixes this problem on R12.2.4
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms