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!

Intrerfaces real ime questions

Discussion in 'Oracle Apps Technical' started by ramprasad.cgs, Oct 20, 2014.

  1. ramprasad.cgs

    ramprasad.cgs Active Member

    Likes Received:
    Trophy Points:
    Interfaces real time questions

    1. when we r doing interface/conversion which things u will
    take care to improve the perfornmance ? except bulk collect

    2. In conversion,u r loading the data using sql*loader, I dnt
    want to use sql*loader ,& i have millions of records,Is der
    any way to load the data withing fraction of time
    considering best performance.

    3. When u r doing conversion ,that using sql*loader u r
    loading data into staging table, u r writing control file bt
    I dnt want to use sql*loader, when u r creating con prog that
    time can we pass all values from flat file using
    paramere, valuset ? how?

    4. In flat file u got 50 records,out of 50 ,30 records are
    proceesed & inserted into base table,after that client
    understood that 1 item having wrong name e.g instead of ABC
    he given DCE, so can we delete? hw ? (client permission is der)
    i have lot of wrong item name randomly spreaded, can we
    delete it ? hw?

    5.after doing validation hw u will follow approach to error
    out records? if i want to send all the error out records to
    client daily,whats is the approach?

    6. In outbound interface is der any way to load the
    data (large data-millions of records) except UTL_FILE package?