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!

Oracle AR Autovoice interface with Siebel service contracts

Discussion in 'Oracle Financials' started by ramanuj, Feb 29, 2012.

  1. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Hi,

    We are building an interface between Siebel service contacts and oracle AR(we are on 12.1.3).We need to build an interface that will take the siebel service renewal lines and create invoices in AR using auto invoicing.

    We will be having a new transaction type for siebel renewal lines.We need to caculate the tax as a part of invoice creation using autoinvoice, as the tax is not calculated on the siebel side.I have not used ebiz tax earlier and need to know how do i proceed with this design.
    We need to build accounting using oracle SLA - looking for a highlevel design steps as to how to go with this design.

    Any help is highly appreciated!

    Thanks
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ramanuj,

    You need to understand the regime to rate flow which is driven by setups in Ebiz tax. The tax rules are setup for 4 P's. I will try to dig into my docs and upload for you. The requirement is straight forward and make sure the setups for the siebel transaction type and source is complete. If you have access to Metalink, I am 100% sure there was a sample doc there explaining the whole flow. This has been there for a while.
    Ramji
     
  3. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Hi Ramji
    Thanks for the quick reply , It would be very helpful if you can send me the doc or upload it.Sure i will search in metaslinks also.
    Also i was trying to validate the data that is coming from siebel side to fill into the oracle interface tables (RA_interface_lines_all,RA_interface_distributions and RA_interface_sales_credit). Can you please help me understand what are all the mandatory data that is needed to load into these tables to run the autoinvoice.Basically i am trying to design the interface layer that is needed to fill the AR interface tables.This is a real urgent task for me and really appreciste the help you are doing.Thanks a lot and waiting to hear from you soon.

    Ramanuj
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ramanuj,

    I now know what you are looking for and shall post all the important stuff. I shall do it before the weekend.
    Ramji
     
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ramanuj,
    I have found the stuff. Looking for the rest. Shall upload as soon as I have all.
    cheers
    Ramji
     
  6. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Ramji
    Thanks so much.I am really waiting for this info.
    Thanks a million!

    Ramanuj.
     
  7. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Ramji

    I really donno how to thank you.
    Is there a way that i can contact you for a quick discussion!

    Thanks
    Ramanuj
     
  8. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ramanuj,

    Its really simple. Press the thanks button :) By the by no formalities needed for knowledge sharing. Also I am a functional Oracle pro who understands the technicalities to the extent needed to carry out my work. For the technical nitty gritty I am sure you will find help on the forum. I also have the habit of collecting useful docs an that is what I am digging into so that it can be of use for you.
    cheers
    Ramji
     
  9. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
  10. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Thanks Ramji
     
  11. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    All the info you need are in the following notes
    [ID 1137414.1]
    [ID 885225.1]
    have proprietory stuff which cannot be put in public domain. I believe this info should give you a head start.
    Shall post some code later
    Ramji
     
  12. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ramanuj,

    Here is a sample script...
    INSERT INTO RA_INTERFACE_LINES_ALL
    (batch_source_name,
    line_type,
    description,
    conversion_type,
    currency_code,
    inventory_item_id,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    amount,
    term_name,
    term_id,
    trx_date, primary_salesrep_id,
    cust_trx_type_id,
    orig_system_bill_customer_id,
    orig_system_bill_address_id,
    orig_system_sold_customer_id,
    conversion_rate, uom_code,
    line_number,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_context,
    quantity,org_id
    )
    VALUES ('LEGACY', 'LINE', 'Maintenance', 'User',
    'USD',
    8451, 1012015,
    SYSDATE,1012015,
    SYSDATE,
    10000, '30 NET', 4,
    SYSDATE, 10068,
    1,
    1288,
    1338,
    1288,
    1, 'Ea',
    1,
    '631152600',
    '1',
    'VISION BUILD',
    2, 204
    );
     
  13. ramanuj

    ramanuj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    California
    Thanks Ramji,