Table 52. Siebel Application to Oracle R11i Integration EAI Value Maps
|
Direction
|
Siebel Value
|
Siebel Display Value
|
Oracle Value
|
Oracle Meaning
|
OracleR11i Account Category
|
Description
|
Siebel account type to Oracle Applications customer class mapping
|
Siebel User Interface
|
Type (Account)
|
Siebel Buscomp.Field
|
Account.Type
|
Siebel LOV Type
|
ACCOUNT_ TYPE
|
Oracle User Interface
|
Category (Customer)
|
Oracle Table.Column
|
HZ_PARTIES. CATEGORY_ CODE
|
Oracle Lookup Type (Table)
|
CUSTOMER_ CATEGORY (AR_ LOOKUPS)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Customer
|
Customer
|
CUSTOMER
|
Customer
|
OracleR11i Account Phone
|
Description
|
Siebel account field name containing phone number mapping to Oracle phone type
|
Siebel User Interface
|
Main Fax #, Main Phone # (Account)
|
Siebel Buscomp.Field
|
Account.*
|
Siebel LOV Type
|
N/A
|
Oracle User Interface
|
Telephone Type (Customer)
|
Oracle Table.Column
|
HZ_CONTACT_POINTS. PHONE_LINE_TYPE
|
Oracle Lookup Type (Table)
|
PHONE_LINE_TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Main Fax Number
|
N/A
|
FAX
|
Fax
|
Siebel Outbound
|
Main Phone Number
|
N/A
|
PHONE
|
Phone
|
OracleR11i Account Status
|
Description
|
Siebel account status to Oracle customer status mapping
|
Siebel User Interface
|
Status (Account)
|
Siebel Buscomp.Field
|
Account. Account Status
|
Siebel LOV Type
|
ACCOUNT_ STATUS
|
Oracle User Interface
|
Status (Customer)
|
Oracle Table.Column
|
HZ_CUST_ ACCOUNTS.STATUS
|
Oracle Lookup Type (Table)
|
CUSTOMER_ STATUS (AR_ LOOKUPS)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Active
|
Active
|
A
|
Active Only
|
Siebel Outbound
|
Inactive
|
Inactive
|
I
|
Inactive Only
|
OracleR11i Address Phone
|
Description
|
Siebel address field name containing phone number mapping to Oracle phone type
|
Siebel User Interface
|
Not exposed in standard Account Address user interface
|
Siebel Buscomp.Field
|
Business Address.*
|
Siebel LOV Type
|
N/A
|
Oracle User Interface
|
Address Telephone Type (Customer)
|
Oracle Table.Column
|
HZ_CONTACT_POINTS. PHONE_LINE_TYPE
|
Oracle Lookup Type (Table)
|
PHONE_LINE_ TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Fax Number
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Phone Number
|
N/A
|
PHONE
|
Phone
|
OracleR11i Contact Phone
|
Description
|
Siebel contact field name containing phone number mapping to Oracle phone type
|
Siebel User Interface
|
Work Phone #, Work Fax #, Assistant Phone #, Home Phone # (Contact). Alternate Phone # and Cellular Phone # not exposed in standard UI.
|
Siebel Buscomp.Field
|
Contact.*
|
Siebel LOV Type
|
N/A
|
Oracle User Interface
|
Telephone Type (Customer Contact)
|
Oracle Table.Column
|
HZ_CONTACT_POINTS. PHONE_LINE_TYPE
|
Oracle Lookup Type (Table)
|
PHONE_LINE_ TYPE (FND_LOOKUP_VALUES) and COMMUNICATION_TYPE (FND_LOOKUP_VALUES)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Alternate Phone #
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Assistant Phone #
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Cellular Phone #
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Fax Phone #
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Home Phone #
|
N/A
|
PHONE
|
Phone
|
Siebel Outbound
|
Work Phone #
|
N/A
|
PHONE
|
Phone
|
OracleR11i Contact Title
|
Description
|
Siebel to Oracle Contact title (Mr., Mrs., and so on) mapping
|
Siebel User Interface
|
Mr./Ms. (Contact)
|
Siebel Buscomp.Field
|
Contact.M/M
|
Siebel LOV Type
|
MR_MS
|
Oracle User Interface
|
Title (Customer Contact)
|
Oracle Table.Column
|
RA_ CONTACTS. TITLE
|
Oracle Lookup Type (Table)
|
CONTACT_ TITLE (AR_ LOOKUPS)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Mr.
|
Mr.
|
MR
|
Mr.
|
Siebel Outbound
|
Mrs.
|
Mrs.
|
MRS
|
Mrs.
|
Siebel Outbound
|
Ms.
|
Ms.
|
MS
|
Ms.
|
Siebel Outbound
|
Dr.
|
Dr.
|
DR
|
Dr.
|
Siebel Outbound
|
Miss
|
Miss
|
MISS
|
Miss
|
OracleR11i Country
|
Description
|
Siebel to Oracle country mapping
|
Siebel User Interface
|
Country (Account Address)
|
Siebel Buscomp.Field
|
Business Address.
Country
|
Siebel LOV Type
|
COUNTRY
|
Oracle User Interface
|
Country (Customer Address)
|
Oracle Table.Column
|
HZ_LOCATIONS.COUNTRY
|
Oracle Lookup Type (Table)
|
FND_ TERRITORIES.TERRITORY_ CODE
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) - Setup - System - Countries
|
Siebel Outbound
|
USA
|
USA
|
US
|
United States
|
Siebel Outbound
|
United Kingdom
|
United Kingdom
|
GB
|
United Kingdom
|
OracleR11i Fob Code
|
Description
|
Siebel Freight Terms Info to Oracle FOB Point
|
Siebel User Interface
|
Shipping Terms Info
|
Siebel Buscomp.Field
|
Order Entry - Orders.Freight Terms Info
|
Siebel LOV Type
|
Not configured in standard product. A picklist should be configured on this field to take advantage of this mapping.
|
Oracle User Interface
|
FOB (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.FOB_ POINT_CODE
|
Oracle Lookup Type (Table)
|
FOB (AR_ LOOKUPS) (exposed through OE_ FOBS_ACTIVE_V)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Destination
|
N/A
|
Destination
|
Destination
|
Siebel Outbound
|
Origin
|
N/A
|
Origin
|
Origin
|
Siebel Outbound
|
CIF
|
N/A
|
CIF
|
CIF
|
Siebel Inbound
|
Destination
|
N/A
|
Destination
|
Destination
|
Siebel Inbound
|
Origin
|
N/A
|
Origin
|
Origin
|
Siebel Inbound
|
CIF
|
N/A
|
CIF
|
CIF
|
OracleR11i Freight
|
Description
|
Siebel to Oracle freight terms mapping
|
Siebel User Interface
|
Shipping Terms (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Freight Terms
|
Siebel LOV Type
|
FREIGHT_TERMS
|
Oracle User Interface
|
Freight Terms (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.FREIGHT_TERMS_ CODE
|
Oracle Lookup Type (Table)
|
FREIGHT_TERMS (OE_ LOOKUPS)
|
Oracle Screen Navigation
|
(Order Management Superuser responsibility) Setup > System > Quickcodes - Order Management
|
Siebel Outbound
|
Due
|
Due
|
Due
|
Prepay and Add
|
Siebel Outbound
|
No Charge
|
No Charge
|
Paid
|
Prepaid
|
Siebel Outbound
|
FOB
|
FOB
|
FOB
|
Freight on Board
|
Siebel Outbound
|
TBD
|
TBD
|
TBD
|
To Be Determined
|
Siebel Inbound
|
Due
|
Due
|
Due
|
Prepay and Add
|
Siebel Inbound
|
No Charge
|
No Charge
|
Paid
|
Prepaid
|
Siebel Inbound
|
FOB
|
FOB
|
FOB
|
Freight on Board
|
Siebel Inbound
|
TBD
|
TBD
|
TBD
|
To Be Determined
|
OracleR11i Order Line Status
|
Description
|
Siebel to Oracle order status mapping
|
Siebel User Interface
|
Status (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Status
|
Siebel LOV Type
|
FS_ORDER_ STATUS
|
Oracle User Interface
|
Status (Order)
|
Oracle Table.Column
|
OE_ORDER_ LINES_ALL. FLOW_ STATUS_CODE
|
Oracle Lookup Type (Table)
|
LINE_FLOW_ STATUS (OE_ LOOKUPS)
|
Oracle Screen Navigation
|
(Order Management Superuser responsibility) Setup >System > Quickcodes >Receivables
|
Siebel Inbound
|
Booked
|
Booked
|
BOOKED
|
Booked
|
Siebel Inbound
|
Open
|
Open
|
ENTERED
|
Entered
|
Siebel Inbound
|
Pending
|
Pending
|
AWAITING_ SHIPPING
|
Awaiting Shipping
|
Siebel Inbound
|
Cancelled
|
Cancelled
|
CANCELLED
|
Cancelled
|
Siebel Inbound
|
Closed
|
Closed
|
CLOSED
|
Closed
|
Siebel Inbound
|
Shipped
|
Shipped
|
INVOICED
|
Invoiced
|
Siebel Inbound
|
Shipped
|
Shipped
|
INVOICED_PARTIAL
|
Invoiced Partial
|
Siebel Inbound
|
Shipped
|
Shipped
|
SHIPPED
|
Shipped
|
Siebel Inbound
|
Closed
|
Closed
|
FULFILLED
|
Fulfilled
|
Oracle Screen Navigation (continued)
|
Siebel Inbound
|
Picked
|
Picked
|
PICKED
|
Picked
|
Siebel Inbound
|
Booked
|
Booked
|
SCHEDULED
|
Scheduled
|
Siebel Inbound
|
Picked
|
Picked
|
PICKED_PARTIAL
|
Picked partial
|
OracleR11i Order Status
|
Description
|
Siebel to Oracle order status mapping
|
Siebel User Interface
|
Status (Order)
|
Siebel Buscomp.Field
|
Order Entry - Order Lines.Status
|
Siebel LOV Type
|
FS_ORDER_ STATUS
|
Oracle User Interface
|
Status (Order Line)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.FLOW_ STATUS_CODE
|
Oracle Lookup Type (Table)
|
FLOW_ STATUS (OE_ LOOKUPS)
|
Oracle Screen Navigation
|
(Order Management Superuser responsibility) Setup > System > Quickcodes > Order Management
|
Siebel Outbound
|
Booked
|
Booked
|
BOOKED
|
Booked
|
Siebel Outbound
|
Open
|
Open
|
ENTERED
|
Entered
|
Siebel Inbound
|
Booked
|
Booked
|
BOOKED
|
Booked
|
Siebel Inbound
|
Open
|
Open
|
ENTERED
|
Entered
|
Siebel Inbound
|
Cancelled
|
Cancelled
|
CANCELLED
|
Cancelled
|
Siebel Inbound
|
Closed
|
Closed
|
CLOSED
|
Closed
|
OracleR11i Order Type
|
Description
|
Order type mapping
|
Siebel User Interface
|
Type (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Order Type --> Order Entry - Order Types.Order Type
|
Siebel LOV Type
|
FS_ORDER_ TYPE
|
Oracle User Interface
|
Type (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.ORDER_ TYPE_ID > OE_ORDER_ TYPES_115_ ALL.ORDER_ TYPE_ID > OE_ORDER_ TYPES_115_ ALL.NAME
|
Oracle Lookup Type (Table)
|
N/A
|
Siebel Outbound
|
eSales Order
|
eSales Order
|
Mixed
|
Order and Return Lines
|
Siebel Outbound
|
Sales Order
|
Sales Order
|
Mixed
|
Order and Return Lines
|
OracleR11i Payment Type Code
|
Description
|
Payment Type mapping
|
Siebel User Interface
|
Payment Method (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Payment Method
|
Siebel LOV Type
|
PAYMENT_METHOD
|
Oracle User Interface
|
Payment Type (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.PAYMENT_TYPE_CODE
|
Oracle Lookup Type (Table)
|
PAYMENT TYPE (OE_ LOOKUPS)
|
Oracle Screen Navigation
|
(Order Management Superuser responsibility) Setup > System > Quickcodes >Order Management
|
Siebel Outbound
|
Cash
|
N/A
|
CASH
|
Cash
|
Siebel Outbound
|
Check
|
N/A
|
CHECK
|
Check
|
Siebel Outbound
|
Credit
|
N/A
|
CREDIT_CARD
|
Credit Card
|
Siebel Inbound
|
Cash
|
N/A
|
CASH
|
Cash
|
Siebel Inbound
|
Check
|
N/A
|
CHECK
|
Check
|
Siebel Inbound
|
Credit
|
N/A
|
CREDIT_CARD
|
Credit Card
|
OracleR11i Sales Rep ID
|
Description
|
Siebel user ID to Oracle Sales Rep ID mapping
|
Siebel User Interface
|
Team (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Primary Position Contact Id
|
Siebel LOV Type
|
N/A
|
Oracle User Interface
|
Salesperson (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL. SALESREP_ID > RA_ SALESREPS_ ALL. SALESREP_ID
|
Oracle Lookup Type (Table)
|
N/A
|
Siebel Outbound
|
0 - 1
|
SADMIN
|
1449
|
|
OracleR11i Ship Method Code
|
Description
|
Order Shipment Carrier mapping
|
Siebel User Interface
|
Ship Carrier (Order), Ship Carrier (Order Line)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Carrier Type, Order Entry - Line Items.Carrier Code
|
Siebel LOV Type
|
FS_CARRIER
|
Oracle User Interface
|
Freight Carrier (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.SHIPPING_METHOD_ CODE, OE_ORDER_ LINES_ALL. SHIPPING_ METHOD_ CODE
|
Oracle Lookup Type (Table)
|
ORG_FREIGHT.FREIGHT_ CODE
|
Oracle Screen Navigation
|
(Order Management Superuser responsibility) Setup > Shipping > Freight > Define Freight Carriers
|
Siebel Outbound
|
Airborne
|
Airborne
|
AIRBORNE
|
Airborne
|
Siebel Outbound
|
DHL
|
DHL
|
DHL
|
DHL
|
Siebel Outbound
|
Emery
|
Emery
|
EMERY
|
Emery
|
Siebel Outbound
|
Fedex
|
Federal Express
|
Federal Express
|
Federal Express
|
Siebel Outbound
|
UPS
|
UPS
|
UPS
|
UPS
|
Siebel Outbound
|
US Mail
|
US Mail
|
USMAIL
|
US Mail
|
Siebel Inbound
|
Airborne
|
Airborne
|
AIRBORNE
|
Airborne
|
Siebel Inbound
|
DHL
|
DHL
|
DHL
|
DHL
|
Siebel Inbound
|
Emery
|
Emery
|
EMERY
|
Emery
|
Siebel Inbound
|
Fedex
|
Federal Express
|
Federal Express
|
Federal Express
|
Siebel Inbound
|
UPS
|
UPS
|
UPS
|
UPS
|
Siebel Inbound
|
US Mail
|
US Mail
|
USMAIL
|
US Mail
|
OracleR11i Shipment Priority
|
Description
|
Order priority mapping
|
Siebel User Interface
|
Priority (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Order Priority
|
Siebel LOV Type
|
FS_INVLOC_ ORDPRI
|
Oracle User Interface
|
Shipment Priority (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL. SHIPMENT_ PRIORITY_ CODE
|
Oracle Lookup Type (Table)
|
SHIPMENT_ PRIORITY (OE_ LOOKUPS)
|
Oracle Screen Navigation
|
(Order Management responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
High
|
High
|
High
|
High Priority
|
Siebel Outbound
|
Medium
|
Medium
|
Standard
|
Standard Priority
|
Siebel Inbound
|
High
|
High
|
High
|
High Priority
|
Siebel Inbound
|
Medium
|
Medium
|
Standard
|
Standard Priority
|
OracleR11i Tax Exempt Flag
|
Description
|
Tax Exempt status mapping
|
Siebel User Interface
|
Tax Exempt (Order)
|
Siebel Buscomp.Field
|
Order Entry - Orders.Tax Exempt
|
Siebel LOV Type
|
Boolean Y/N
|
Oracle User Interface
|
Tax Exemption Tax (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.TAX_ EXEMPT_FLAG
|
Oracle Lookup Type (Table)
|
S (Standard), E (Exempt), R (Require)
|
Siebel Inbound
|
N
|
Unchecked
|
S
|
Standard
|
Siebel Outbound
|
N
|
Unchecked
|
S
|
Standard
|
OracleR11i Tax Exempt Reason
|
Description
|
Tax Exempt Reason mapping
|
Siebel User Interface
|
Not exposed in standard User Interface
|
Siebel Buscomp.Field
|
Order Entry - Orders.Tax Exempt Reason
|
Siebel LOV Type
|
Boolean Y/N
|
Oracle User Interface
|
Tax Exemption: Reason (Order)
|
Oracle Table.Column
|
OE_ORDER_ HEADERS_ ALL.TAX_ EXEMPT_ REASON_
CODE
|
Oracle Lookup Type (Table)
|
TAX_REASON (AR_LOOKUPS)
|
Oracle Screen Navigation
|
(Receivables Manager responsibility) Setup > System > Quickcodes > Receivables
|
Siebel Outbound
|
Education
|
N/A
|
EDUCATION
|
education
|
Siebel Outbound
|
Hospital
|
N/A
|
HOSPITAL
|
hospital
|
Siebel Outbound
|
Manufacturer
|
N/A
|
MANUFACTURER
|
manufacturer
|
Siebel Inbound
|
Education
|
N/A
|
EDUCATION
|
education
|
Siebel Inbound
|
Hospital
|
N/A
|
HOSPITAL
|
hospital
|
Siebel Inbound
|
Manufacturer
|
N/A
|
MANUFACTURER
|
manufacturer
|
OracleR11i Unit of Measure
|
Description
|
Product unit of measure mapping
|
Siebel User Interface
|
U/M (Product)
|
Siebel Buscomp.Field
|
Order Entry - Line Items.Product Unit of Measure, Internal Product.Unit of Measure
|
Siebel LOV Type
|
UNIT_OF_ MEASURE
|
Oracle User Interface
|
Unit (Order Line), Primary Unit of Measure (Item)
|
Oracle Table.Column
|
OE_ORDER_ LINES_ALL. ORDER_ QUANTITY_ UOM, MTL_ SYSTEM_ ITEMS.
PRIMARY_ UOM_CODE
|
Oracle Lookup Type (Table)
|
MTL_UNITS_
OF_MEASURE.UOM_CODE
|
Oracle Screen Navigation
|
(Order Management responsibility) Setup - UOM - Units
|
Siebel Inbound
|
Dozen
|
Dozen
|
DZ
|
Dozen
|
Siebel Inbound
|
Each
|
Each
|
EA
|
Each
|
Siebel Inbound
|
Gram
|
Gram
|
G
|
Gram
|
Siebel Inbound
|
Kilogram
|
Kilogram
|
KG
|
Kilogram
|
Siebel Inbound
|
Litre
|
Litre
|
L
|
Liter
|
Siebel Inbound
|
Ounce
|
Ounce
|
OZ
|
Ounce
|
Siebel Inbound
|
Pound
|
Pound
|
LBS
|
Pound
|
Siebel Inbound
|
Day
|
Day
|
DAY
|
Day
|
Siebel Inbound
|
Foot
|
Foot
|
FT
|
Foot
|
Siebel Inbound
|
Hour
|
Hour
|
HR
|
Hour
|
Siebel Inbound
|
Dollar
|
Dollar
|
USD
|
US Dollar
|
Oracle Screen Navigation (continued)
|
Siebel Inbound
|
Year
|
Year
|
YR
|
Year
|
Siebel Inbound
|
Bag
|
Bag
|
BAG
|
Bag
|
Siebel Inbound
|
Case
|
Case
|
CSE
|
Case
|
Siebel Inbound
|
Half Pallet
|
Half Pallet
|
HPL
|
Half Pallet
|
Siebel Inbound
|
Pallet
|
Pallet
|
PL
|
Pallet
|
Siebel Inbound
|
Thousand
|
Thousand
|
BTH
|
Box of 1000
|
Siebel Inbound
|
Unit
|
Unit
|
UNT
|
Unit
|
Siebel Inbound
|
Dozen
|
Dozen
|
DOZ
|
Dozen
|
Siebel Inbound
|
Foot
|
Foot
|
FTP
|
Foot
|
Siebel Inbound
|
Kilogram
|
Kilogram
|
KGM
|
Kilogram
|
Siebel Inbound
|
Pound
|
Pound
|
LB
|
Pound
|
Siebel Inbound
|
Ounce
|
Ounce
|
OUZ
|
Ounce
|
OracleR11i User ID
|
Description
|
Siebel to Oracle User ID mapping
|
Siebel User Interface
|
Help > About Record
|
Siebel Buscomp.Field
|
Created By, Updated By, and so on > S_USER.ROW_ID
|
Siebel LOV Type
|
N/A
|
Oracle Table.Column
|
CREATED_BY, LAST_UPDATED_BY, and so on > FND_USER.
USER_ID
|
Oracle Lookup Type (Table)
|
N/A
|
Oracle Screen Navigation
|
(System Administrator responsibility) Security > User > Define
|
Siebel Outbound
|
0-1
|
SADMIN
|
1000112
|
N/A
|
