When Submitting Property Manager Equipment Lease API to Update Vendor Id and Vendor Site Id, Error "Non-Updatable field:vendor_site_id" Received (Doc ID 2805610.1)

Last updated on JANUARY 31, 2023

Applies to:

Symptoms

When running the Update Equipment Lease API procedure in PN_EQUIP_LEASE_PUB.AMEND_EQUIP_LEASE in SQLplus and attempting to update the following:
l_eqp_lease_pmt_term_tbl(1).payment_term_id := &pay_term_ID;
l_eqp_lease_pmt_term_tbl(1).vendor_id := &Vendor_ID;
l_eqp_lease_pmt_term_tbl(1).vendor_site_id := &Vendor_Site_ID;

the following error is being received:

'In Edit OR AMEND Final Mode.Non-Updatable field:vendor_site_id was being updated'

Steps:

1. Bring up SQLplus session
2. Submit a SQL wrapper utilizing the PN_EQUIP_LEASE_PUB.AMEND_EQUIP_LEASE procedure to update the vendor_id and vendor_site_id
3. If new vendor has more than one site, error encountered.

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.