Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sales Order Import (SO Conversion)

Sales Order Import (SO Conversion)

Sales Order Import (SO Conversion)

Im going to import Sales Order from legacy system to Oracle ERP. All SOs to be converted will be in BOOKED status. Based on the documents I've read, if the SOs are in BOOKED status,the BOOKED_FLAG in the OE_HEADERS_IFACE_ALL is set to 'N'  and an interface table called OE_ACTIONS_IFACE_ALL will be used and populated for all BOOKED sales orders.
Is this true? And during conversion also ,if some of the SOs are on hold,either in header or in the lines, this hold needs to be applied in Oracle.How am I going to applied holds during conversion?


RE: Sales Order Import (SO Conversion)

In 11i you have to use OE_ACTIONS_IFACE_ALL table to book order. You can do it on the header or line level. For booking orders you have to use value 'BOOK_ORDER' in the OPERATION_CODE in the action table.
You also have ability to put on hold order header (whole order) or a line. Just set OPERATION_CODE to 'APPLY_HOLD' in the action table.
Hope it helps.

RE: Sales Order Import (SO Conversion)

If I have one booked order which is put on hold,in the table OE_ACTIONS_IFACE_ALL, does it mean I will be having 2 records. One record has the  operation_code set to BOOK_ORDER  and one record will have the operation_code set to APPLY_HOLD. Is this correct?

Also one more question, I've read about order import's  defaulting rules(e.g. shipping method, freight carrier, accounting rule, invoicing rule, etc. etc) which are being setup under OM.Does this means that If i don't have value ,e.g. shipping method, being pass to the interface table, the order import program  will get the value in the setup done under defaulting rules.

Thanks again.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close