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!

what is the procedure to develop an interface?

Discussion in 'Oracle Apps Technical' started by sravan.kaurn, Jan 14, 2015.

  1. sravan.kaurn

    sravan.kaurn Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    100
    what is the procedure to develop an interface? wt is the use of interface tell me one business requirement
    how do u dump data from pl/sql block to flat files?
     
  2. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Interface is regular activity which moves data from Oracle to Legacy system . Legacy system might be oracle or any other third party system .

    Eg: A manufacturing industry maintains 2 systems 1)Oracle Apps 2)Any third party system.

    They use oracle apps from Order to Shipment transaction and third party system for Accounting purpose.

    Once shipment is done and invoice is created in oracle apps , Those invoice information need to move to their third party system for accounting . In this scenario Interface will come into picture.

    By using UTL_FILE concept you can dump data to flat file in pl/sql
     
    ramprasad.cgs and sravan.kaurn like this.
  3. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune