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?


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