Q

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.

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.

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
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close