My Oracle Support Banner

Vertex: Upgraded AR Invoice Transactions Have No Data In Zx_lines (Doc ID 2807050.1)

Last updated on SEPTEMBER 25, 2021

Applies to:

Oracle Receivables - Version 12.2.8 and later
Oracle E-Business Tax - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 11.5.10 to 12.2.8, some upgraded transactions are getting error that tax does not exist.  The transactions have tax at the header level, but tax button displays no data.  There is no data in zx_lines.


Upgrade Historical Subledger Transaction Accounting errors with:

Upgrade failed at: E-Tax Upgrade for Receivables via E-Tax Master API
Updating the Return Code as 2(ERROR)
*Migration status code Updated to NULL for ledger_id : 1002 are : 2

-------------------------------
WRKR(01) (E-Business Tax Transactions Upgrade on demand worker): Log file

ORACLE error 1722 in FDPSTP

Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG", line 443
ORA-06512: at line 1

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
Symptoms
Cause
Solution


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