My Oracle Support Banner

R12: AP/ZX/iSP: After Updating a Supplier With The 'AP_VENDOR_PUB_PKG.Update_Vendor_Public' API, Can't Retrive These Suppliers When Searching By Tax Registration Number (Doc ID 2044539.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0.0 and later
Oracle iSupplier Portal - Version 12.0.0 and later
Information in this document applies to any platform.


Supplier are created/updated with the API AP_VENDOR_PUB_PKG.Update_Vendor_Public such that the Tax Registration Number (TRN) is populated in the 'vat_registration_num' field.

Despite this, when searching for these suppliers by the Tax Registration Number in the supplier search page, no results are returned.

But if the supplier is "touched" in the Tax Details page, the search is successful.

What additional API and/or other action/s need to be applied to allow users to search by Tax Registration Number, without the manual intervention in the Tax Details page?


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
 Standard Patching Process
 Patch Wizard
 Have more questions?

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