Oracle Open Interfaces Lession 5

Assets Open Interfaces
ACE Interface: Used if you have to load ACE(adjusted current earnings) information from another asset system and accumulated depreciation for your ACE assets for defining the initial open period of your ACE book as the last period of the last fiscal year you completed on your previous system.

Budget Open Interface: Used if you maintain and upload your budget information in a spreadsheet. You transfer the budget data from any software package that prints to an ASCII file and then use SQL *Loader to load the FA_BUDGET_INTERFACE table.

Mass Addition Interface- Used with the mass additions process to upload data when adding assets automatically for current and future periods, import data from other systems, and convert assets from an outside system to Oracle Assets, Oracle Assets is already integrated with Oracle Payable and Oracle Projects. Use the mass additions process to

Production Interface- Used to enter production data manually, maintain your production data in another system, and upload the information. Prepare and analyze your production information into Oracle Assets, which uses that information to calculate depreciation for your units of production assets.

Physical Inventory- The process of ensuring that the assets a company has listed in its production system match the assets it actually has in Inventory. A company takes physical inventory by collecting data in a number of ways. You can load your physical inventory data into Oracle Assets using the Oracle Assets desktop integrator. Which helps you to import data from excel spreadsheet. You can also use SQL*Loader to import data from another application.

Order Management Open Interfaces

Order Import Interface: You can capture order data using a specialized system and import it into Oracle Order Management /Shipping for processing. You can import orders with any entry status, including booked status. Imported orders can be queried and modified using the sales orders window in Order Management/Shipping. If an order is imported with an entry status of booked, it is automatically eligible to progress to the next step of its order cycle when the import is complete. You can also import incomplete orders and finish them using the Sales Order window. Order import receives data from your import program, which converts data from your feeder system into a standard data format that order import can read. It can then convert your import data into Order Management/Shipping Orders.

Receivable (Invoice) Interface: Oracle Order Management provides functionality to integrate with Oracle Receivable and using AutoInvoice, create invoices, create credit memos and credits on account, recognize revenue, and manage sales credits.

Ship Confirm Open Interface: With Release 11i, the ship confirm interface has been replaced with a group of shipping API's that load data into the shipping tables from external systems and close delivery lines without using the shipping transaction form.

Receivable Open Interfaces

Importing Transactions Using AutoInvoice: You can transfer accurate and valid transactions from other systems into Receivables. You can import invoices, credits memos, debit memos, and on account credits. You can delete the interface lines that were processed and successfully transferred into Receivables. You do not have to run this program if the purge interface tables system option is set to Yes since Receivables deletes the interface lines automatically after you run Auto Invoice.

Importing Customer Data Using Customer Interface: Through Oracle Receivables Customer Interface, you can import , validate and update current or historical and additional customer data from other systems into Receivables. The customer interface program validates the data that you load in the Customer Interface tables by ensuring that the columns in the Interface tables reference the appropriate values and columns in the rest of the system. The program also ensures that each record is unique.

Importing Address Validation Data/Sales Tax Rates using Sales Tax Rate Interface: Using the sales tax rate interface program from an interface area or feeder system, you can load new locations and one or more tax rates for the same location covering different data ranges and postal codes tax rates into Receivables. These loaded records update your existing data with the most current tax rates for each location so you can manually create and import invoices into Receivables(Auto Invoice)and validate new customer addresses.

Calculating Tax Using the Tax Vendor Extension:
You can integrate external tax calculation programs with Oracle Applications, providing for complex tax calculation need while retaining the full power of Oracle Receivables to create and store all other tax data. The tax extension is called whenever a tax rate is calculated by the Receivable tax engine. When implemented, the Tax Engine returns a tax rate or amount from the vendor program. Receivables uses this data to create to appropriate tax lines and related accounting data. Tax rates are calculated in the following Receivables window and program- Adjustments window, Copy Transactions window, Credit Transactions window, Transactions Window and Auto Invoice.