Last updated on APRIL 26, 2016
Applies to:Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.
Using Purchasing, Version 12.2.4 - upon attempting to approve the purchase order, the following error occurs:
Error Message: Unexpected error occurred during tax calculation.
Exception: 023 -
Please correct the problem or contact your system administrator.
The issue can be reproduced at will with the following steps:
1. Purchase Orders - Purchase Orders - query the purchase order.
2. Attempt to approve the purchase order.
3. Find that it is ending in error.
The FND debug log and raw trace show errors similar to the following:
0x199cd76c0 2583 package body APPS.PO_DOCUMENT_CHECKS_PVT
0x1736f1908 302 package body APPS.PO_DOCUMENT_CHECKS_GRP
0x1736f1908 601 package body APPS.PO_DOCUMENT_CHECKS_GRP
ORA-04065: not executed, altered or dropped stored procedure "APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG"
oacdty=01 mxl=2000(186) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=873 siz=0 off=2000
kxsbbbfp=7f73521f27c0 bln=2000 avl=186 flg=01
value="ORA-04065: not executed, altered or dropped stored procedure "APPS.ZX_GLOBAL_STRUCTURES_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ZX_GLOBAL_STRUCTURES_PKG"
The package may vary.
Checking the package in question - such as .ZX_GLOBAL_STRUCTURES_PKG or ZX_AP_TAX_CLASSIFICATN_DEF_PKG - they might be valid.
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