FTE — Transportation Execution
64 documented tables · 11 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
FTE_LANES |
Stores services catalog lane descriptions. | hub-leaning |
FTE_SEL_OBJECTS |
This table holds object definitions that may use the selection tables and for retrieval of certain informatio | hub-leaning |
FTE_SEL_GROUPS |
This table is used define groups which are used to consolidate rules to an entity such as a customer, customer | hub-leaning |
FTE_LOAD_HEADERS |
Stores header level description of a shipment | hub-leaning |
FTE_LOAD_DETAILS |
Stores details of the contents of the shipment | hub-leaning |
FTE_SHIPMENT_STATUS_DETAILS |
Holds the Detail element of the ShipStatus message | hub-leaning |
FTE_MILE_TEMPLATES |
This table is used to store the template header information that is used to format the file for download and r | hub-leaning |
FTE_SEL_RULES |
this table holds header level rule information, such as rule id and name. The attributes (or restrictions) tha | hub-leaning |
FTE_SEL_RESULTS |
This table holds the result header information. Result attributes and values are stored in the FTE_SEL_RESULTS | hub-leaning |
FTE_LOAD_SCHEDULES |
Stores the schedules associated with a shipment | hub-leaning |
FTE_LOAD_CHARGES |
Holds the price related to the details of a tendered shipment | satellite-leaning |
FTE_MESSAGE_PARTNER |
This table stores all the partners listed in the Shipstatus message | hub-leaning |
FTE_MILE_DOWNLOAD_FILES |
This table is used to store the information of the file created for download. When uploading a file, this tabl | satellite-leaning |
FTE_MILE_TEMPLATE_COLUMNS |
This table is used to store the column data that is used to format the download/upload file. | satellite-leaning |
FTE_BATCH_JOBS |
Store informations about jobs being processed | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
FTE_TRIP_RATING_GRP |
GRP | 8 | 9 packages |
FTE_FREIGHT_RATING_DLVY_GRP |
GRP | 6 | 3 packages |
FTE_FREIGHT_RATING_PUB |
PUB | 1 | 2 packages |
FTE_PO_INTEGRATION_GRP |
GRP | 1 | 1 packages |
FTE_TP_GRP |
GRP | 7 | 1 packages |
FTE_DELIVERY_PUB |
PUB | 1 | 0 packages |