Error "SQL error in Exec. (2,280) SHIP_INV_VW.BUSINESS_UNIT.SavePreChange Name: update_rtv_ro" when Saving an Express Issue the Type of Supplier Return (RTV) and a PRO Number Is Entered

(Doc ID 2108071.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The following SQL error occurs when saving an Express Issue the type of 'Supplier Return (RTV)' and a PRO Number is entered:

SQL error in Exec. (2,280) SHIP_INV_VW.BUSINESS_UNIT.SavePreChange Name: update_rtv_ro
Called from:SHIP_INV_VW.BUSINESS_UNIT.SavePreChange Statement:203


Steps to replicate the issue:

  1. Navigate to: Inventory > Fulfill Stock Orders > Stock Requests > Express Issue
  2. Create an Express Issue of type Supplier Returns.
  3. Fetch an available RTV and fill in a quantity and Location.
  4. Drill into the 'Detail Override/Exceptions' hyperlink.
  5. Drill into the 'RTV Pro Numbers' hyperlink.
  6. Enter a Pro Number and hit OK.
  7. Hit OK on the 'Detail Override/Exceptions' page.
  8. Attempt to save the Express Issue > observe the error.




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