R12: AP: Invoice Workbench Form File (APXINWKB.fmb/fmx) Failed Compilation Due to INVALID Server-Side eBTax (ZX) Packages (Doc ID 2945459.1)

Last updated on APRIL 28, 2023

Applies to:

Oracle Payables - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Invoice Workbench form file - APXINWKB.fmx (fmb) failed to compile through ADADMIN utility.

Compilation errors refer to INVALID eBTax (ZX) Server-side packages exist.

AD Worker #14 log file shows the following

...
...
The file list for the Oracle Forms object to generate is:

ap   forms/US   APXINWKB.fmx   /appspatch01/apps/fs1/EBSapps/appl/ap/12.0.0/forms/US/APXINWKB.fmx

**********************************************************
You are running adfrmgen

Header information is:
$Header: aiogfm.lc 120.11.12020000.6 2022/04/12 13:57:49 ship $

Start of adfrmgen session
Date/Time is Sun Mar 19 2023 09:16:28
Filelist file is: /appspatch01/apps/fs1/EBSapps/appl/admin/DEV/out/awlapp014.txt
Database connect string is: APPS/*****

Generating Oracle Forms files...

Temporarily resetting FORMS_PATH to:
"/appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/resource:/appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/forms/US:/appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/resource/US"

Generating form "forms/US/APXINWKB.fmx" with command:

/appspatch01/apps/fs1/EBSapps/10.1.2/bin/frmcmp_batch module=/appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/forms/US/APXINWKB.fmb output_file=/appspatch01/apps/fs1/EBSapps/appl/ap/12.0.0/forms/US/APXINWKB.fmx module_type=form batch=yes compile_all=special

ERROR generating form "forms/US/APXINWKB.fmx" from input file
/appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/forms/US/APXINWKB.fmb

Results of form generation:
(from file /appspatch01/apps/fs1/EBSapps/appl/au/12.0.0/forms/US/APXINWKB.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compiling package specification APP_CUSTOM...
   No compilation errors.

Compiling package specification INV_SUM_QF...
   No compilation errors.

Compiling package specification APXINWKB...
   No compilation errors.

Compiling package specification INV_SUM_FOLDER_BLOCK_LOCK...
   No compilation errors.

Compiling package specification INV_SUM_FOLDER_BLOCK_INSERT...
   No compilation errors.

...
...

Compiling package body SUMMARY_LINES...
   No compilation errors.

Compiling package specification SUMMARY_LINES...
   No compilation errors.

Compiling package body TX_ALLOCATION_1...
Compilation error on package body TX_ALLOCATION_1:
PL/SQL ERROR 905 at line 141, column 9
object APPS.ZX_TPI_SERVICES_PKG is invalid
PL/SQL ERROR 0 at line 141, column 9
Statement ignored

Compiling package specification TX_ALLOCATION_1...
   No compilation errors.

Compiling package body SUMMARY_LINES_2...
   No compilation errors.

Compiling package specification SUMMARY_LINES_2...
   No compilation errors.

Compiling package body DETAIL_TX_LINES_2...
   No compilation errors.

Compiling package specification DETAIL_TX_LINES_2...
   No compilation errors.

Compiling package body TX_ALLOCATIONS...
   No compilation errors.

Compiling package specification TX_ALLOCATIONS...
   No compilation errors.

Compiling package body SUMMARY_LINES_1...
Compilation error on package body SUMMARY_LINES_1:
PL/SQL ERROR 905 at line 1618, column 11
object APPS.ZX_TPI_SERVICES_PKG is invalid
PL/SQL ERROR 0 at line 1618, column 11
Statement ignored
PL/SQL ERROR 905 at line 1955, column 9
object APPS.ZX_TDS_TAX_ROUNDING_PKG is invalid
PL/SQL ERROR 0 at line 1955, column 9
Statement ignored
PL/SQL ERROR 905 at line 2000, column 7
object APPS.ZX_TPI_SERVICES_PKG is invalid
PL/SQL ERROR 0 at line 2000, column 7
Statement ignored

Compiling package specification SUMMARY_LINES_1...
   No compilation errors.

Compiling package body DETAIL_TX_LINES_QUOTE_1...
   No compilation errors.

Compiling package specification DETAIL_TX_LINES_QUOTE_1...
   No compilation errors.

Compiling package body DETAIL_TX_LINES_1...
Compilation error on package body DETAIL_TX_LINES_1:
PL/SQL ERROR 905 at line 2370, column 9
object APPS.ZX_TDS_TAX_ROUNDING_PKG is invalid
PL/SQL ERROR 0 at line 2370, column 9
Statement ignored
PL/SQL ERROR 905 at line 2383, column 14
object APPS.ZX_TDS_TAX_ROUNDING_PKG is invalid
PL/SQL ERROR 0 at line 2383, column 14
Statement ignored
PL/SQL ERROR 905 at line 2442, column 7
object APPS.ZX_TPI_SERVICES_PKG is invalid
PL/SQL ERROR 0 at line 2442, column 7
Statement ignored

Compiling package specification DETAIL_TX_LINES_1...
   No compilation errors.

Compiling package body DETAIL_TX_LINES...
   No compilation errors.

Compiling package specification DETAIL_TX_LINES...
   No compilation errors.

...
...

Compiling function IS_PO_TAX_UPDATE_ALLOWED...
   No compilation errors.

Compiling function IS_TAX_UPDATE_ALLOWED...
   No compilation errors.

Compiling package body JAF...
   No compilation errors.

Compiling package specification JAF...
   No compilation errors.

Compilation errors have occurred.
-------------------------------------------------------------------------

Generated    0 files successfully.
Generated    0 files with non-fatal warnings.
Generated    1 files with fatal errors.

adfrmgen is exiting with status 1

End of adfrmgen session
Date/time is Sun Mar 19 2023 09:17:11
**********************************************************

Notice the compilation errors highlighted

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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

R12: AP: Invoice Workbench Form File (APXINWKB.fmb/fmx) Failed Compilation Due to INVALID Server-Side eBTax (ZX) Packages (Doc ID 2945459.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

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