POS — iSupplier Portal
51 documented tables · 41 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
POS_SUPPLIER_MAPPINGS |
References to supplier parties and/or supplier requests | hub |
POS_SUPPLIER_REGISTRATIONS |
Supplier Registrations and Supplier Onboarding Requests | satellite-leaning |
POS_ADDRESS_REQUESTS |
Supplier Address Requests | hub-leaning |
POS_BUS_CLASS_ATTR |
Supplier Business Classification Attributes | satellite-leaning |
POS_ACNT_ADDR_REQ |
Table for supplier bank account and address assignment requests | satellite-leaning |
POS_SUP_BANK_ACCOUNT_REQUESTS |
This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12. | satellite-leaning |
POS_CONTACT_REQUESTS |
Supplier Contact Requests | satellite-leaning |
POS_OSN_REQUESTS |
Table for storing inbound requests from Oracle Supplier Network | standalone |
POS_ACNT_ADDR_SUMM_REQ |
This table stores the details of supplier bank account and address assignment requests. | link |
POS_PRODUCT_SERVICE_REQUESTS |
Requests for supplier products and services | satellite-leaning |
POS_SUP_PRODUCTS_SERVICES |
Supplier product and service classification | standalone |
POS_ACCT_ADDR_REL |
Supplier bank account and address assignments | link |
POS_ORDER_MODIFIERS_TEMP |
This table is used to store the order modifier request | standalone |
POS_ORG_HASH |
Hash keys for operating unit identifier | satellite-leaning |
POS_MFG_CAPACITY_TEMP |
This Table is used to Store Cange in Capacity for Orders | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
POS_SUP_PROF_MRG_GRP |
GRP | 1 | 2 packages |
POS_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
POS_EXCELASN_GRP |
GRP | 1 | 0 packages |
POS_SUP_PROF_PRG_GRP |
GRP | 1 | 0 packages |
POS_VIEW_RECEIPTS_GRP |
GRP | 5 | 0 packages |
POS_SCO_TOLERANCE_GRP |
GRP | 14 | 0 packages |