POS Tables (51)
POS - iSupplier Portal — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
POS_ACCT_ADDR_REL |
18 | Supplier bank account and address assignments |
POS_ACNT_ADDR_REQ |
12 | Table for supplier bank account and address assignment requests |
POS_ACNT_ADDR_SUMM_REQ |
14 | This table stores the details of supplier bank account and address assignment requests. |
POS_ACNT_GEN_REQ |
10 | Table for supplier bank account requests |
POS_ACNT_PAY_PREF |
13 | This table stores the payment preferences of suppliers for their addresses. |
POS_ADDRESS_NOTES |
9 | Notes for supplier addresses |
POS_ADDRESS_REQUESTS |
33 | Supplier Address Requests |
POS_ADDRESS_UPGRADE |
10 | Supplier address upgrade staging table |
POS_ASN_LOAD |
7 | This table will record ALL upload Excel ASN requests |
POS_ATTRPG_CONFIG |
10 | Supplier Data Hub project. Used to store RFI template association to operating unit during onboarding configuration. |
POS_BANK_ACCNT_OWNERS_INT |
26 | |
POS_BANK_ACCOUNT_DET_INT |
97 | |
POS_BUSINESS_CLASS_INT |
30 | |
POS_BUS_CLASS_ATTR |
25 | Supplier Business Classification Attributes |
POS_BUS_CLASS_REQS |
16 | Business Classification Requests for Suppliers |
POS_CAPACITY_TOLERANCE_TEMP |
10 | This Table is used to Store Cange in Capacity Tolerance Orders |
POS_CONTACT_REQUESTS |
29 | Supplier Contact Requests |
POS_CONTACT_UPGRADE |
11 | Supplier contact upgrade staging table |
POS_CONT_ADDR_REQUESTS |
13 | Requests for supplier contact and address links |
POS_FISCAL_CLASS_INT |
21 | |
POS_IMP_BATCH_SUMMARY |
68 | |
POS_MFG_CAPACITY_TEMP |
12 | This Table is used to Store Cange in Capacity for Orders |
POS_ORDER_MODIFIERS_TEMP |
11 | This table is used to store the order modifier request |
POS_ORG_HASH |
2 | Hash keys for operating unit identifier |
POS_OSN_ASSOCIATIONS |
6 | Table for storing the association between Oracle Supplier Network trading partners and the iSP vendors |
POS_OSN_REQUESTS |
18 | Table for storing inbound requests from Oracle Supplier Network |
POS_PARTY_TAX_PROFILE_INT |
20 | |
POS_PARTY_TAX_REG_INT |
33 | |
POS_PRODUCTS_SERVICES_GT |
12 | |
POS_PRODUCT_SERVICE_INT |
39 | |
POS_PRODUCT_SERVICE_REQUESTS |
30 | Requests for supplier products and services |
POS_PROMPTS |
1 | Dummy Table used for AK Region Definitions |
POS_RFI_TEMPLATE_CONFIG |
7 | Supplier Data Hub project. Used to store RFI template association to operating unit during onboarding configuration. |
POS_SPMNTF_SUBSCRIPTION |
8 | This table stores information on which users to send email notifications when supplier makes changes to their profile. |
POS_SUPPLIER_INT_REJECTIONS |
10 | |
POS_SUPPLIER_MAPPINGS |
9 | References to supplier parties and/or supplier requests |
POS_SUPPLIER_REGISTRATIONS |
41 | Supplier Registrations and Supplier Onboarding Requests |
POS_SUPPLIER_UDA_MERGE_GTT |
2 | |
POS_SUPP_GENERATE_XML_RPT |
8 | |
POS_SUPP_PROF_EXT_B |
107 | Supplier Data Hub project. Extension table to store user-defined attributes for Supplier related entities. |
POS_SUPP_PROF_EXT_INTF |
36 | Supplier Data Hub project. Interface table for Supplier user-defined attributes |
POS_SUPP_PROF_EXT_TL |
58 | Supplier Data Hub project. Translation table for POS_SUPP_PROF_EXT_B |
POS_SUPP_PUB_HISTORY |
12 | |
POS_SUPP_PUB_RESPONSES |
14 | |
POS_SUP_BANK_ACCOUNT_REQUESTS |
43 | This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12. |
POS_SUP_ONBOARD_CONFIG |
9 | Configurations for flexible supplier registration and onboarding |
POS_SUP_PRODUCTS_SERVICES |
29 | Supplier product and service classification |
POS_SURVEY_CONFIG |
10 | Supplier survey configuration |
POS_SURVEY_TRANSACTIONS |
11 | Supplier survey transaction table |
POS_UPGRADE_USERS |
11 | This table will record all the users upgraded for ISP |
POS_VENDOR_UPG_TMP |
3 | This table is used during release 11i to release 12 upgrade. It stores vendor_ids of vendors who are considered in iSupplier Portal TCA Sup |