This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine. |
---|
The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_ATTACHMENT_MAPS_U1 | UNIQUE | APPS_TS_TX_IDX |
MSGID
CID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Y | This is the message id |
CID | VARCHAR2 | (256) | Y | Content Id through whic user uniquely identifies the attachment |
FID | NUMBER | Y | File Id of attachment | |
DATATYPE | NUMBER | Y | This type of attachment files | |
ORDERINDEX | NUMBER | This is the order index of attachments | ||
NESTPARENTINDEX | NUMBER | This is nest parent index |
ECX.ECX_ATTACHMENT_MAPS does not reference any database object
ECX.ECX_ATTACHMENT_MAPS is referenced by following:
Description: | This table contains the mapping information between the source and target attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_ATTRIBUTE_MAPPINGS.MAP_ID | ECX_MAPPINGS |
This table contains the mapping information between the source and target attributes
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_ATTRIBUTE_MAPPINGS_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
ATTRIBUTE_MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_MAP_ID | NUMBER | Y | Attribute Mapping Identifier | |
LEVEL_MAPPING_ID | NUMBER | Y | Level Mapping Identifier | |
SOURCE_ATTRIBUTE_ID | NUMBER | Y | Source Attribute Identifier | |
TARGET_ATTRIBUTE_ID | NUMBER | Y | Target Attribute Identifier | |
MAP_ID | NUMBER | Y | Map Identifier | |
OCCURRENCE | NUMBER | No longer used | ||
COND_VALUE | VARCHAR2 | (10) | No longer used | |
COND_NODE | VARCHAR2 | (25) | No longer used | |
PARENT_ATTRIBUTE_MAP_ID | NUMBER | No longer used | ||
COND_NODE_TYPE | VARCHAR2 | (10) | No longer used |
ECX.ECX_ATTRIBUTE_MAPPINGS does not reference any database object
ECX.ECX_ATTRIBUTE_MAPPINGS is referenced by following:
Description: | This table contains the document logs for Inbound, outbound and passthrough messages |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_DOCLOGS.PARTYID | HZ_PARTIES |
ECX_DOCLOGS.PARTYID | PO_VENDORS |
Foreign Key Column | Foreign Table |
---|---|
AR_DOCUMENT_TRANSFERS.CONFIRMATION_MSGID | ECX_DOCLOGS |
AR_DOCUMENT_TRANSFERS.DOCUMENT_MSGID | ECX_DOCLOGS |
ECX_EXTERNAL_LOGS.OUT_MSGID | ECX_DOCLOGS |
This table contains the document logs for Inbound, outbound and passthrough messages
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_DOCLOGS_U1 | UNIQUE | APPS_TS_TX_IDX | MSGID |
SYS_IL0000165327C00019$$ | UNIQUE | APPS_TS_TX_DATA | |
ECX_DOCLOGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | INTERNAL_CONTROL_NUMBER |
ECX_DOCLOGS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_TYPE
ITEM_KEY |
ECX_DOCLOGS_N3 | NONUNIQUE | APPS_TS_TX_IDX | TIME_STAMP |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Y | Message Iedntifier in a Queue |
MESSAGE_TYPE | VARCHAR2 | (100) | Payload Type | |
MESSAGE_STANDARD | VARCHAR2 | (100) | Payload Standard | |
TRANSACTION_TYPE | VARCHAR2 | (100) | External Transaction Type Code | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | External Transaction Subtype Code | |
DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Identifier | |
PARTYID | VARCHAR2 | (256) | No longer used | |
PARTY_SITE_ID | VARCHAR2 | (256) | Source Trading Partner Party Site Identifier | |
PARTY_TYPE | VARCHAR2 | (30) | No longer used | |
PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
USERNAME | VARCHAR2 | (500) | Receiving UserName | |
PASSWORD | VARCHAR2 | (500) | Receiving Password | |
ATTRIBUTE1 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (500) | Descriptive flexfield segment | |
PAYLOAD | CLOB | (4000) | Message Payload | |
FIELD1 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD2 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD3 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD4 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD5 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD6 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD7 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD8 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD9 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD10 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD11 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD12 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD13 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD14 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD15 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD16 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD17 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD18 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD19 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD20 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD21 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD22 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD23 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD24 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD25 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD26 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD27 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD28 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD29 | VARCHAR2 | (2000) | Reserved for Inbound | |
FIELD30 | VARCHAR2 | (2000) | Reserved for Inbound | |
LOGFILE | VARCHAR2 | (80) | Transaction Logfile | |
INTERNAL_CONTROL_NUMBER | NUMBER | Internal Message Control Number | ||
STATUS | VARCHAR2 | (256) | Message Processing Status | |
DIRECTION | VARCHAR2 | (240) | Message Direction | |
TIME_STAMP | DATE | Time Log was Last Updated | ||
OUT_MSGID | RAW | (16) | Outbound Message Identifier | |
ITEM_TYPE | VARCHAR2 | (8) | Workflow Item Type | |
ITEM_KEY | VARCHAR2 | (240) | Workflow Item Key | |
ACTIVITY_ID | NUMBER | Workflow activity id | ||
EVENT_NAME | VARCHAR2 | (240) | Workflow event name | |
EVENT_KEY | VARCHAR2 | (240) | Workflow event key | |
ORIG_REFERENCE_ID | VARCHAR2 | (240) | Original Reference Id | |
CB_EVENT_NAME | VARCHAR2 | (240) | Message Callback event name | |
CB_EVENT_KEY | VARCHAR2 | (240) | Message Callback event key | |
BLOCK_MODE | VARCHAR2 | (1) | Message Callback Mode |
ECX.ECX_DOCLOGS does not reference any database object
ECX.ECX_DOCLOGS is referenced by following:
Description: | This table contains the DTD's used by XML Gateway |
---|
This table contains the DTD's used by XML Gateway
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_DTDS_U1 | UNIQUE | APPS_TS_SEED |
FILENAME
ROOT_ELEMENT VERSION |
ECX_DTDS_U2 | UNIQUE | APPS_TS_SEED | DTD_ID |
SYS_IL0000165421C00006$$ | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DTD_ID | NUMBER | Y | DTD Identifier | |
DESCRIPTION | VARCHAR2 | (256) | DTD Description | |
FILENAME | VARCHAR2 | (256) | DTD FileName | |
ROOT_ELEMENT | VARCHAR2 | (256) | Y | DTD Root Element |
VERSION | VARCHAR2 | (256) | User-defined DTD Version | |
PAYLOAD | CLOB | (4000) | Actual DTD |
ECX.ECX_DTDS does not reference any database object
ECX.ECX_DTDS is referenced by following:
Description: | This table contains the error messages that are generated during transaction processing. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_EXTERNAL_LOGS.ERROR_ID | ECX_ERROR_MSGS |
ECX_EXTERNAL_RETRY.ERROR_ID | ECX_ERROR_MSGS |
ECX_INBOUND_LOGS.ERROR_ID | ECX_ERROR_MSGS |
ECX_MSG_LOGS.ERROR_ID | ECX_ERROR_MSGS |
ECX_OUTBOUND_LOGS.ERROR_ID | ECX_ERROR_MSGS |
This table contains the error messages that are generated during transaction processing.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_ERROR_MSGS_U1 | UNIQUE | APPS_TS_TX_IDX | ERROR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_ID | NUMBER | (15) | Y | Error Message Identifier |
MESSAGE | VARCHAR2 | (2000) | Error Message | |
MESSAGE_PARAMETERS | VARCHAR2 | (4000) | Message Parameters |
ECX.ECX_ERROR_MSGS does not reference any database object
ECX.ECX_ERROR_MSGS is referenced by following:
Description: | This table contains the outbound message logs. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_EXTERNAL_LOGS.ERROR_ID | ECX_ERROR_MSGS |
ECX_EXTERNAL_LOGS.OUT_MSGID | ECX_DOCLOGS |
This table contains the outbound message logs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_EXTERNAL_LOGS_U1 | UNIQUE | APPS_TS_TX_IDX | EXTERNAL_PROCESS_ID |
ECX_EXTERNAL_LOGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | ERROR_ID |
ECX_EXTERNAL_LOGS_N2 | NONUNIQUE | APPS_TS_TX_IDX | OUT_MSGID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTERNAL_PROCESS_ID | NUMBER | (15) | Y | External Process Identifier |
OUT_MSGID | RAW | (16) | Y | Message Identifier |
STATUS | VARCHAR2 | (240) | Document Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
TIME_STAMP | DATE | Last Update Time Stamp |
ECX.ECX_EXTERNAL_LOGS does not reference any database object
ECX.ECX_EXTERNAL_LOGS is referenced by following:
Description: | This table contains the outbound logs for resent messages. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_EXTERNAL_RETRY.ERROR_ID | ECX_ERROR_MSGS |
This table contains the outbound logs for resent messages.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_EXTERNAL_RETRY_U1 | UNIQUE | APPS_TS_TX_IDX | RETRY_MSGID |
ECX_EXTERNAL_RETRY_N1 | NONUNIQUE | APPS_TS_TX_IDX | ERROR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Y | Original Message Identifier |
RETRY_MSGID | RAW | (16) | Y | Retry Message Identifier |
STATUS | VARCHAR2 | (240) | Retry Document Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
TIME_STAMP | DATE | Last Update Time Stamp |
ECX.ECX_EXTERNAL_RETRY does not reference any database object
ECX.ECX_EXTERNAL_RETRY is referenced by following:
Description: | This table contains the external transaction definitions. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_TP_DETAILS.EXT_PROCESS_ID | ECX_EXT_PROCESSES |
This table contains the external transaction definitions.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_ECX_PROCESSES_U2 | UNIQUE | APPS_TS_SEED | EXT_PROCESS_ID |
ECX_EXT_PROCESSES_U1 | UNIQUE | APPS_TS_SEED |
TRANSACTION_ID
STANDARD_ID DIRECTION EXT_TYPE EXT_SUBTYPE |
ECX_EXT_PROCESSES_N1 | NONUNIQUE | APPS_TS_SEED |
EXT_TYPE
EXT_SUBTYPE STANDARD_ID DIRECTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXT_PROCESS_ID | NUMBER | Y | External Transaction Identifier | |
EXT_TYPE | VARCHAR2 | (80) | Y | External Transaction Type |
EXT_SUBTYPE | VARCHAR2 | (80) | Y | External Transaction Subtype |
TRANSACTION_ID | NUMBER | (15) | Y | Internal Transaction Identifier |
STANDARD_ID | NUMBER | (15) | Y | Standard Identifier |
QUEUE_NAME | VARCHAR2 | (256) | Queue Name | |
DIRECTION | VARCHAR2 | (20) | Y | Transaction Direction |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_EXT_PROCESSES does not reference any database object
ECX.ECX_EXT_PROCESSES is referenced by following:
Description: | This table contains XSLT Files |
---|
This table contains XSLT Files
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_FILES_U1 | UNIQUE | APPS_TS_SEED | ID |
SYS_IL0000194132C00003$$ | UNIQUE | APPS_TS_SEED | |
ECX_FILES_N1 | NONUNIQUE | APPS_TS_SEED |
TYPE
NAME VERSION APPLICATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
PAYLOAD | CLOB | (4000) | actual content of the file | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
NAME | VARCHAR2 | (256) | Y | name of file |
VERSION | NUMBER | (15) | Version of the File | |
APPLICATION_CODE | VARCHAR2 | (256) | Y | application code |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
TYPE | VARCHAR2 | (256) | Y | file type i.e. XML ,XSLT,DTD's |
ID | NUMBER | (15) | Y | Unique identifier for the table |
ECX.ECX_FILES does not reference any database object
ECX.ECX_FILES is referenced by following:
Description: | This table contains the hub definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_HUB_USERS.HUB_ID | ECX_HUBS |
This table contains the hub definitions
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_HUBS_U1 | UNIQUE | APPS_TS_SEED |
NAME
PROTOCOL_TYPE |
ECX_HUBS_U2 | UNIQUE | APPS_TS_SEED | HUB_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HUB_ID | NUMBER | Y | Hub Identifier | |
NAME | VARCHAR2 | (100) | Y | Hub Name |
PROTOCOL_TYPE | VARCHAR2 | (30) | Y | Protocol Type |
PROTOCOL_ADDRESS | VARCHAR2 | (512) | Protocol Address | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_HUBS does not reference any database object
ECX.ECX_HUBS is referenced by following:
Description: | This table contains the hub user definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_HUB_USERS.HUB_ID | ECX_HUBS |
Foreign Key Column | Foreign Table |
---|---|
ECX_TP_DETAILS.HUB_USER_ID | ECX_HUB_USERS |
This table contains the hub user definitions
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_HUB_USERS_U1 | UNIQUE | APPS_TS_SEED |
HUB_ID
HUB_ENTITY_CODE USERNAME |
ECX_HUB_USERS_U2 | UNIQUE | APPS_TS_SEED | HUB_USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HUB_USER_ID | NUMBER | Y | Hub User Identifier | |
HUB_ID | NUMBER | Y | Hub Identifier | |
HUB_ENTITY_CODE | VARCHAR2 | (100) | Y | Hub Location Code |
USERNAME | VARCHAR2 | (512) | Y | Receiving UserName |
PASSWORD | VARCHAR2 | (500) | Receiving Password | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_HUB_USERS does not reference any database object
ECX.ECX_HUB_USERS is referenced by following:
Description: | This table contains the inbound transaction logs. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_INBOUND_LOGS.ERROR_ID | ECX_ERROR_MSGS |
This table contains the inbound transaction logs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_INBOUND_LOGS_U1 | UNIQUE | APPS_TS_TX_IDX | TRIGGER_ID |
ECX_INBOUND_LOGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | MSGID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Y | Triggerring Identifier |
MSGID | RAW | (16) | Message Identifier | |
PROCESS_ID | RAW | (16) | Process Identifier | |
STATUS | VARCHAR2 | (256) | Processing Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
LOGFILE | VARCHAR2 | (256) | Processing Logfile | |
TIME_STAMP | DATE | Last Update Time Stamp |
ECX.ECX_INBOUND_LOGS does not reference any database object
ECX.ECX_INBOUND_LOGS is referenced by following:
Description: | This table contains the relationship between the source and target mappings |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_LEVEL_MAPPINGS.MAP_ID | ECX_MAPPINGS |
This table contains the relationship between the source and target mappings
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_LEVEL_MAPPINGS_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
LEVEL_MAPPING_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_MAPPING_ID | NUMBER | Y | Level Mapping Identifier | |
SOURCE_LEVEL_ID | NUMBER | Y | Source Object Level Identifier | |
TARGET_LEVEL_ID | NUMBER | Y | Target Object Level Identifier | |
SOURCE_ELEMENT_ID | NUMBER | First Source Attribute Identifier | ||
MAP_ID | NUMBER | Y | Map Identifier | |
TARGET_ELEMENT_ID | NUMBER | First Target Attribute Identifier |
ECX.ECX_LEVEL_MAPPINGS does not reference any database object
ECX.ECX_LEVEL_MAPPINGS is referenced by following:
Description: | The table contains the definitions of the maps that are used by XML Gateway |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_ATTRIBUTE_MAPPINGS.MAP_ID | ECX_MAPPINGS |
ECX_LEVEL_MAPPINGS.MAP_ID | ECX_MAPPINGS |
ECX_PROC_MAPPINGS.MAP_ID | ECX_MAPPINGS |
ECX_TP_DETAILS.MAP_ID | ECX_MAPPINGS |
ECX_OBJECTS.MAP_ID | ECX_MAPPINGS |
ECX_OBJECT_LEVELS.MAP_ID | ECX_MAPPINGS |
ECX_OBJECT_ATTRIBUTES.MAP_ID | ECX_MAPPINGS |
The table contains the definitions of the maps that are used by XML Gateway
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_MAPPINGS_U1 | UNIQUE | APPS_TS_SEED | MAP_CODE |
ECX_MAPPINGS_U2 | UNIQUE | APPS_TS_SEED | MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MAP_ID | NUMBER | Y | Map Identifier | |
MAP_CODE | VARCHAR2 | (30) | Y | Map Code |
DESCRIPTION | VARCHAR2 | (4000) | Map Description | |
OBJECT_ID_SOURCE | NUMBER | Y | Source Object Identifier | |
OBJECT_ID_TARGET | NUMBER | Y | Target Object Identifier | |
ENABLED | VARCHAR2 | (1) | Maps Enabled Flag | |
ECX_MAJOR_VERSION | NUMBER | (15) | Y | ECX Major Version |
ECX_MINOR_VERSION | NUMBER | (15) | Y | ECX Minor Version |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_MAPPINGS does not reference any database object
ECX.ECX_MAPPINGS is referenced by following:
Description: | This table contains the inbound and outbound message logs. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_MSG_LOGS.ERROR_ID | ECX_ERROR_MSGS |
This table contains the inbound and outbound message logs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_MSG_LOGS_U1 | UNIQUE | APPS_TS_TX_IDX | LOG_ID |
ECX_MSG_LOGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | ERROR_ID |
ECX_MSG_LOGS_N2 | NONUNIQUE | APPS_TS_TX_IDX | TRIGGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | (15) | Y | Message Log Identifier |
TRIGGER_ID | NUMBER | (15) | Y | Trigger Identifier |
ERROR_ID | NUMBER | (15) | Y | Error Message Identifier |
ECX.ECX_MSG_LOGS does not reference any database object
ECX.ECX_MSG_LOGS is referenced by following:
Description: | This table contains the source and target objects for the maps. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_OBJECTS.MAP_ID | ECX_MAPPINGS |
This table contains the source and target objects for the maps.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_OBJECTS_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | Y | Object Identifier | |
OBJECT_NAME | VARCHAR2 | (255) | Object Name | |
OBJECT_TYPE | VARCHAR2 | (30) | Object Type | |
OBJECT_DESCRIPTION | VARCHAR2 | (255) | Object Description | |
OBJECT_STANDARD | VARCHAR2 | (30) | Object Standard | |
ROOT_ELEMENT | VARCHAR2 | (255) | Root Element | |
FULLPATH | VARCHAR2 | (255) | DTD Path and FileName | |
MAP_ID | NUMBER | Y | Map Identifier | |
RUNTIME_LOCATION | VARCHAR2 | (250) | Map version of the object |
ECX.ECX_OBJECTS does not reference any database object
ECX.ECX_OBJECTS is referenced by following:
Description: | This table contains the source and target object Attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_OBJECT_ATTRIBUTES.MAP_ID | ECX_MAPPINGS |
This table contains the source and target objectAttributes
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_OBJECT_ATTRIBUTES_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
ATTRIBUTE_ID OBJECTLEVEL_ID |
ECX_OBJECT_ATTRIBUTES_N1 | NONUNIQUE | APPS_TS_SEED | XREF_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Y | Attribute Identifier | |
OBJECTLEVEL_ID | NUMBER | Y | Object Level Identifier | |
ATTRIBUTE_NAME | VARCHAR2 | (255) | Attribute Name | |
OBJECT_COLUMN_FLAG | VARCHAR2 | (2) | Database Column Flag | |
DATA_TYPE | NUMBER | Data Type | ||
PARENT_ATTRIBUTE_ID | NUMBER | Y | Parent Attribute Identifier | |
POSITION | NUMBER | No longer used | ||
WIDTH | NUMBER | No longer used | ||
XREF_CATEGORY_ID | NUMBER | Code Conversion Category Identifier | ||
STAGING_COLUMN | VARCHAR2 | (30) | No longer used | |
DEFAULT_VALUE | VARCHAR2 | (255) | Attribute Default Value | |
ATTRIBUTE_TYPE | VARCHAR2 | (20) | Attribute Type | |
HAS_ATTRIBUTES | VARCHAR2 | (20) | Number of Attributes | |
LEAF_NODE | VARCHAR2 | (1) | Attribute is a Leaf Node Indicator | |
REQUIRED_FLAG | VARCHAR2 | (1) | No longer used | |
MAP_ID | NUMBER | Y | Map Identifier | |
COND_NODE | VARCHAR2 | (50) | Condition Node Name | |
COND_VALUE | VARCHAR2 | (50) | Condition Node Value | |
COND_NODE_TYPE | VARCHAR2 | (25) | Condition Node Type | |
OCCURRENCE | NUMBER | (15) | No longer used | |
IS_MAPPED | VARCHAR2 | (20) | Attribute is Mapped Indicator |
ECX.ECX_OBJECT_ATTRIBUTES does not reference any database object
ECX.ECX_OBJECT_ATTRIBUTES is referenced by following:
Description: | This table contains the source and target object Levels |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_OBJECT_LEVELS.MAP_ID | ECX_MAPPINGS |
This table contains the source and target object Levels
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_OBJECT_LEVELS_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
OBJECTLEVEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECTLEVEL_ID | NUMBER | Y | Object Level Identifier | |
OBJECT_ID | NUMBER | Y | Object Identifier | |
OBJECT_LEVEL | NUMBER | Logical Level | ||
OBJECT_LEVEL_NAME | VARCHAR2 | (255) | Object Level Name | |
PARENT_LEVEL | NUMBER | Parent Object Level | ||
ENABLED | VARCHAR2 | (1) | No longer used | |
MAP_ID | NUMBER | Y | Map Identifier |
ECX.ECX_OBJECT_LEVELS does not reference any database object
ECX.ECX_OBJECT_LEVELS is referenced by following:
Description: | This table contains the outbound transaction logs |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_OUTBOUND_LOGS.ERROR_ID | ECX_ERROR_MSGS |
ECX_OUTBOUND_LOGS.PARTY_ID | HZ_PARTIES |
ECX_OUTBOUND_LOGS.PARTY_ID | PO_VENDORS |
This table contains the outbound transaction logs
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_OUTBOUND_LOGS_U1 | UNIQUE | APPS_TS_TX_IDX | TRIGGER_ID |
ECX_OUTBOUND_LOGS_N1 | NONUNIQUE | APPS_TS_TX_IDX | OUT_MSGID |
ECX_OUTBOUND_LOGS_N2 | NONUNIQUE | APPS_TS_TX_IDX | TIME_STAMP |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Y | Trigger Identifier |
TRANSACTION_TYPE | VARCHAR2 | (100) | External Transaction Type | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | External Transaction Subtype | |
PARTY_ID | VARCHAR2 | (256) | Party Identifier | |
PARTY_SITE_ID | VARCHAR2 | (256) | Party Site Identifier | |
DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Number | |
PROCESS_ID | RAW | (16) | No longer used | |
STATUS | VARCHAR2 | (256) | Processing Status | |
ERROR_ID | NUMBER | (15) | Error Message Identifier | |
OUT_MSGID | RAW | (16) | Message Identifier | |
LOGFILE | VARCHAR2 | (256) | Processing Logfile | |
TIME_STAMP | DATE | Last Update Time Stamp | ||
PARTY_TYPE | VARCHAR2 | (30) | The Party Type |
ECX.ECX_OUTBOUND_LOGS does not reference any database object
ECX.ECX_OUTBOUND_LOGS is referenced by following:
Description: | This table contains the Oracle Transport Agent message logs |
---|
This table contains the Oracle Transport Agent message logs
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_OXTA_LOGMSG_N1 | NONUNIQUE | APPS_TS_TX_IDX |
DIRECTION
STATUS RESULT_CODE |
ECX_OXTA_LOGMSG_N2 | NONUNIQUE | APPS_TS_TX_IDX | SENDER_MESSAGE_ID |
ECX_OXTA_LOGMSG_N3 | NONUNIQUE | APPS_TS_TX_IDX | RECEIPT_MESSAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SENDER_MESSAGE_ID | VARCHAR2 | (50) | Y | Sender Message Identifier |
DIRECTION | VARCHAR2 | (3) | Y | Message Direction |
STATUS | VARCHAR2 | (15) | Y | Message Status |
BEGIN_DATE | DATE | Y | Message Start Date | |
REQUEST_TYPE | VARCHAR2 | (15) | Y | Request Type |
CONTENT_LENGTH | NUMBER | Message length | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | Transaction Type | |
USERNAME | VARCHAR2 | (500) | UserName | |
IP_ADDRESS | VARCHAR2 | (15) | IP Address | |
PROTOCOL_TYPE | VARCHAR2 | (80) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (500) | Protocol Address | |
RESULT_CODE | VARCHAR2 | (4) | Result Status Code | |
RESULT_TEXT | VARCHAR2 | (2000) | Result Message | |
RECEIPT_MESSAGE_ID | VARCHAR2 | (50) | Receipt Message Identifier | |
COMPLETED_DATE | DATE | Message Processing Date | ||
EXCEPTION_TEXT | VARCHAR2 | (2000) | Exception Message |
ECX.ECX_OXTA_LOGMSG does not reference any database object
ECX.ECX_OXTA_LOGMSG is referenced by following:
Description: | This table contains the procedure mappings |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_PROC_MAPPINGS.MAP_ID | ECX_MAPPINGS |
ECX_PROC_MAPPINGS.TRANSTAGE_ID | ECX_TRAN_STAGE_DATA |
This table contains the procedure mappings
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_PROC_MAPPINGS_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
PROCMAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCMAP_ID | NUMBER | Y | Procedure map Identifier | |
TRANSTAGE_ID | NUMBER | Y | Transaction stage Identifier | |
PARAMETER_NAME | VARCHAR2 | (250) | Parameter Name | |
ACTION_TYPE | NUMBER | IN or OUT parameter | ||
VARIABLE_LEVEL | NUMBER | Direction variable Level | ||
VARIABLE_NAME | VARCHAR2 | (255) | Variable Name | |
DATA_TYPE | NUMBER | Datatype as specified in Oracle server | ||
VARIABLE_POS | NUMBER | Variable Position | ||
MAP_ID | NUMBER | Y | Map Identifier | |
VARIABLE_DIRECTION | VARCHAR2 | (1) | Variable direction (Direction or Global or Literal | |
VARIABLE_CONSTANT | VARCHAR2 | (2000) | Stores Literal Value | |
VARIABLE_VALUE | VARCHAR2 | (200) | Variable Value |
ECX.ECX_PROC_MAPPINGS does not reference any database object
ECX.ECX_PROC_MAPPINGS is referenced by following:
Description: | This table contains the standards definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_XREF_DTL_B.STANDARD_ID | ECX_STANDARDS_B |
This table contains the standards definitions
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_STANDARDS_B_U1 | UNIQUE | APPS_TS_SEED |
STANDARD_CODE
STANDARD_TYPE |
ECX_STANDARDS_B_U2 | UNIQUE | APPS_TS_SEED | STANDARD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STANDARD_ID | NUMBER | Y | Standard Identifier | |
STANDARD_CODE | VARCHAR2 | (30) | Y | Standard Code |
STANDARD_TYPE | VARCHAR2 | (30) | Y | Standard Type |
STANDARD_DESC | VARCHAR2 | (80) | ||
DATA_SEEDED | VARCHAR2 | (1) | Seeded Data Flag | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
APPLICATION_ID | NUMBER | Application Id |
ECX.ECX_STANDARDS_B does not reference any database object
ECX.ECX_STANDARDS_B is referenced by following:
Description: | This table contains the translated standards definition |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_STANDARDS_TL_U1 | UNIQUE | APPS_TS_SEED |
STANDARD_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STANDARD_ID | NUMBER | Y | ||
STANDARD_DESC | VARCHAR2 | (80) | Standard Code Description | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LANGUAGE | VARCHAR2 | (4) | Y | Translated Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Seeded language |
ECX.ECX_STANDARDS_TL does not reference any database object
ECX.ECX_STANDARDS_TL is referenced by following:
Description: | This table contains the attributes for a given standard |
---|
This table contains the attributes for a given standard
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_STANDARD_ATTRIBUTES_U1 | UNIQUE | APPS_TS_SEED |
STANDARD_ID
ATTRIBUTE_NAME |
ECX_STANDARD_ATTRIBUTES_U2 | UNIQUE | APPS_TS_SEED | STANDARD_ATTRIBUTE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STANDARD_ATTRIBUTE_ID | NUMBER | Y | Standard Attribute Identifier | |
STANDARD_ID | NUMBER | Y | Standard identifier | |
ATTRIBUTE_NAME | VARCHAR2 | (30) | Y | Standard Attribute name |
ELEMENT_TAG_NAME | VARCHAR2 | (30) | Standard Element Name | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_STANDARD_ATTRIBUTES does not reference any database object
ECX.ECX_STANDARD_ATTRIBUTES is referenced by following:
Description: | This table contains the trading partner detail information |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_TP_DETAILS.EXT_PROCESS_ID | ECX_EXT_PROCESSES |
ECX_TP_DETAILS.HUB_USER_ID | ECX_HUB_USERS |
ECX_TP_DETAILS.MAP_ID | ECX_MAPPINGS |
ECX_TP_DETAILS.ROUTING_ID | ECX_TP_DETAILS |
ECX_TP_DETAILS.TP_HEADER_ID | ECX_TP_HEADERS |
Foreign Key Column | Foreign Table |
---|---|
ECX_TP_DETAILS.ROUTING_ID | ECX_TP_DETAILS |
This table contains the trading partner detail information
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_TP_DETAILS_U2 | UNIQUE | APPS_TS_TX_IDX | TP_DETAIL_ID |
ECX_TP_DETAILS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
EXT_PROCESS_ID
SOURCE_TP_LOCATION_CODE |
ECX_TP_DETAILS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
TP_HEADER_ID
EXT_PROCESS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Y | Trading partner Header Identifier | |
TP_DETAIL_ID | NUMBER | Y | Trading partner Detail Identifier | |
MAP_ID | NUMBER | Y | Map Identifier | |
EXT_PROCESS_ID | NUMBER | Y | External transaction Identifier | |
CONNECTION_TYPE | VARCHAR2 | (30) | Connection Type | |
HUB_USER_ID | NUMBER | Hub User Identifier | ||
PROTOCOL_TYPE | VARCHAR2 | (30) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (512) | Protocol Address | |
USERNAME | VARCHAR2 | (512) | Username | |
PASSWORD | VARCHAR2 | (500) | Password | |
ROUTING_ID | NUMBER | Routing id for passthrough transaction | ||
SOURCE_TP_LOCATION_CODE | VARCHAR2 | (200) | Source trading partner Location Code | |
EXTERNAL_TP_LOCATION_CODE | VARCHAR2 | (200) | Target trading partner Location Code | |
OMB_SYNC | VARCHAR2 | (1) | No longer Used | |
CONFIRMATION | NUMBER | (2) | Confirmation Indicator | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
HUB_ID | NUMBER | Hub ID |
ECX.ECX_TP_DETAILS does not reference any database object
ECX.ECX_TP_DETAILS is referenced by following:
Description: | This table contains Trading Partner header information |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_TP_HEADERS.PARTY_ID | HZ_PARTIES |
ECX_TP_HEADERS.PARTY_ID | PO_VENDORS |
ECX_TP_HEADERS.PARTY_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
ECX_XREF_DTL.TP_HEADER_ID | ECX_TP_HEADERS |
ECX_XREF_DTL_B.TP_HEADER_ID | ECX_TP_HEADERS |
ECX_TP_DETAILS.TP_HEADER_ID | ECX_TP_HEADERS |
This table contains Trading Partner header information
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_TP_HEADERS_U1 | UNIQUE | APPS_TS_SEED |
PARTY_ID
PARTY_SITE_ID PARTY_TYPE |
ECX_TP_HEADERS_U2 | UNIQUE | APPS_TS_SEED | TP_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Y | Trading Partner Header Identifier | |
PARTY_TYPE | VARCHAR2 | (30) | Y | Party type |
PARTY_ID | NUMBER | Y | Party Identifier | |
PARTY_SITE_ID | NUMBER | Y | Party Site identifier | |
COMPANY_ADMIN_EMAIL | VARCHAR2 | (256) | Y | Trading Partner Administrator Email Address |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_TP_HEADERS does not reference any database object
ECX.ECX_TP_HEADERS is referenced by following:
Description: | This table contains internal transaction definitions |
---|
This table contains internal transaction definitions
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_TRANSACTIONS_B_U1 | UNIQUE | APPS_TS_SEED |
TRANSACTION_TYPE
TRANSACTION_SUBTYPE PARTY_TYPE |
ECX_TRANSACTIONS_B_U2 | UNIQUE | APPS_TS_SEED | TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Internal Transaction identifier | |
TRANSACTION_DESCRIPTION | VARCHAR2 | (256) | ||
TRANSACTION_TYPE | VARCHAR2 | (100) | Y | Internal Transaction Type |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Y | Internal Transaction subtype |
PARTY_TYPE | VARCHAR2 | (30) | Y | Party type |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ENABLED | VARCHAR2 | (240) | Enabled | |
APPLICATION_ID | NUMBER | Application Id | ||
ADMIN_USER | VARCHAR2 | (240) | Admin User |
ECX.ECX_TRANSACTIONS_B does not reference any database object
ECX.ECX_TRANSACTIONS_B is referenced by following:
Description: | This table contains translated internal transaction definitions |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_TRANSACTIONS_TL_U1 | UNIQUE | APPS_TS_SEED |
TRANSACTION_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | ||
TRANSACTION_DESCRIPTION | VARCHAR2 | (256) | Internal Transaction Description | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LANGUAGE | VARCHAR2 | (4) | Y | Translated Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Seeded Language |
ECX.ECX_TRANSACTIONS_TL does not reference any database object
ECX.ECX_TRANSACTIONS_TL is referenced by following:
Description: | This table contains the action definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_PROC_MAPPINGS.TRANSTAGE_ID | ECX_TRAN_STAGE_DATA |
This table contains the action definitions
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_TRAN_STAGE_DATA_U1 | UNIQUE | APPS_TS_SEED |
MAP_ID
TRANSTAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSTAGE_ID | NUMBER | Y | Transaction Stage Identifier | |
SOURCE_LEVEL_ID | NUMBER | Source Object Level Identifier | ||
STAGE | NUMBER | Processing Stage | ||
SEQ_NUMBER | NUMBER | Action Sequence Number | ||
ACTION_TYPE | NUMBER | Action Type | ||
VARIABLE_LEVEL | NUMBER | Result Variable Level | ||
VARIABLE_NAME | VARCHAR2 | (255) | Result Variable Name | |
VARIABLE_VALUE | VARCHAR2 | (2000) | Result Variable Value | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Result Default Value | |
SEQUENCE_NAME | VARCHAR2 | (255) | Sequence Name | |
CUSTOM_PROCEDURE_NAME | VARCHAR2 | (255) | Database Procedure Name | |
DATA_TYPE | NUMBER | (15) | Datatype | |
FUNCTION_NAME | VARCHAR2 | (255) | Database Function Name | |
WHERE_CLAUSE | VARCHAR2 | (2000) | Where Clause | |
VARIABLE_POS | NUMBER | Result Variable Postion | ||
MAP_ID | NUMBER | Y | Map Identifier | |
OBJECTLEVEL_ID | NUMBER | Y | Object Level Identifier | |
OBJECT_DIRECTION | VARCHAR2 | (1) | Object Direction | |
VARIABLE_DIRECTION | VARCHAR2 | (1) | Result Direction | |
ACTION_POS | NUMBER | Action Postion | ||
COND_LOGICAL_OPERATOR | VARCHAR2 | (10) | Not Used | |
COND_OPERATOR1 | VARCHAR2 | (20) | First Condition Operator | |
COND_VAR1_LEVEL | NUMBER | (15) | First Condition Variable Level | |
COND_VAR1_NAME | VARCHAR2 | (240) | First Condition Variable Name | |
COND_VAR1_POS | NUMBER | (15) | First Condition Variable Position | |
COND_VAR1_DIRECTION | VARCHAR2 | (20) | First Condition Variable Direction | |
COND_VAR1_CONSTANT | VARCHAR2 | (2000) | First Condition Variable Constant | |
COND_OPERATOR2 | VARCHAR2 | (240) | Not Used | |
COND_VAR2_LEVEL | NUMBER | (15) | Not Used | |
COND_VAR2_NAME | VARCHAR2 | (240) | Not Used | |
COND_VAR2_POS | NUMBER | (15) | Not Used | |
COND_VAR2_DIRECTION | VARCHAR2 | (20) | Not Used | |
COND_VAR2_CONSTANT | VARCHAR2 | (2000) | Not Used | |
COND_VAL1_LEVEL | NUMBER | (15) | First Condition Value Level | |
COND_VAL1_NAME | VARCHAR2 | (240) | First Condition Value Name | |
COND_VAL1_POS | NUMBER | (15) | First Condition Value Position | |
COND_VAL1_DIRECTION | VARCHAR2 | (20) | First Condition Value Direction | |
COND_VAL1_CONSTANT | VARCHAR2 | (2000) | First Condition Value Constant | |
COND_VAL2_LEVEL | NUMBER | (15) | Not Used | |
COND_VAL2_NAME | VARCHAR2 | (240) | Not Used | |
COND_VAL2_POS | NUMBER | (15) | Not Used | |
COND_VAL2_DIRECTION | VARCHAR2 | (20) | Not Used | |
COND_VAL2_CONSTANT | VARCHAR2 | (2000) | Not Used | |
OPERAND1_LEVEL | NUMBER | (15) | First Operand Level | |
OPERAND1_NAME | VARCHAR2 | (240) | First Operand Name | |
OPERAND1_POS | NUMBER | (15) | First Operand Position | |
OPERAND1_DIRECTION | VARCHAR2 | (20) | First Operand Direction | |
OPERAND1_CONSTANT | VARCHAR2 | (2000) | First Operand Constant | |
OPERAND1_START_POS | NUMBER | (15) | Not Used | |
OPERAND1_LEN | NUMBER | (15) | Not Used | |
OPERAND2_NAME | VARCHAR2 | (240) | Second Operand Name | |
OPERAND2_LEVEL | NUMBER | (15) | Second Operand Level | |
OPERAND2_POS | NUMBER | (15) | Second Operand Position | |
OPERAND2_DIRECTION | VARCHAR2 | (20) | Second Operand Direction | |
OPERAND2_CONSTANT | VARCHAR2 | (2000) | Second Operand Constant | |
OPERAND3_LEVEL | NUMBER | (15) | Third Operand Level | |
OPERAND3_NAME | VARCHAR2 | (240) | Third Operand Name | |
OPERAND3_POS | NUMBER | (15) | Third Operand Position | |
OPERAND3_DIRECTION | VARCHAR2 | (20) | Third Operand Direction | |
OPERAND3_CONSTANT | VARCHAR2 | (2000) | Third Operand Constant | |
OPERAND4_LEVEL | NUMBER | (15) | Fourth Operand Level | |
OPERAND4_NAME | VARCHAR2 | (240) | Fourth Operand Name | |
OPERAND4_POS | NUMBER | (15) | Fourth Operand Position | |
OPERAND4_DIRECTION | VARCHAR2 | (20) | Fourth Operand Direction | |
OPERAND4_CONSTANT | VARCHAR2 | (2000) | Fourth Operand Constant | |
OPERAND5_LEVEL | NUMBER | (15) | Fifth Operand Level | |
OPERAND5_NAME | VARCHAR2 | (240) | Fifth Operand Name | |
OPERAND5_POS | NUMBER | (15) | Fifth Operand Position | |
OPERAND5_DIRECTION | VARCHAR2 | (20) | Fifth Operand Direction | |
OPERAND5_CONSTANT | VARCHAR2 | (2000) | Fifth Operand Constant | |
OPERAND6_LEVEL | NUMBER | (15) | Sixth Operand Level | |
OPERAND6_NAME | VARCHAR2 | (240) | Sixth Operand Name | |
OPERAND6_POS | NUMBER | (15) | Sixth Operand Position | |
OPERAND6_DIRECTION | VARCHAR2 | (20) | Sixth Operand Direction | |
OPERAND6_CONSTANT | VARCHAR2 | (2000) | Sixth Operand Constant |
ECX.ECX_TRAN_STAGE_DATA does not reference any database object
ECX.ECX_TRAN_STAGE_DATA is referenced by following:
Description: | This table contains the trading partners code conversion values. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_XREF_DTL_B.TP_HEADER_ID | ECX_TP_HEADERS |
ECX_XREF_DTL_B.XREF_CATEGORY_ID | ECX_XREF_HDR_B |
ECX_XREF_DTL_B.STANDARD_ID | ECX_STANDARDS_B |
This table contains the trading partners code conversion values.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_DTL_B_U1 | UNIQUE | APPS_TS_TX_IDX |
XREF_CATEGORY_ID
STANDARD_ID XREF_INT_VALUE XREF_EXT_VALUE DIRECTION TP_HEADER_ID |
ECX_XREF_DTL_B_U2 | UNIQUE | APPS_TS_TX_IDX | XREF_DTL_ID |
ECX_XREF_DTL_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
XREF_CATEGORY_ID
TP_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_DTL_ID | NUMBER | Y | Conversion Category Value Identifier | |
XREF_CATEGORY_ID | NUMBER | Y | Code Conversion Category Identifier | |
STANDARD_ID | NUMBER | Y | Standard Identifier | |
XREF_STANDARD_CODE | VARCHAR2 | (80) | Not Used | |
TP_HEADER_ID | NUMBER | Y | Trading Partner Header Identifier | |
XREF_EXT_VALUE | VARCHAR2 | (240) | Y | Code Conversion External Category Value |
XREF_INT_VALUE | VARCHAR2 | (240) | Y | Code Conversion Internal Category Value |
DESCRIPTION | VARCHAR2 | (240) | ||
DIRECTION | VARCHAR2 | (10) | Y | Direction |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
APPLICATION_ID | NUMBER | Application Id |
ECX.ECX_XREF_DTL_B does not reference any database object
ECX.ECX_XREF_DTL_B is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_DTL_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
XREF_DTL_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_DTL_ID | NUMBER | Y | ||
DESCRIPTION | VARCHAR2 | (240) | ||
LANGUAGE | VARCHAR2 | (4) | Y | |
SOURCE_LANG | VARCHAR2 | (4) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_XREF_DTL_TL does not reference any database object
ECX.ECX_XREF_DTL_TL is referenced by following:
Description: | This table contains the code conversion categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
ECX_XREF_DTL_B.XREF_CATEGORY_ID | ECX_XREF_HDR_B |
This table contains the code conversion categories.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_HDR_B_U1 | UNIQUE | APPS_TS_SEED | XREF_CATEGORY_CODE |
ECX_XREF_HDR_B_U2 | UNIQUE | APPS_TS_SEED | XREF_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_CATEGORY_ID | NUMBER | Y | Code Conversion Category unique identifier | |
XREF_CATEGORY_CODE | VARCHAR2 | (30) | Y | Code Conversion Category Code |
DESCRIPTION | VARCHAR2 | (256) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
APPLICATION_ID | NUMBER | Application Id |
ECX.ECX_XREF_HDR_B does not reference any database object
ECX.ECX_XREF_HDR_B is referenced by following:
Description: | This table contains the translated code conversion categories. |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_HDR_TL_U1 | UNIQUE | APPS_TS_SEED |
XREF_CATEGORY_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_CATEGORY_ID | NUMBER | Y | ||
DESCRIPTION | VARCHAR2 | (256) | Code Conversion Category Description | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LANGUAGE | VARCHAR2 | (4) | Y | Translated Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Seeded Language |
ECX.ECX_XREF_HDR_TL does not reference any database object
ECX.ECX_XREF_HDR_TL is referenced by following:
Description: | This table contains the code conversion category values. |
---|
This table contains the code conversion category values.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_STANDARDS_B_U1 | UNIQUE | APPS_TS_SEED |
XREF_CATEGORY_ID
STANDARD_ID XREF_INT_VALUE |
ECX_XREF_STANDARDS_B_U2 | UNIQUE | APPS_TS_SEED | XREF_STANDARD_ID |
ECX_XREF_STANDARDS_B_U3 | UNIQUE | APPS_TS_SEED |
XREF_CATEGORY_ID
STANDARD_ID XREF_STD_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_STANDARD_ID | NUMBER | Y | Code Conversion Category Value Identifier | |
XREF_CATEGORY_ID | NUMBER | Y | Category Id | |
STANDARD_ID | NUMBER | Y | Standard Id | |
XREF_STANDARD_CODE | VARCHAR2 | (240) | Standard Code | |
XREF_STD_VALUE | VARCHAR2 | (240) | Y | Code Conversion Standard Value |
XREF_INT_VALUE | VARCHAR2 | (240) | Y | Code Conversion Internal Value |
DESCRIPTION | VARCHAR2 | (240) | ||
DATA_SEEDED | VARCHAR2 | (1) | Seeded Data Indicator | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
APPLICATION_ID | NUMBER | Application Id |
ECX.ECX_XREF_STANDARDS_B does not reference any database object
ECX.ECX_XREF_STANDARDS_B is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
ECX_XREF_STANDARDS_TL_U1 | UNIQUE | APPS_TS_SEED |
XREF_STANDARD_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_STANDARD_ID | NUMBER | Y | ||
DESCRIPTION | VARCHAR2 | (240) | ||
LANGUAGE | VARCHAR2 | (4) | Y | |
SOURCE_LANG | VARCHAR2 | (4) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
ECX.ECX_XREF_STANDARDS_TL does not reference any database object
ECX.ECX_XREF_STANDARDS_TL is referenced by following:
A public view which may be useful for custom reporting or other data requirements.
Dummy View for OAG Level
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) | Dummy Column |
APPS.ECX_DUMMY1_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Dummy View for OAG Level
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) | Dummy Column |
APPS.ECX_DUMMY2_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data requirements.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.ECX_HEADER_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Status for Inbound Messages
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Triggerring Identifier | |
DOCUMENT_ID | VARCHAR2 | (256) | Document Identifier | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Internal Transaction Type | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Internal Transaction Subtype | |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
INTERNAL_CONTROL_NUMBER | NUMBER | Internal Message Control Number | ||
PROCESSING_STATUS | VARCHAR2 | (256) | Processing Status | |
PROCESSING_MESSAGE | VARCHAR2 | (4000) | Processing Message | |
PROCESSING_TIMESTAMP | DATE | Processing Timestamp | ||
PROCESSING_LOGFILE | VARCHAR2 | (256) | Processing Logfile | |
OUT_MSGID | RAW | (16) | Message Identifier | |
MSGID | RAW | (16) | Y | Message Identifier |
A public view which may be useful for custom reporting or other data requirements.
Stores XML Lookup Values
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | Lookup Type |
LOOKUP_CODE | VARCHAR2 | (30) | Y | Lookup Code |
MEANING | VARCHAR2 | (80) | Y | Lookup Code meaning |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | Enabled Flag |
START_DATE_ACTIVE | DATE | Active Start Date | ||
END_DATE_ACTIVE | DATE | Active End Date |
A public view which may be useful for custom reporting or other data requirements.
Dummy View for OAG level
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) | Dummy Column |
APPS.ECX_MSGNAME_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View for OAG confirmation BOD
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSGID | RAW | (16) | Y | Message Identifier |
MESSAGE_TYPE | VARCHAR2 | (100) | Payload type | |
EXT_TYPE | VARCHAR2 | (100) | External Transaction Type | |
EXT_SUBTYPE | VARCHAR2 | (100) | External Transaction subtype | |
DOCUMENT_NUMBER | VARCHAR2 | (256) | Document Number | |
PARTY_CODE | VARCHAR2 | (256) | Party Name | |
PARTY_SITE_CODE | VARCHAR2 | (256) | Party Site Name | |
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
EXCHANGE_NAME | VARCHAR2 | (500) | Exchange Name | |
ATTRIBUTE2 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ROUTING_PARTY_CODE | VARCHAR2 | (500) | Routing Party Identifier | |
ATTRIBUTE4 | VARCHAR2 | (500) | Descriptive flexfield segment | |
ORIG_REFERENCE_ID | VARCHAR2 | (240) | Original Document's ID | |
VERB | VARCHAR2 | (2000) | Verb | |
NOUN | VARCHAR2 | (2000) | Noun | |
REVISION | VARCHAR2 | (2000) | Revision | |
LOGICALID | VARCHAR2 | (2000) | Logical Identifier | |
COMPONENT | VARCHAR2 | (2000) | Component | |
TASK | VARCHAR2 | (2000) | Task | |
REFERENCEID | VARCHAR2 | (2000) | Reference Identifier | |
CONFIRMATION | VARCHAR2 | (2000) | Confirmation Code | |
LANGUAGE | VARCHAR2 | (2000) | Language | |
CODEPAGE | VARCHAR2 | (2000) | Code Page | |
AUTHID | VARCHAR2 | (2000) | Authorization Identifier | |
YEAR | VARCHAR2 | (2000) | Datetime - Year Qualifier | |
MONTH | VARCHAR2 | (2000) | Datetime - Month Qualifier | |
DAY | VARCHAR2 | (2000) | Datetime - Day Qualifier | |
HOUR | VARCHAR2 | (2000) | Datetime - Hour Qualifier | |
MINUTE | VARCHAR2 | (2000) | Datetime - Minute Qualifier | |
SECOND | VARCHAR2 | (2000) | Datetime -Second Qualifier | |
SUBSECOND | VARCHAR2 | (2000) | Datetime -Subsecond Qualifier | |
TIMEZONE | VARCHAR2 | (2000) | Time Zone | |
FIELD20 | VARCHAR2 | (2000) | Reserved Field | |
FIELD21 | VARCHAR2 | (2000) | Reserved Field | |
FIELD22 | VARCHAR2 | (2000) | Reserved Field | |
FIELD23 | VARCHAR2 | (2000) | Reserved Field | |
FIELD24 | VARCHAR2 | (2000) | Reserved Field | |
FIELD25 | VARCHAR2 | (2000) | Reserved Field | |
FIELD26 | VARCHAR2 | (2000) | Reserved Field | |
FIELD27 | VARCHAR2 | (2000) | Reserved Field | |
FIELD28 | VARCHAR2 | (2000) | Reserved Field | |
FIELD29 | VARCHAR2 | (2000) | Reserved Field | |
FIELD30 | VARCHAR2 | (2000) | Reserved Field | |
LOGFILE | VARCHAR2 | (80) | Transaction Logfile | |
DOCUMENT_ID | NUMBER | Document Identifier |
A public view which may be useful for custom reporting or other data requirements.
View for the Open Applications Group (OAG) Control Area.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VERB_VALUE | VARCHAR2 | (80) | Y | Verb Value |
VERB_ATTVALUE | VARCHAR2 | (80) | Y | Verb Attribute Value |
NOUN_VALUE | VARCHAR2 | (80) | Y | Noun Value |
NOUN_ATTVALUE | VARCHAR2 | (80) | Y | Noun Attribute Value |
COMPONENT | VARCHAR2 | (100) | Y | Component |
TASK | VARCHAR2 | (100) | Y | Task |
LOGICAL_ID | VARCHAR2 | (4000) | Logical Identifier | |
REFERENCE_ID | VARCHAR2 | (4000) | Reference Identifier | |
AUTHID | VARCHAR2 | (30) | Authorization Identifier | |
DATETIME | DATE | Datetime | ||
DATE_ATTVALUE | CHAR | (8) | Datetime Attribute Value | |
LANGUAGE | VARCHAR2 | (52) | Language | |
CONFIRMATION | NUMBER | (2) | Confirmation Code | |
REVISION_VALUE | VARCHAR2 | (0) | Revision Value | |
REVISION_ATTVALUE | VARCHAR2 | (0) | Revision Attribute Value | |
CODEPAGE | VARCHAR2 | (64) | Code Page | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Y | Internal Transaction Type |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Y | Internal Transaction Subtype |
USERNAME | VARCHAR2 | (512) | username | |
SOURCE_TP_LOCATION_CODE | VARCHAR2 | (200) | Source trading partner location code | |
PARTY_ID | NUMBER | Y | Party Identifier | |
PARTY_SITE_ID | NUMBER | Y | Party Site Identifier | |
PARTY_TYPE | VARCHAR2 | (30) | Y | Party Type |
A public view which may be useful for custom reporting or other data requirements.
View for the Open Applications Group (OAG) Control Area.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VERB_VALUE | VARCHAR2 | (80) | Y | Verb Value |
VERB_ATTVALUE | VARCHAR2 | (80) | Y | Verb Attribute Value |
NOUN_VALUE | VARCHAR2 | (80) | Y | Noun Value |
NOUN_ATTVALUE | VARCHAR2 | (80) | Y | Noun Attribute Value |
COMPONENT | VARCHAR2 | (80) | Y | Component |
TASK | VARCHAR2 | (80) | Y | Task |
LOGICAL_ID | VARCHAR2 | (4000) | Logical Identifier | |
REFERENCE_ID | CHAR | (1) | Reference Identifier | |
AUTHID | VARCHAR2 | (30) | Authorization Identifier | |
DATETIME | DATE | Datetime | ||
DATE_ATTVALUE | CHAR | (8) | Datetime Attribute Value | |
LANGUAGE | VARCHAR2 | (52) | Language | |
CONFIRMATION | NUMBER | Confirmation Code | ||
REVISION_VALUE | VARCHAR2 | (0) | Revision Value | |
REVISION_ATTVALUE | VARCHAR2 | (0) | Revision Attribute Value | |
CODEPAGE | VARCHAR2 | (64) | Code Page | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Y | Internal Transaction Type |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Y | Internal Transaction Subtype |
APPS.ECX_OAG_CONTROLAREA_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Status for Outbound Messages
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Triggerring Identifier | |
DOCUMENT_ID | VARCHAR2 | (256) | Document Identifier | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Internal Transaction Type | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Internal Transaction Subtype | |
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
PARTY_ID | VARCHAR2 | (256) | Party Identifier | |
PARTY_SITE_ID | VARCHAR2 | (256) | Party Site Identifier | |
GENERATION_STATUS | VARCHAR2 | (256) | Message Generation Status | |
GENERATION_MESSAGE | VARCHAR2 | (4000) | Generating Message | |
GENERATION_TIMESTAMP | DATE | Generating Timestamp | ||
GENERATION_LOGFILE | VARCHAR2 | (256) | Message Generated Logfile | |
OUT_MSGID | RAW | (16) | Message Identifier | |
DELIVERY_STATUS | VARCHAR2 | (240) | Delivery Status | |
DELIVERY_MESSAGE | VARCHAR2 | (4000) | Delivery Message | |
DELIVERY_TIMESTAMP | DATE | Delivery Timestamp | ||
RETRY_STATUS | VARCHAR2 | (240) | Retry Status | |
RETRY_MESSAGE | VARCHAR2 | (4000) | Retry Message | |
RETRY_TIMESTAMP | DATE | Retry Timestamp | ||
PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
RETRY_MSGID | RAW | (16) | Retry Message Identifier |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (0) | Party Number |
APPS.ECX_PARTIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (0) | Dummy |
APPS.ECX_PARTY_SITES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
ECX Standards
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
STANDARD_ID | NUMBER | Y | Standard Id | |
STANDARD_CODE | VARCHAR2 | (30) | Y | Standard Code |
STANDARD_TYPE | VARCHAR2 | (30) | Y | Standard Type |
DATA_SEEDED | VARCHAR2 | (1) | Data Seeded | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
STANDARD_DESC | VARCHAR2 | (80) | Standard Description |
A public view which may be useful for custom reporting or other data requirements.
This view contains the trading partner detail information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Y | Trading Partner Header Identifier | |
TP_DETAIL_ID | NUMBER | Y | Trading Partner Detail Identifier | |
MAP_ID | NUMBER | Y | Map Identifier | |
EXT_PROCESS_ID | NUMBER | Y | External Transaction Identifier | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Y | Internal Transaction Type |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Y | Internal Transaction Subtype |
STANDARD_CODE | VARCHAR2 | (30) | Y | Standard Code |
EXT_TYPE | VARCHAR2 | (80) | Y | External Transaction Type |
EXT_SUBTYPE | VARCHAR2 | (80) | Y | External Transaction Subtype |
TRANSACTION_DIRECTION | VARCHAR2 | (20) | Y | Transaction Direction |
CONNECTION_TYPE | VARCHAR2 | (30) | Connection Type | |
HUB_USER_ID | NUMBER | Hub User Identifier | ||
PROTOCOL_TYPE | VARCHAR2 | (30) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (512) | Protocol Address | |
USERNAME | VARCHAR2 | (512) | Username | |
PASSWORD | VARCHAR2 | (500) | Password | |
ROUTING_ID | NUMBER | Routing ID for Passthrough Transaction | ||
CONFIRMATION | NUMBER | (2) | Confirmation Code | |
SOURCE_TP_LOCATION_CODE | VARCHAR2 | (200) | Source Trading Partner Location Code | |
EXTERNAL_TP_LOCATION_CODE | VARCHAR2 | (200) | Destination Trading Partner Location Code | |
OMB_SYNC | VARCHAR2 | (1) | No Longer Used | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
HUB_ID | NUMBER | Hub ID |
A public view which may be useful for custom reporting or other data requirements.
This table contains the trading partner header information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Trading Partner Header Identifier | ||
PARTY_TYPE | VARCHAR2 | (240) | Party Type | |
PARTY_ID | NUMBER | Party Identifier | ||
PARTY_SITE_ID | NUMBER | Party Site Identifier | ||
PARTY_NAME | VARCHAR2 | (360) | Party Name | |
PARTY_SITE_NAME | VARCHAR2 | (1146) | Party Site identifier | |
COMPANY_ADMIN_EMAIL | VARCHAR2 | (256) | Trading Partner Administration Email Address | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ORG_ID | NUMBER | Organization identifier |
A public view which may be useful for custom reporting or other data requirements.
ECX Transactions
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
TRANSACTION_ID | NUMBER | Y | Transaction ID | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Y | Transaction Type |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Y | Transaction Subtype |
PARTY_TYPE | VARCHAR2 | (30) | Y | Party Type |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
TRANSACTION_DESCRIPTION | VARCHAR2 | (256) | Transaction Description | |
ADMIN_USER | VARCHAR2 | (240) | Admin User |
A public view which may be useful for custom reporting or other data requirements.
Code conversion Trading Partner detail
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
XREF_DTL_ID | NUMBER | Y | Detail Id | |
XREF_CATEGORY_ID | NUMBER | Y | Category ID | |
STANDARD_ID | NUMBER | Y | Standard ID | |
XREF_STANDARD_CODE | VARCHAR2 | (80) | Standard Code | |
TP_HEADER_ID | NUMBER | Y | Header ID | |
XREF_EXT_VALUE | VARCHAR2 | (240) | Y | External Value |
XREF_INT_VALUE | VARCHAR2 | (240) | Y | Interrnal Value |
DIRECTION | VARCHAR2 | (10) | Y | Direction |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
DESCRIPTION | VARCHAR2 | (240) | Description |
A public view which may be useful for custom reporting or other data requirements.
View showing code categories for maps
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
XREF_CATEGORY_ID | NUMBER | Y | Code Conversion Category unique identifier | |
XREF_CATEGORY_CODE | VARCHAR2 | (30) | Y | Code Conversion Category Code |
DESCRIPTION | VARCHAR2 | (256) | Category Code Description | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.ECX_XREF_HDR_MAPPED_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Code Category
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
XREF_CATEGORY_ID | NUMBER | Y | Category ID | |
XREF_CATEGORY_CODE | VARCHAR2 | (30) | Y | Category Code |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
DESCRIPTION | VARCHAR2 | (256) | Description |
A public view which may be useful for custom reporting or other data requirements.
Code conversion standard detail
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
XREF_STANDARD_ID | NUMBER | Y | Standard ID | |
XREF_CATEGORY_ID | NUMBER | Y | Category ID | |
STANDARD_ID | NUMBER | Y | Standard ID | |
XREF_STANDARD_CODE | VARCHAR2 | (240) | Standard Code | |
XREF_STD_VALUE | VARCHAR2 | (240) | Y | Standard Value |
XREF_INT_VALUE | VARCHAR2 | (240) | Y | Internal Value |
DATA_SEEDED | VARCHAR2 | (1) | Data Seeded Flag | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
DESCRIPTION | VARCHAR2 | (240) | Description |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |