RCVRCERC: RMA Receipt Is Created With Null Location_id
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Oracle Financials for India - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
When creating a Receive transaction against a RMA, the name of a location is defaulted on the form, but no value is inserted into column rcv_transactions.location_id.
Only after changing the Location name on the form, before saving the details, a value for location_id is populated in table rcv_transactions.
The issue can be reproduced at will with the following steps:
1. Navigate through Receiving > Receipts
2. Query for a RMA
3. The name of a location name is defaulted on the form
4. Select the line and save
5. The location_id value is null in rcv_transactions
When India Localization module is used, the location_id not being populated may result into the following error:
Transaction_id->14756458 Error Message->Error in Line Number 1 - jai_rgm_claims_pkg.get_term_id => Location ID cannot be NULL
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms