Results 1 to 6 of 6

Thread: sales order conversion

  1. #1
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    sales order conversion

    can any body tell me how to perform sales order conversion
    ie., from legacy to oracle. i know that the interface tables are oe_headers_iface_all,oe_lines_iface_all,& oe_actions_iface_all. and the base tables are oe_order_headers_all & oe_order_lines_all. my problem is the data goes upto interface table after validation but it does not go into base table when i run the concurrent program called order import.
    all i want to know is-
    1.what are the parameters given when we run the concurrent program?
    and 2.if possible can anybody give me the fields to be taken exactly ( there could be a chance of selecting wrong fields ).?
    urgent pls.


  2. #2
    Junior Member
    Join Date
    Nov 2007
    Answers
    3

    Re: sales order conversion

    Have u got the answer for ur query from someone else?

    Last edited by varun.dixit; 11-19-2007 at 02:40 AM.

  3. #3
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    Re: sales order conversion

    Quote Originally Posted by varun.dixit View Post
    Have u got the answer for ur query from someone else?
    sorry,i didnt get any answers. iam trying on it.if i succeed then ,i will mail u
    bye


  4. #4
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    Re: sales order conversion

    sorry , i didnt get reply from any one.i am trying ,but if i succeed then i will tell you.
    bye


  5. #5
    Junior Member
    Join Date
    Nov 2007
    Answers
    3

    Re: sales order conversion

    These are the mandetory fields to be given.


    l_header_rec1:=OE_ORDER_PUB.G_MISS_HEADER_REC;

    l_header_rec1.order_type_id := ;
    l_header_rec1.pricing_date := SYSDATE;
    l_header_rec1.transactional_curr_code := ' ';
    l_header_rec1.operation := OE_GLOBALS.G_OPR_CREATE;
    l_header_rec1.flow_status_code:='ENTERED';




    t_line_tbl1(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
    t_line_tbl1(1).inventory_item_id:=;
    t_line_tbl1(1).ordered_quantity:=;
    t_line_tbl1(1).unit_selling_price:=;
    t_line_tbl1(1).operation := OE_GLOBALS.G_OPR_CREATE;





    and in process_order proc it is mentioned as :

    OE_Order_PUB.Process_Order(1.0,
    FND_API.G_TRUE,
    FND_API.G_TRUE,
    FND_API.G_TRUE,
    x_return_status,
    x_msg_count,
    x_msg_data,
    l_header_rec1,
    OE_Order_PUB.G_MISS_HEADER_REC,
    OE_Order_PUB.G_MISS_HEADER_VAL_REC,
    OE_Order_PUB.G_MISS_HEADER_VAL_REC,
    OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL,
    OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
    OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
    OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
    OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
    OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
    OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL,
    OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL,
    t_line_tbl1,
    OE_Order_PUB.G_MISS_LINE_TBL,
    OE_Order_PUB.G_MISS_LINE_VAL_TBL,
    OE_Order_PUB.G_MISS_LINE_VAL_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL,
    OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
    OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
    OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
    OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
    OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
    OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL,
    OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL,
    OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
    OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
    OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL,
    OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL,
    OE_Order_PUB.G_MISS_REQUEST_TBL,
    x_header_rec,
    x_header_val_rec,
    x_Header_Adj_tbl,
    x_Header_Adj_val_tbl,
    x_Header_price_Att_tbl,
    x_Header_Adj_Att_tbl,
    x_Header_Adj_Assoc_tbl,
    x_Header_Scredit_tbl,
    x_Header_Scredit_val_tbl,
    x_line_tbl,
    x_line_val_tbl,
    x_Line_Adj_tbl,
    x_Line_Adj_val_tbl,
    x_Line_price_Att_tbl,
    x_Line_Adj_Att_tbl,
    x_Line_Adj_Assoc_tbl,
    x_Line_Scredit_tbl,
    x_Line_Scredit_val_tbl,
    x_Lot_Serial_tbl,
    x_Lot_Serial_val_tbl,
    x_action_request_tbl,
    'N');





    let me know if it is of any use for u.


  6. #6
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    Re: sales order conversion

    is it for an API ? sorry, i want for normal conversion which takes data from staging table to interface table & then from interface table to base table.
    Any how,i will check the fields,& work on it .thanks for ur reply .
    BYE


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact