Interface Tables/APIs in Conversions
Conversion/Interface
Interface Tables
Base Tables
Open Interface/Concurrent Program
Items
MTL_SYSTEM_ITEMS_INTERFACE
MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
Item Categories
MTL_ITEM_CATEGORIES_INTERFACE
MTL_ITEM_CATEGORIES
Item Open Interface
Item Cost
CST_ITEM_CST_DTLS_INTERFACE
CST_ITEM_COSTS_INTERFACE
CST_ITEM_COST_DETAILS
CST_ITEM_COSTS
The Import Cost Option
Category Codes
Item Open Interface
MTL_CATEGORIES_B
MTL_CATEGORIES_TL
Customer Items
MTL_CI_INTERFACE
On Hand Quantities
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTIONS_LOTS_INTERFACE
APIs
inv_item_category_pub.create_category
MTL_CUSTOMER_ITEMS
Customer Item Interface
MTL_MATERIAL_TRANSACTIONS
Item Transaction Open Interface
Item Pricing
QP_LIST_HEADERS
QP_LIST_LINES
QP_PRICING_ATTRIBUTES
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_SALES_CREDITS
oe_order_pub.process_order
Sales Order
Sales Order Notes
FND_DOCUMENTS
FND_DOCUMENTS_TL
FND_DOCUMENTS_LONG_TEXT
FND_DOCUMENTS_SHORT_TEXT
fnd_documents_pkg.insert_row
fnd_attached_documents_pkg.insert_row
AR-Open Invoices
PO (Open: Standard & Blanket)
Notes
Category rec from MTL_ITEM_CATEGORIES table
qp_price_list_pub.process_price_list
RA_INTERFACE_LINES_ALL
RA_CUSTOMER_TRX_LINES_ALL
Autoinvoice Import Program
PO_HEADERS_INTERFACE
PO_HEADERS_ALL
Import Standard Purchase Orders
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
Import Price Catalogs
For Standard POs
For Blanket Pos (Can be used for Standard PO also.
Need to pass document type parameter).
HZ_PARTIES
hz_party_v2pub.create_organization
HZ_PARTY_SITES
hz_location_v2pub.create_location
HZ_PARTY_SITE_USES
hz_party_site_v2pub.create_party_site
HZ_CUST_ACCT_SITES_ALL
hz_party_site_v2pub.create_party_site_use
Customer
hz_contact_point_v2pub.create_contact_point
hz_party_contact_v2pub.create_org_contact
hz_cust_account_v2pub.create_cust_account
hz_cust_account_site_v2pub.create_cust_acct_site
Create Organization with one IN parameter of type
hz_party_v2pub.ORGANIZATION_REC_TYPE which is of record
type
Create Location procedure with one IN parameter of
of type hz_location_v2pub.LOCATION_REC_TYPE which is of
record type.
Create Party Site procedure with one IN parameter of type IN
parameter of type hz_party_site_v2pub. PARTY_SITE_REC_TYPE
which is of record type.
Create Party Site Use procedure with one IN parameter of type "
hz_party_site_v2pub. PARTY_SITE_USE_REC_TYPE which is of
record type.
Create Contact Point procedure with one IN parameter
hz_contact_point_v2pub.CONTACT_POINT_REC_TYPE
which is record type
Create Organization contact procedure with one IN parameter of
type ORG_CONTACT_REC_TYPE.
Create Customer Account procedure with two IN parameters of
type
HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE and
HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_
REC_TYPE
Create Customer Account Site with one IN parameter of type
CUST_ACCT_SITE_REC_TYPE.
Note: orig_system_parameter should be populated with unique
(combination of keys) key to avoid duplicate records getting
created.
HR Organizations
ORG_ORGANIZATION_DEFINITIONS
hr_organization_api.create_hr_organization
hr_organization_api.update_organization
Employees (Person/Assignment/Address)
hr_employee_api.create_employee
hr_person_api.update_us_person
hr_ex_employee_api.actual_termination_emp
hr_ex_employee_api.final_process_emp
hr_assignment_api.update_emp_asg
hr_assignment_api.update_emp_asg_criteria
hr_location_api.create_location
hr_address_api.create_person_address
hr_address_api.update_person_address
sanjayapps@gmail.com
Prepared by : Sanjay Challagundla
OracleERP@googlegroups.com
hr_employee_api.re_hire_ex_employee
hr_person_address_api.update_person_address
hr_person_address_api.create_person_address
GL Code Combinations
GL_INTERFACE
GL FLEX VALUES
sanjayapps@gmail.com
GL_CODE_COMBINATIONS
JOURNAL IMPORT
FND_ID_FLEX_STRUCTURES
FND_ID_FLEX_SEGMENTS
FND_FLEX_VALUE_SETS
FND_FLEX_VALUES
FND_FLEX_VALUE_NORM_HIERARCHY
Use GL_INTERFACE to load the Code Combination Id and for this
purpose we shall be entering the Journal entries with amount as 0
and we shall be able to enter the Journal entries and inturn load the
Code Combinations only if for this structure "Allow Dynamic Inserts" is
enabled. We don't have to bother about duplicate entries. They will be
automatically take care off.
fnd_flex_loader_apis.up_value_set_value
fnd_flex_loader_apis.up_val_norm_hierarchy
AP INVOICES
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
Payables Import Program
QA RESULTS
QA_RESULTS_INTERFACE
QA_RESULTS
Collection Import
TRADING PARTNERS
ECE_TP_HEADERS
ECE_TP_LINES
Project Expenditures
PA_TRANSACTION_INTERFACE_ALL
PA_EXPENDITURES_ALL
PA_EXPENDITURE_GROUPS_ALL
PA_EXPENDITURE_ITEMS_ALL
PA_COST_DISTRIBUTION_LINES_ALL
PA_EXPENDITURE_COMMENTS
PA_TASKS
PA_PROJECTS_ALL
Transaction Import
GL Balances
GL_INTERFACE
GL_BALANCES
Journal Import
BOM
BOM_BILL_OF_MTLS_INTERFACE
BOM_INVENTORY_COMPS_INTERFACE
BOM_SUB_COMPS_INTERFACE
BOM_BILL_OF_MATERIALS
BOM_INVENTORY_COMPONENTS
BOM_SUBSTITUTE_COMPONENTS
Prepared by : Sanjay Challagundla
OracleERP@googlegroups.com
Interface Tables/APIs in Conversions
Conversion/Interface
Items
Item Categories
Item Cost
Category Codes
Customer Items
On Hand Quantities
Item Pricing
Sales Order
Sales Order Notes
AR-Open Invoices
PO (Open: Standard & Blanket)
Customer
HR Organizations
Employees (Person/Assignment/Address)
sanjayapps@gmail.com
Prepared by : Sanjay Challagundla
OracleERP@googlegroups.com
GL Code Combinations
GL FLEX VALUES
AP INVOICES
QA RESULTS
TRADING PARTNERS
Project Expenditures
GL Balances
BOM
sanjayapps@gmail.com
Prepared by : Sanjay Challagundla
OracleERP@googlegroups.com
