My Oracle Support Banner

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 NOVEMBER 10, 2021

Applies to:

Oracle Property Manager - Version 12.2.6 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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