Entering a VAT Number on a Supplier Profile Error - 505 Internal Server Error

(Doc ID 1644716.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Payables Uptake of EBTAX

Attempting to add or update a Registration Regime and VAT Number to a supplier profile and receive the following error:

505 Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Steps to Reproduce:
Responsibility:  Payables
Navigation:  Suppliers
Update the supplier tax data, change the Default Reporting Registration Number
(Do not save)
Click Update in last screenshot
Update tax data at site level. (For example: Enter an end date)
Apply the Change

The query that is executing at the time of the spin

UPDATE zx_party_tax_profile partytaxprofileeo
SET last_updated_by = :1,
last_update_date = :2,
last_update_login = :3,
object_version_number = :4
WHERE party_tax_profile_id = :5

The query that it is waiting for

zx_party_tax_profile_pkg.sync_tax_reg_num (
p_party_id => :1,
p_tax_reg_num => :2,
x_return_status => :3,
x_msg_count => :4,
x_msg_data => :5




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