Open Interfaces and SQL * Loader - utl file

Quick post links

http://www.infopurple.com/open-interface-logic-and-interface-components
The provided program logic validates the records.
Any errors are transferred into another table (called Error Table).
The correct records are then transferred through a process into destination application table.

http://www.infopurple.com/interfaces-types-of-interfaces-open-interface-custom-interface
These can be used to either transfer data from Oracle Applications to a flat file or data from legacy system to Oracle Applications.

http://www.infopurple.com/interface-utl_file-sqlloader-oracle-general-ledger
sample code of Interface program is presented for training purpose only.

Read the full Article


Add your opinion - this will move the pointer
get dashboard plugin?

Free Dashboards

Here are some more interesting Articles
  • INTERFACES -TYPES OF INTERFACES -Open Interface - Custom Interface
  • Data Conversion for Oracle Applications
  • OPEN INTERFACE LOGIC and INTERFACE Components
  • Interface - UTL_FILE - SQL*LOADER -ORACLE GENERAL LEDGER -
  • Trace Files and the Alert Log-LGWR
  • Template Testing
  • Leave a Reply

    You must be logged in to post a comment.