1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Interal Sales Order two Inventory Orgs within same OU

Discussion in 'Oracle SCM & Manufacturing' started by oratech, Nov 25, 2013.

  1. oratech

    oratech Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Paris
    Hi,

    I am trying to complete the internal sales cycle across two inventory different inventory W/Hs within the same OU. But stuck with "Import Order" request it not creating internal order in the OM. Did anyone face the same issue. I m afraid i might be missing some setup for (transaction type & line flow setup) for internal order.

    thanks

    Aayan
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Aayan,

    Have you checked the OM interface tables (oe_headers_iface_all ,oe_lines_iface_all ) ?

    You can check with the below query.
    If data is available in those tables Problem with Order Import.

    Check whether inventory periods are open or not for those inventories....

    Code (SQL):

    SELECT *
    FROM   oe_headers_iface_all
    WHERE  orig_sys_document_ref IN  (
                                        SELECT REQUISITION_HEADER_ID
                                        FROM   po_requisition_headers_all
                                        WHERE  segment1 = :P_REQUISITION_NUM
                                     ) ;
     

    Regards
    Sambasiva Reddy.K
     
  3. oratech

    oratech Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Paris
    Hi Sambasiva,

    thanks for response, after running your given sql query i found the transaction record exits in the interface table but somehow after running the "Order Imports" request record is not generated in Order Organizer. .......:confused:


    Regards,
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Have you checked whether inventory periods are open or not for those inventories?

    Regards
    Sambasiva Reddy.K
     
  5. oratech

    oratech Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Paris
    Hi
    Well inventory periods are already opened for sending & receiving inventory orgs. i m afraid om setup. Do u have any idea wat special setup is required from OM side in terms of Internal orders...thanx
     
  6. erp.narendrag

    erp.narendrag Forum Expert

    Messages:
    108
    Likes Received:
    17
    Trophy Points:
    655
    Location:
    India
    Hi Ayan,

    check the below meta link Id,
    OEOIMP: Order Import does not spawn child request. (Doc ID 1322574.1)

    Regards,
    Narendra
     
  7. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Do one thing.

    Go to Order Management Responsibility -->Orders ,Returns -->Import Orders --> Corrections

    Then query by giving Order Reference as Requisition Number.

    Then click ' Validate ' button , check any errors are there if not there then click ' Import ' button.

    It may work.


    Regards
    Sambasiva Reddy.K
     

    Attached Files:

  8. oratech

    oratech Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Paris
    Hi Narendra & Sambasive,

    I went through your reply and executed the request again and getting the below message:

    Order Import Concurrent Program

    Concurrent Program Parameters
    Validate Only: N
    Order Source: 10
    Order Ref: 2839726
    Sold To Org Id: 58174
    Sold To Org:
    Change Sequence:
    Performance Parameter: Y
    Trim Blanks: N
    Operation:
    Number of Instances: 4
    Org Id: 84
    Process Orders With Null Org: Y
    Default Org Id: 84

    Debug Level: 0
    Request Id: 12023617
    No orders to process
    Not spawning any child processes
    End of Order Import Concurrent Program