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:
Oracle Property Manager - Version 12.2.6 and laterInformation 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:
- Bring up SQLplus session
- Submit a SQL wrapper utilizing the PN_EQUIP_LEASE_PUB.AMEND_EQUIP_LEASE procedure to update the vendor_id and vendor_site_id
- 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 |