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!

Error in order import interface

Discussion in 'Oracle Apps Technical' started by sambhaji, Nov 14, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,
    I am getting following error in order import .
    I ma pasting order import prog o/p .
    please see it.

    ***************************
    Order Import Concurrent Program

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

    Debug Level: 0
    Request Id: 5803809
    No. of orders found: 1
    No. of orders imported: 0
    No. of orders failed: 1


    Source/Order/Seq/Line Message
    1046/190329//204/388289 ORA-01403: no data found in Package OE_Order_Cache Procedure get_tax_calculation_flag

    1046/190329//204/388289 Validation failed for the field - Line Type

    End of Order Import Concurrent Program

    ************************

    Regards
    Sambhaji
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    1046/190329//204/388289 Validation failed for the field - Line Type.

    Which line type you gave?
     
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Jagadekara,

    I gave line_type as 'Service - Comms'

    Regards
    Sambhaji
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,
    Where exactly you entered this? And is it Valid line type?
     
  5. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    HI ,
    In stag table i gave line_type as 'Service - Comms'.
    And then i transfer it to interface table with validation and then ran order import program.
    So i got above error.

    Regards
    Sambhaji
     
  6. siva551

    siva551 Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    hi,
    could u plz send me the stagging table code,validation code