R12:AP: Viewing or Updating Suppliers Results in "JBO-27122: SQL error during statement preparation" "ORA-04063: package body "APPS.AP_VENDOR_PUB_PKG" has errors" (Doc ID 2746956.1)

Last updated on AUGUST 11, 2023

Applies to:

Symptoms

After applying the 1099 patches 32072819, 32157516 and 32181474, when trying to view or create suppliers the following error occurs:

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go Payables Manager responsibility
2. Navigate to the Suppliers/Enter
3. In the Suppliers page Search for supplier number with the issue. The window opens with the error.



 

Changes

Cause

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