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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top