oracle financials interface

8/8/2019 Oracle Financials Interface

1/10

Oracle

r

FinancialsOpen InterfacesReferenceRELEASE 11i

January 2000


2/10

Oracler Financials Open Inter faces Reference Release 11i

Copyright E 1995, 2000, Oracle Corp oration . All right s reserved .

Primary Author s: Janet Coshow, Christopher An drew s, Janet Buchbinder, Frank Colligan, Gail

DAloision, Stephen Damiani, Christina Ravaglia

Contributors: Christopher Andrews

The Programs (which include both the software and documentation) contain proprietary information

of Oracle Corporation; they are provid ed u nder a license agreement containing restrictions on u se and

disclosure and are also protected by copyright, patent and other intellectual and industrial property

law. Reverse engineering, disassembly or decomp ilation of the Programs is prohibited. No pa rt of thisdocument m ay be reprodu ced or transmitted in any form or by any m eans, electronic or mechanical,

for any purpose, without the express written permission of Oracle Corporation.

Program Documentation is licensed for use solely to support the deployment of the Programs and not

for any other purpose.

The informa tion contained in this document is subject to change without notice. If you find any

problems in the documentation, please report them to us in writing. Oracle Corporation does not

war rant that this docum ent is error free. Except as may be expressly permitted in your license

agreement for these Programs, no part of these Programs m ay be reprodu ced or transmitted in anyform or by any means, electronic or mechanical, for any purpose, without the express written

perm ission of Oracle Corporation.

If the Programs are delivered to the US Government or anyone licensing or using the Programs on

behalf of the US Government, the following notice is app licable:

RESTRICTED RIGHTS LEGEND

Programs delivered subject to the DOD FAR Supplement are commercial comp uter software and use,

du plication and disclosure of the Program s includ ing docum entation, shall be subject to the licensing

restrictions set forth in the ap plicable Oracle license agreement. Otherw ise, Programs delivered subjectto the Federal Acquisition Regulations are restricted comp uter software and u se, dup lication and

disclosure of the Programs sha ll be subject to the restrictions in FAR 52.22719, Commercial Comp uter

Software Restricted Rights (Jun e, 1987). Oracle Corp orat ion, 500 Oracle Parkw ay, Redw ood City, CA

94065.

The Programs a re not intended for u se in any nu clear, aviation, mass transit, medical, or other

inherently dangerous app lications. It shall be licensees responsibility to take all app ropriate failsafe,

back up , redund ancy and other measures to ensure the safe use of such app lications if the Programs

are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the

Programs.

Oracle is a registered trad emark and ConText, Enabling the Information Age, Oracle7, Oracle8,

Oracle8i, Oracle Access, Oracle Application Object Library, Oracle Financials, Oracle Discoverer, Oracle

Web Customers, Oracle Web Employees, Oracle Workflow, Oracle Work in Process, PL/ SQL, Pro*C,

SmartClient, SQL*, SQL*Forms, SQL*Loader, SQL*Menu, SQL*Net, SQL*Plus, and SQL*Report are

trademarks or registered trademar ks of Oracle Corporation. Other names m ay be trademarks of their

respective owners.


3/10

Importing Information into Oracle Financials Applications

Using Oracle Financials and Oracle Public Sector Financials imp ort

programs, you can integrate new or existing app lications such as

payroll, accoun ts receivable, accounts payable, and fixed assets into

your Oracle Financials app lications. You can imp ort accoun ting da ta

from your feeder systems. You can also import h istorical data from

your p revious accounting or m anagement systems.

The following lists show open interfaces in Oracle Financials and

related app lications. The lists tell you w here you can read in detail

about each open interface. You m ay also wan t to refer to the Oracle

Manufacturing and Distribution Open Interfaces Manual, Release 11i for

detailed docum entation on open interfaces in those prod ucts. Note

that almost all user guides and manu als referenced in this docum ent

are available in Adobe Acrobat pd f forma t on the Oracle App lications

Documentation CD.

Oracle Assets

Oracle Assets provides the following op en interfaces:

ACE Interface (See: About the ACE Inter face section of the

Oracle Assets User Guide)

Budget Open Interface (See: Bud get Op en Inter face section ofthe Oracle Assets User Guide)

Mass Additions Interface (See: About the Mass Ad ditions

Interface section of the Oracle Assets User Guide)

Production Interface (See: Using the Prod uction Interface section

of the Oracle Assets User Guide)

Physical Inventory (See: Loading Physical Inventory Data

section of the Oracle Assets User Guide)

Oracle Cash Management

Oracle Cash Managemen t provides the following op en interfaces:

Bank Statement Open Interface (See: Bank Statement Open

Interface section of the Oracle Cash M anagement User Guide)


4/10

Forecasting Open Interface (See: Forecasting O pen Interfacesection of the Oracle Cash Management User Guide)

Reconciliation Open Interface (See: Reconciliation Op en

Interface section of the Oracle Cash M anagement User Guide)

Oracle General Ledger

Oracle General Ledger provides the following open interfaces: Budget Upload (See: Up load ing Budgets section of the Bud gets

chapter of the Oracle General Ledger User Guide)

Importing Journals (See: Journa l Imp ort section of the Journa ls

chapter of the Oracle General Ledger User Guide)

Loading Daily Rates (See: Load ing Da ily Rates section of the

MultiCurrency chapter of the Oracle General Ledger User Guide)

Oracle Inventory

Oracle Inventory p rovides the following open interfaces:

Customer Item Interface (See: Inventory in th e Oracle

Manufacturing and Distribution Open Interfaces Manual)

Open Item Interface (See: Inven tory in th e Oracle M anufacturing

and Distribution Open Interfaces Manual)

Open Replenishment Interface (See: Inven tory in th e Oracle


Open Transaction Interface (See: Inventory in the Oracle


Cycle Count Open Interface (See: Inventory in the Oracle


Reservations Open Interface (See: Inventory in the Oracle


Move Orders Open Interface (See: Inven tory in the Oracle



5/10

Oracle Payables

Oracle Payables provides th e following op en interfaces:

Credit Card Transaction Interface Table (See: Payable Cred it

Card Transactions Table app end ix in th e Oracle Payables User

Guide)

Invoice Import Interface. This interface is no longer su pp orted

for imp orting invoices. Use the Payables Open Interface instead.If you w ant to review colum n d escriptions for the table, refer to

the Invoice Imp ort Inter face Tables appen dix in the Release 10.7

or 11 Oracle Payables Users Guide)

Payables Open Interface (See: Payables O pen Interface Tables

app endix in the Oracle Payables User Guide)

Purchase Order Matching (See: Purchase Ord er Matching

Database Tables append ix in the Oracle Payables User Guide)

Oracle Projects

Oracle Projects provides the following op en interfaces:

Activity Mangement Gateway (See:Activity Management

Gateway Technical Reference Manual)

Client Extensions (See: Client Extension s in th e Oracle ProjectsUser Guide)

Transaction Import (See: Interg rating Oracle Projects with

nonOracle Produ cts in the Oracle Projects User Guide)

Oracle Purchasing

Oracle Purchasing prov ides the following open interfaces:

Requisitions Open Interface (See: Pu rchasing in the Oracle

Manufacturing and Distributions Open Interfaces M anual)

Purchasing Documents Open Interface (See: Purchasing in th e

Oracle Manufacturing and Distributions Open Interfaces Manual)

Receiving Open Interface (See: Pu rchasing in the Oracle

Manufacturing and Distributions Open Interfaces M anual)


6/10

Oracle Receivables

Oracle Receivables p rovides th e following op en interfaces:

AutoInvoice (See: Imp orting Invoice Information Using

AutoInvoice in the Oracle Receivables User Guide)

AutoLockbox (See: Using AutoLockbox in the Oracle Receivables

User Guide)

Customer Interface (See: Custom er Interface in the OracleReceivables User Guide)

Sales Tax Rate Interface (See: Importing Address Validation

Data and Sales Tax Rates in theOracle Receivables Tax M anual)

Tax Vendor Extension (See: Implem enting the Tax Vend or

Extension in th e Oracle Receivables Tax Manual)

Basic Importing Needs

Oracle Financials imp ort program s provide you w ith the features you

need to satisfy the following basic integration n eeds:

Import information in the easiest way possible, and

automatically convert the valid d ata you import into d ata that ismeaningful to you and your organization.

Import information from a va riety of environments, includ ing

your own and other accounting systems.

Import historical data from your previous accounting, sales

order or other m anagement systems to keep your records

consistent and up todate.

Review the results of your imp ort run. Identify which data hasbeen successfully imp orted, and an y errors which may have

occurred d uring the import p rocess.

Correct invalid data online that an imp ort program w as unable

to accept.


7/10

In add ition, several Oracle Financials import p rograms satisfy thefollowing add itional needs:

Validate the integrity of any da ta before introd ucing it into you r

Oracle Financials application

Choose to optionally archive your sou rce da ta each time you ru n

an import program

Definitions

Feeder Program

A custom p rogram you use to import you r d etail accounting

transactions from an external or feeder system into you r Oracle

Financials app lication. The type of feeder p rogram you w rite dep end s

on the environment from wh ich you are importing data.

ORACLE Tables

Rows and colum ns by wh ich data is organized in the ORACLE

Relational Database Managem ent System. Categories of information

are listed across the top of each table, while individu al cases are listed

dow n the left side. In this form you can readily visualize, un derstand

and use the information. Oracle Financials produ cts use ORACLE

tables to store the information you n eed to run you r business.

Table Columns

ORACLE tables consist of columns. Each column contains one kind of

information. We use the following convention for naming tab lecolumns: TABLE_NAME.COLUMN_NAME.

Column Reference

Column in a table wh ich references information stored in a column in

another table. When column s in d ifferent tables contain the same typ e

of information, the comm on information perm its entries in the two

tables to be combined or related to each other.


8/10

Column Types

Each column in a table can hold one type of value. The most common

types are:

A char column contains a sequence of up to 240

letters, num bers, pu nctuation m arks and special

characters like +, , % and $

A nu mber colum n contains a nu mber consisting ofdigits, a sign and a d ecima l point

A date colum n contains a d ate and time of day

Not Null Column

A column in w hich you m ust enter information. In other word s, a

column in wh ich the value m ay not be nu ll.

Importing Data From Your Feeder System

Oracle App lications can receive data from an import program which

your onsite MIS personnel can d evelop for you. Or, you m ay want to

use an Oracle consultant. The goal of your imp ort program is to

convert data from you r feeder system into a stand ard d ata format th atyour Oracle app lications can read an d then convert for fur ther

mod ification or p rocessing in you r Oracle app lication.

Char

Number

Date


9/10

Figure 1Importing Data into an

OracleAppli cations system

Feeder systemdata

OracleApplicationsimport data

tables

OracleApplications

system

Feeder program

Oracle App licationsimport program

Oracle Applicationsimport program execution

report

Writing a Feeder Program

The type of environment from wh ich you wan t to import data

determ ines the type of feeder program you need to write. For example,

you can u se SQL*Loader to write an impor t program to feed d ata from

a nonOracle system. Or, you can write a feeder program to impor t

historical data from your previous accoun ting system. Regard less of

the type of feeder program you write, the outpu t should be in standard


10/10

data format that an Oracle Applications imp ort program can use toconvert your import data into your Oracle Applications system.

Choosing a Feeder Program

You n eed to choose a tool for w riting a feeder program to extract data

from your existing ap plication system s p rinted reports, flat file,

relational d atabase, or other repository of app lication information.

Using a feeder p rogram you write, you popu late an OracleApp lications imp ort table with the information you wan t to introduce

to you r Oracle Finanicials system.

SQL*Loader is a pow erful and easytouse tool you can to write a

feeder p rogram. SQL*Loader lets you map elements of a regularly

formatted file, such as a listing or flat file, and sp ecify wh ich colum ns

of which tables to populate. Chances are, SQL*Loader is a pow erful

enough tool to use for your feeder p rogram.If you n eed to do more complex compu tations to extract or rearrange

information from your feeder system, you can choose from a variety of

programm ing languages to popu late an import table.

For examp le, you can u se any of the Oracleenhanced programming

langu ages, su ch as Pro*C, Pro*COBOL, or Pro*FORTRAN , as w ell as

SQL*Report.