Open Interfaces

[ahmadbilal]

Open Interfaces

<b>Oracle Assets</b>
Oracle Assets provides the following open interfaces:
? ACE Interface (See: About the ACE Interface section of the
Oracle Assets User Guide)
? Budget Open Interface (See: Budget Open Interface section of
the Oracle Assets User Guide)
? Mass Additions Interface (See: About the Mass Additions
Interface section of the Oracle Assets User Guide)
? Production Interface (See: Using the Production Interface section
of the Oracle Assets User Guide)
? Physical Inventory (See: Loading Physical Inventory Data
section of the Oracle Assets User Guide)


<b>Oracle Cash Management</b>
Oracle Cash Management provides the following open interfaces:
? Bank Statement Open Interface (See: Bank Statement Open
Interface section of the Oracle Cash Management User Guide)
? Forecasting Open Interface (See: Forecasting Open Interface
section of the Oracle Cash Management User Guide)
? Reconciliation Open Interface (See: Reconciliation Open
Interface section of the Oracle Cash Management User Guide)

[ahmadbilal]

<b>Oracle General Ledger</b>
Oracle General Ledger provides the following open interfaces:
? Budget Upload (See: Uploading Budgets section of the Budgets
chapter of the Oracle General Ledger User Guide)
? Importing Journals (See: Journal Import section of the Journals
chapter of the Oracle General Ledger User Guide)
? Loading Daily Rates (See: Loading Daily Rates section of the
Multi?Currency chapter of the Oracle General Ledger User Guide)


<b>Oracle Inventory</b>
Oracle Inventory provides the following open interfaces:
? Customer Item Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)
? Open Item Interface (See: Inventory in the Oracle Manufacturing
and Distribution Open Interfaces Manual)
? Open Replenishment Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)
? Open Transaction Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)
? Cycle Count Open Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)
? Reservations Open Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)
? Move Orders Open Interface (See: Inventory in the Oracle
Manufacturing and Distribution Open Interfaces Manual)

[ahmadbilal]

<b>Oracle Payables</b>
Oracle Payables provides the following open interfaces:
? Credit Card Transaction Interface Table (See: Payable Credit
Card Transactions Table appendix in the Oracle Payables User
Guide)
? Invoice Import Interface. This interface is no longer supported
for importing invoices. Use the Payables Open Interface instead.
If you want to review column descriptions for the table, refer to
the Invoice Import Interface Tables appendix in the Release 10.7
or 11 Oracle Payables User?s Guide)
? Payables Open Interface (See: Payables Open Interface Tables
appendix in the Oracle Payables User Guide)
? Purchase Order Matching (See: Purchase Order Matching
Database Tables appendix in the Oracle Payables User Guide)

<b>Oracle Projects</b>
Oracle Projects provides the following open interfaces:
? Activity Mangement Gateway (See: Activity Management
Gateway Technical Reference Manual)
? Client Extensions (See: Client Extensions in the Oracle Projects
User Guide)
? Transaction Import (See: Intergrating Oracle Projects with
non?Oracle Products in the Oracle Projects User Guide)

[ahmadbilal]

<b>Oracle Purchasing</b>
Oracle Purchasing provides the following open interfaces:
? Requisitions Open Interface (See: Purchasing in the Oracle
Manufacturing and Distributions Open Interfaces Manual)
? Purchasing Documents Open Interface (See: Purchasing in the
Oracle Manufacturing and Distributions Open Interfaces Manual)
? Receiving Open Interface (See: Purchasing in the Oracle
Manufacturing and Distributions Open Interfaces Manual)

<b>Oracle Receivables</b>
Oracle Receivables provides the following open interfaces:
? AutoInvoice (See: Importing Invoice Information Using
AutoInvoice in the Oracle Receivables User Guide)
? AutoLockbox (See: Using AutoLockbox in the Oracle Receivables
User Guide)
? Customer Interface (See: Customer Interface in the Oracle
Receivables User Guide)
? Sales Tax Rate Interface (See: Importing Address Validation
Data and Sales Tax Rates in the Oracle Receivables Tax Manual)
? Tax Vendor Extension (See: Implementing the Tax Vendor
Extension in the Oracle Receivables Tax Manual)


i would like to suggest that all interfaces related posts(issues) will raise in this thread this will b more helpful for anyone who want to get information regarding Open interfaces.

[annadasahoo]

Hi
thanx a lot.
Can u please describe briefly what is the difference between custom and open interfaces?
what are the different implementation steps for both.
Thanx

[ramkic]

Excellent abmian1981.
Regards
ramkic

[ahmadbilal]

<b>Item Open Interface Setup and How-To
Doc ID: Note:115557.1
metalink.oracle.com</b>


<b><u>Item Open Interface Setup & How-To</u></b>

Purpose:
-------------

Documentation of the setup and usage of the Item Open Import (IOI) process
for the import of items.

Scope & Application:
----------------------------
This document can be used as a supplement to load item data through the
Open Interface.

Contents:
--------------------------
Setup
How-To
Running the Item Open Interface In Create Mode
Running the Item Open Interface In Update Mode
Updating Item Attributes to NULL
Importing Master and Child Records
Revisions
Template Use

Setup
============================================================
Follow this checklist before attempting to load items via the Item Open
Interface:
a) If any IOI patches have been applied, verify that there are no invalid
packages.

To find invalid objects, run the following:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = 'INVALID'

b) Insure that INCOIN has been relinked if any IOI patches were applied.

adrelink sample command lines to relink aiap:
'adrelink force=y ranlib=y "fnd aiap"'

c) Check that the standard indexes exist on the mtl_system_items (
mtl_system_items_b in Release 11.5) and mtl_system_items_interface tables.
(Select table_name, index_name
From all_indexes
Where table_name in (''MTL-SYSTEM_ITEMS', 'MTL_SYSTEM_ITEMS_INTERFACE',
'MTL_SYSTEMS_ITEMS_B')
Order by table_name, index_name; )

The standard indexes for Release 11.0.3 are as follows:
mtl_system_items_interface_n1
mtl_system_items_interface_n2
mtl_system_items_interface_u1

mtl_system_items_n1
mtl_system_items_n2
mtl_system_items_n3
mtl_system_items_n4
mtl_system_items_n5
mtl_system_items_n6

The standard indexes for Release 11.5 are as follows:
mtl_system_items_interface_ n1
mtl_system_items_interface_n2
mtl_system_items_interface_n3
mtl_system_items_interface_u1
mtl_system_items_ b_n1
mtl_system_items_ b_n2
mtl_system_items_ b_n3
mtl_system_items_ b_n4
mtl_system_items_ b_n5
mtl_system_items_ b_n6
mtl_system_items_ b_n7
mtl_system_items_ b_u1

d) Check if the internal and standard concurrent managers are up and running
before loading items (system admin resp/concurrent/manager/administer)
Check the actual and target processes, the numbers should be the same
for each.

e) Define an item through the Define Item form. If this does not work,
then it is unlikely that items will load through the interface.
ex. inventory responsibility/items/master items Enter item name,
description and attributes needed and save the item.

f) Truncate all IOI interface tables before loading mtl_system_items_interface:

ex. TRUNCATE TABLE <tablename>

MTL_SYSTEM_ITEMS_INTERFACE
MTL_INTERFACE_ERRORS
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE

Note:
======
If Purchasing is fully installed but Inventory is only a shared product,
users should be able to run the IOI. You should, however, be aware that the
IOI code is not shipped with standalone Purchasing. You will have to obtain
the code by downloading the latest IOI megapatches.

How-To
========
Running the Item Open Interface In Create Mode
Populate the mtl_system_items_interface with the following minimum required
columns when creating new items:
PROCESS_FLAG = 1
TRANSACTION_TYPE = 'CREATE'
SET_PROCESS_ID = 1
ORGANIZATION_ID = Master Org id.
DESCRIPTION = 'Description of the item'
ITEM_NUMBER and/or SEGMENT(n)

Running the Item Open Interface In Update Mode
To update existing item(s), set TRANSACTION_TYPE = 'UPDATE'.

Creating and updating items in a single run of the Item Open Interface is not
supported functionality.

For best performance, use inventory_item_id when updating items.

Functionality
Every attribute updateable from the Item form is updateable through the
interface, and all required validations are performed to enforce:

[ahmadbilal]

Using Open Interfaces


http://books.google.com/books?id=-xFZbB ... #PPA257,M1

[fun2chat]

We are facing a serious problem in the production instance, the invoices are not getting pulled into AR from the OM.

The error message is ?Please enter quota sales credit percentage that equals 100 percent for this line.?

The invoice with this error message are holdup in AR line interface.

Kindly suggest the reason and the solution to clear this invoices, its really important

[ahmadbilal]

Verify the percent on the line receiving the error using the following
statment:

select interface_line_id, sales_credit_percent_split
from ra_interface_salescredits_all
where interface_line_id=&line_id;

This should return one line at 100%.

2. If one line is returned, verify whether these sales credits are quota or non-
quota type credits. Autoinvoice considers only 'quota' type credits for the
total (sum) of the salescredits for a given line. The non-quota ones are not
considered for this validation (or any validation). This is a common error
when people implement autoinvoice for the first time.

[fun2chat]

thanks ahmadbilal

i will check as per your instructions and will get back to u.

[fun2chat]

i am getting a error while doing autoinvoice in AR.

Error Message:
"You must supply an invoice number when your batch source indicates manual invoice numbering; otherwise you must leave invoice number blank"

i tried making changes in batch source, but seems it is a one time setup, there i didnt clicked on auto numbering of batch.

please suggest me any other workaround to overcome this error,

regards