My Oracle Support Banner

R12: AP: Generic Data Fix (GDF) Patch 17433450 - Total Tax Amount is not Populated to Invoice Header during the upgrade. (Doc ID 972143.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle E-Business Tax - Version 12.2.7 to 12.2.7 [Release 12.2]
Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.2.5 to 12.2.5 [Release 12.2]
Oracle Payables - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.


During the upgrade process from 11i to R12, the upgrade script apinvupd.sql was not populating the denormalized database column total_tax_amount in the table ap_invoices_all.

Hence, the total tax amount is not populated for upgraded invoices in the invoice workbench.

Steps to reproduce:

  1. Perform upgrade from 11i to Release 12.





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.