Ask the Expert

RMA authorization numbers

I need to enter RMA authorization numbers that are generated in another system to Oracle inventory so that I can receive against them. We don't use Order Management or AR. The MTL_SO_RMA_INTERFACE table seems to be the place to go but I'm not sure if it will cause other problems trying to send data to AR and OE. Also, I can't find info on the RETURN_TYPE_CODE field in the table. Any help will be greatly appreciated.

    Requires Free Membership to View

I'm a bit confused as to why you would want an RMA if you are not using Oracle Receivables or Order Management. In fact, I don't think you can even set up the MTL_SO_RMA_INTERFACE to work without those. If you are using a third-party OM, I would track all the information there and use the MTL_TRANSACTIONS_INTERFACE to adjust your Oracle Inventory balance for the return. If you still want to have an RMA reference in Oracle, you can use some of the ATTRIBUTE columns.

Hope this helps, Russell

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: