Table 32. Siebel Application to Oracle Integration EAI Value Maps
|
|
|
|
|
|
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 |