Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - EDR Tables and Views

TABLE - EDR.EDR_AMERULE_INPUT_VAR
TABLE - EDR.EDR_AMETRAN_INPUT_VAR
TABLE - EDR.EDR_COLLATE_PRINT_TEMP
TABLE - EDR.EDR_ERECORDS
TABLE - EDR.EDR_ERECORD_ID_TEMP
TABLE - EDR.EDR_ERESMANAGER_T
TABLE - EDR.EDR_ERESPARAMETERS_T
TABLE - EDR.EDR_ESIGNATURES
TABLE - EDR.EDR_EVENT_RELATIONSHIP
TABLE - EDR.EDR_FILES_B
TABLE - EDR.EDR_FILES_TL
TABLE - EDR.EDR_FWK_TEST_B
TABLE - EDR.EDR_FWK_TEST_TL
TABLE - EDR.EDR_IDX_XML_ELEMENT_B
TABLE - EDR.EDR_IDX_XML_ELEMENT_TL
TABLE - EDR.EDR_IDX_XML_ELEMENT_USAGES
TABLE - EDR.EDR_INTER_EVENT_TEST_EVENTS
TABLE - EDR.EDR_INTER_EVENT_TEST_SCENARIOS
TABLE - EDR.EDR_PREPARE_DOCUMENT_TEMP
TABLE - EDR.EDR_PROCESS_ERECORDS_T
TABLE - EDR.EDR_PSIG_DETAILS
TABLE - EDR.EDR_PSIG_DOCUMENTS
TABLE - EDR.EDR_PSIG_DOC_PARAMS_B
TABLE - EDR.EDR_PSIG_DOC_PARAMS_TL
TABLE - EDR.EDR_PSIG_PRINT_HISTORY
TABLE - EDR.EDR_PSIG_SIGN_PARAMS_B
TABLE - EDR.EDR_PSIG_SIGN_PARAMS_TL
TABLE - EDR.EDR_RAW_XML_T
TABLE - EDR.EDR_REDLINE_TRANS_DATA
TABLE - EDR.EDR_RULE_CONDITION_TEMP
TABLE - EDR.EDR_RULE_DETAIL_TEMP
TABLE - EDR.EDR_SECURITY_RULES
TABLE - EDR.EDR_TRANS_ACKN
TABLE - EDR.EDR_TRANS_QUERY_TEMP
VIEW - APPS.EDR_FILES_LATEST_VERSION_V
VIEW - APPS.EDR_FILES_VL
VIEW - APPS.EDR_FWK_TEST_VL
VIEW - APPS.EDR_IDX_XML_ELEMENT_VL
VIEW - APPS.EDR_INTER_EVENT_TEST_EVENTS_V
VIEW - APPS.EDR_PSIG_DOC_PARAMS_VL
VIEW - APPS.EDR_PSIG_SIGN_PARAMS_VL
VIEW - APPS.EDR_SECURE_ELEMENTS_V
VIEW - APPS.EDR_WFEVENT_XMLMAP_V
VIEW - APPS.EDR_XMLMAP_ELEMENTS_V

Table: EDR_AMERULE_INPUT_VAR

Description: AME Rule Input Variable Table
Primary Key: EDR_AMERULE_INPUT_VAR_P
  1. AME_TRANS_NAME
  2. INPUT_NAME
  3. RULE_ID
Comments

AME Rule Input Variable Table

Indexes
Index Type Tablespace Column
EDR_AMERULE_INPUT_VAR_P UNIQUE APPS_TS_TX_IDX AME_TRANS_NAME
INPUT_NAME
RULE_ID
EDR_AMERULE_INPUT_VAR_N1 NONUNIQUE APPS_TS_TX_IDX AME_TRANS_ID
Columns
Name Datatype Length Mandatory Comments
AME_TRANS_NAME VARCHAR2 (240) Y Transaction Name
INPUT_NAME VARCHAR2 (80) Y Input Variable Name
RULE_NAME VARCHAR2 (80)
Rule Name
RULE_ID NUMBER (38) Y Rule ID
INPUT_VALUE VARCHAR2 (80)
Input Variable Value
CREATED_BY NUMBER (38) Y Standard Who Column
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (38) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who Column
RULE_CONFIG_ID NUMBER (38)
Rule Configuration ID
AME_TRANS_ID VARCHAR2 (80)
Approval Management Transaction Type Identifier

[top of page]

EDR.EDR_AMERULE_INPUT_VAR does not reference any database object

EDR.EDR_AMERULE_INPUT_VAR is referenced by following:

APPS
SYNONYM - EDR_AMERULE_INPUT_VAR

[top of page]

Table: EDR_AMETRAN_INPUT_VAR

Description: AME Transaction Input Variable Table
Primary Key: EDR_AMETRAN_INPUT_VAR_P
  1. AME_TRANS_NAME
  2. INPUT_NAME
Comments

AME Transaction Input Variable Table

Indexes
Index Type Tablespace Column
EDR_AMETRAN_INPUT_VAR_P UNIQUE APPS_TS_SEED AME_TRANS_NAME
INPUT_NAME
EDR_AMETRAN_INPUT_VAR_N1 NONUNIQUE APPS_TS_SEED AME_TRANS_ID
Columns
Name Datatype Length Mandatory Comments
AME_TRANS_NAME VARCHAR2 (240) Y Transaction Name
AME_TRANS_ID VARCHAR2 (80)
Transaction ID
INPUT_NAME VARCHAR2 (80) Y Input Variable Name
INPUT_DESC VARCHAR2 (240)
Input Variable Description
INPUT_TYPE VARCHAR2 (20)
Input Variable DataType
DEFAULT_VALUE VARCHAR2 (80)
Input Variable Default Value
CREATED_BY NUMBER (38) Y Who Column for Create
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (38) Y Who Column for Last Update
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATE_LOGIN NUMBER (38)
Login ID for Last Update
TRAN_CONFIG_ID NUMBER (38)
Transaction Configuration ID

[top of page]

EDR.EDR_AMETRAN_INPUT_VAR does not reference any database object

EDR.EDR_AMETRAN_INPUT_VAR is referenced by following:

APPS
SYNONYM - EDR_AMETRAN_INPUT_VAR

[top of page]

Table: EDR_COLLATE_PRINT_TEMP

Description: To store the Final Collated PDF to be printed
Primary Key: EDR_COLLATE_PRINT_TEMP_PK
  1. REQUEST_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_COLLATE_PRINT_TEMP_PK UNIQUE APPS_TS_INTERFACE REQUEST_ID
SYS_IL0000324968C00008$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000324968C00009$$ UNIQUE APPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Y Collation Identifier, for print request
CREATION_DATE DATE

Date Print Requested
CREATED_BY NUMBER (15)
Print Requestor
PRINTER_NAME VARCHAR2 (30)
Stores the FND Printer name to which the Request will be spooled
PRINT_STYLE VARCHAR2 (30)
FND Print Style to be used for this print request
NEW_PAGE_NUMBER VARCHAR2 (1)
If Collated PDF should have new page numbers or not
PRINT_STATUS VARCHAR2 (32)
Status of the print request
DRAFT_COLLATED_PDF BLOB (4000)
Draft Collated PDF
FINAL_COLLATED_PDF BLOB (4000)
Final Collated PDF

[top of page]

EDR.EDR_COLLATE_PRINT_TEMP does not reference any database object

EDR.EDR_COLLATE_PRINT_TEMP is referenced by following:

APPS
SYNONYM - EDR_COLLATE_PRINT_TEMP

[top of page]

Table: EDR_ERECORDS

Description: Oracle eRecords
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_ERECORDS_U1 UNIQUE APPS_TS_INTERFACE EVENT_ID
SYS_IL0000240388C00008$$ UNIQUE APPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER

EVENT_NAME VARCHAR2 (80)
EVENT_KEY VARCHAR2 (100)
EVENT_USER_KEY_LABEL VARCHAR2 (240)
EVENT_USER_KEY_VALUE VARCHAR2 (240)
EVENT_TIMESTAMP DATE

EVENT_TIMEZONE VARCHAR2 (240)
ERECORD_XML CLOB (4000)
ERECORD_SIGNATURE_STATUS VARCHAR2 (32)
XML_MAP_NAME VARCHAR2 (240)
AME_TRANSACTION_TYPE VARCHAR2 (240)
AUDIT_GROUP VARCHAR2 (240)
TRANSACTION_AUDIT_ID NUMBER

[top of page]

EDR.EDR_ERECORDS does not reference any database object

EDR.EDR_ERECORDS is referenced by following:

APPS
SYNONYM - EDR_ERECORDS

[top of page]

Table: EDR_ERECORD_ID_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER

[top of page]

EDR.EDR_ERECORD_ID_TEMP does not reference any database object

EDR.EDR_ERECORD_ID_TEMP is referenced by following:

APPS
SYNONYM - EDR_ERECORD_ID_TEMP

[top of page]

Table: EDR_ERESMANAGER_T

Description: Temporary table to hold run time ERES Manager object details
Primary Key: EDR_ERESMANAGER_T_P
  1. ERES_PROCESS_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_ERESMANAGER_T_P UNIQUE APPS_TS_INTERFACE ERES_PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
ERES_PROCESS_ID NUMBER
Y Unique process ID which identifies a given transaction
RETURN_URL VARCHAR2 (4000)
The url to be forwarded after ERES processing
OVERALL_STATUS VARCHAR2 (20)
The overall status of the transaction
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
RETURN_FUNCTION VARCHAR2 (30)
This column would hold the function name to which control would be redirected after ERES processing

[top of page]

EDR.EDR_ERESMANAGER_T does not reference any database object

EDR.EDR_ERESMANAGER_T is referenced by following:

APPS
SYNONYM - EDR_ERESMANAGER_T

[top of page]

Table: EDR_ERESPARAMETERS_T

Description: Table to store user defined parameters for ORES
Primary Key: EDR_ERESPARAMETERS_T_PK
  1. PARAM_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_ERESPARAMETERS_T_PK UNIQUE APPS_TS_INTERFACE PARAM_ID
EDR_ERESPARAMETERS_T_N1 NONUNIQUE APPS_TS_INTERFACE PARENT_ID
PARENT_TYPE
Columns
Name Datatype Length Mandatory Comments
PARAM_ID NUMBER
Y The primary key
PARENT_ID NUMBER
Y The primary key of either EDR_PROCESS_ERECORDS_T or EDR_ERESMANAGER_T.
PARENT_TYPE VARCHAR2 (15)
The parent type, either ERESMANAGER or ERECORD
PARAM_NAME VARCHAR2 (200)
The parameter name
PARAM_VALUE VARCHAR2 (2000)
The parameter value

[top of page]

EDR.EDR_ERESPARAMETERS_T does not reference any database object

EDR.EDR_ERESPARAMETERS_T is referenced by following:

APPS
SYNONYM - EDR_ERESPARAMETERS_T

[top of page]

Table: EDR_ESIGNATURES

Description: Oracle eSignatures
Foreign Keys from this table:
Foreign Key Column Foreign Table
EDR_ESIGNATURES.USER_NAME FND_USER
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_ESIGNATURES_U1 UNIQUE APPS_TS_INTERFACE SIGNATURE_ID
EDR_ESIGNATURES_N1 NONUNIQUE APPS_TS_INTERFACE EVENT_ID
Columns
Name Datatype Length Mandatory Comments
SIGNATURE_ID NUMBER

EVENT_ID NUMBER

EVENT_NAME VARCHAR2 (240)
EVIDENCE_STORE_ID NUMBER

USER_NAME VARCHAR2 (100)
SIGNATURE_SEQUENCE VARCHAR2 (32)
SIGNATURE_TYPE VARCHAR2 (32)
SIGNATURE_TIMESTAMP DATE

SIGNATURE_TIMEZONE VARCHAR2 (240)
SIGNATURE_STATUS VARCHAR2 (32)
SIGNATURE_REASON_CODE VARCHAR2 (32)
SIGNER_COMMENTS VARCHAR2 (4000)
ORIGINAL_RECIPIENT VARCHAR2 (100)
SIGNATURE_OVERRIDING_COMMENTS VARCHAR2 (4000)
ADHOC_STATUS VARCHAR2 (32)
This column is used to identify is the user is a adhoc user. Added Adhoc users will have the value as ADDED. If the default users are deleted then it will have deleted as the value.

[top of page]

EDR.EDR_ESIGNATURES does not reference any database object

EDR.EDR_ESIGNATURES is referenced by following:

APPS
SYNONYM - EDR_ESIGNATURES

[top of page]

Table: EDR_EVENT_RELATIONSHIP

Description: Table to store the relationship between erecords.
Primary Key: EDR_EVENT_RELATIONSHIP_P
  1. RELATIONSHIP_ID
Primary Key: EDR_EVENT_RELATIONSHIP_U
  1. PARENT_ERECORD_ID
  2. CHILD_ERECORD_ID
Comments

Table to store the relationship between erecords.

Indexes
Index Type Tablespace Column
EDR_EVENT_RELATIONSHIP_P UNIQUE APPS_TS_TX_IDX RELATIONSHIP_ID
EDR_EVENT_RELATIONSHIP_U UNIQUE APPS_TS_TX_IDX PARENT_ERECORD_ID
CHILD_ERECORD_ID
Columns
Name Datatype Length Mandatory Comments
RELATIONSHIP_ID NUMBER
Y Surrogate key of the table
PARENT_EVENT_NAME VARCHAR2 (80)
Name of the event for the PARENT erecord
PARENT_EVENT_KEY VARCHAR2 (240)
Event key of PARENT erecord
PARENT_ERECORD_ID NUMBER

erecord ID of the PARENT erecord
CHILD_EVENT_NAME VARCHAR2 (80)
Name of the event for the CHILD erecord
CHILD_EVENT_KEY VARCHAR2 (240)
Event key of CHILD erecord
CHILD_ERECORD_ID NUMBER

erecord ID of the CHILD erecord
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_EVENT_RELATIONSHIP does not reference any database object

EDR.EDR_EVENT_RELATIONSHIP is referenced by following:

APPS
SYNONYM - EDR_EVENT_RELATIONSHIP

[top of page]

Table: EDR_FILES_B

Description: Base table to store the files uploaded using the ERES File Upload System
Primary Key: EDR_FILES_B_P
  1. FILE_ID
Primary Key: EDR_FILES_B_U
  1. FILE_NAME
  2. CATEGORY_ID
Comments

Base table to store the files uploaded using the ERES File Upload System

Indexes
Index Type Tablespace Column
EDR_FILES_B_P UNIQUE APPS_TS_TX_IDX FILE_ID
EDR_FILES_B_U UNIQUE APPS_TS_TX_IDX FILE_NAME
CATEGORY_ID
EDR_FILES_B_N1 NONUNIQUE APPS_TS_TX_IDX STATUS
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER
Y Surrogate key of a file
FILE_NAME VARCHAR2 (300) Y File Name of the file having the appended version number
ORIGINAL_FILE_NAME VARCHAR2 (255) Y File Name of the file as uploaded by the user
VERSION_LABEL VARCHAR2 (15) Y Version label specified by the user
CATEGORY_ID NUMBER
Y Category of the file
CONTENT_TYPE VARCHAR2 (255) Y Content type as specified during the uploading process. This string is an unparsed entity-header for the entity Content-Type
FILE_FORMAT VARCHAR2 (10) Y Format of the file binary/text
STATUS VARCHAR2 (1)
Approval status of the file. Can be Approved, Rejected, etc.
VERSION_NUMBER NUMBER
Y Internal version number, this is a running number
FND_DOCUMENT_ID NUMBER

Document id in the fnd scehma corresponding to this file
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category for the descriptive flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_FILES_B does not reference any database object

EDR.EDR_FILES_B is referenced by following:

APPS
SYNONYM - EDR_FILES_B

[top of page]

Table: EDR_FILES_TL

Description: Translation table to store the files uploaded using the ERES File Upload System
Primary Key: EDR_FILES_TL_P
  1. FILE_ID
  2. LANGUAGE
Comments

Translation table to store the files uploaded using the ERES File Upload System

Indexes
Index Type Tablespace Column
EDR_FILES_TL_P UNIQUE APPS_TS_TX_IDX FILE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER
Y File Id of a file, part of composite primary key
LANGUAGE VARCHAR2 (4) Y Language of user display
SOURCE_LANG VARCHAR2 (4)
Source language for display name
DESCRIPTION VARCHAR2 (255)
Description of the file
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_FILES_TL does not reference any database object

EDR.EDR_FILES_TL is referenced by following:

APPS
SYNONYM - EDR_FILES_TL

[top of page]

Table: EDR_FWK_TEST_B

Description: This table is to support ERES Framework Testing in new environments. This is not a functional Table.
Primary Key: EDR_FWK_TEST_B_P
  1. FWK_TEST_ID
Comments

This table is to support ERES Framework Testing in new environments. This is not a functional Table.

Indexes
Index Type Tablespace Column
EDR_FWK_TEST_B_P UNIQUE APPS_TS_TX_IDX FWK_TEST_ID
EDR_FWK_TEST_B_U1 UNIQUE APPS_TS_TX_IDX FWK_TEST_NO
Columns
Name Datatype Length Mandatory Comments
FWK_TEST_ID NUMBER (10) Y Primary Key for ERES Framework Test Table
FWK_TEST_NO VARCHAR2 (32)
ERES Framework Test Number
NUMBER_VALUE NUMBER

Numeric Input field
DATE_VALUE DATE

Date Input field
STATUS VARCHAR2 (32)
Current Record ERES Status
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category for the descriptive flexfield
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

EDR.EDR_FWK_TEST_B does not reference any database object

EDR.EDR_FWK_TEST_B is referenced by following:

APPS
SYNONYM - EDR_FWK_TEST_B

[top of page]

Table: EDR_FWK_TEST_TL

Description: Translation table to store the ERES Framework Test data
Comments

Translation table to store the ERES Framework Test data

Indexes
Index Type Tablespace Column
EDR_FWK_TEST_TL_PK UNIQUE APPS_TS_TX_IDX FWK_TEST_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
FWK_TEST_ID NUMBER (10)
Reference Key for ERES Framework Test Table
FWK_TEST_DESCRIPTION VARCHAR2 (100)
Description
LANGUAGE VARCHAR2 (4) Y Language of user display
SOURCE_LANG VARCHAR2 (4) Y Source language for display name
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

EDR.EDR_FWK_TEST_TL does not reference any database object

EDR.EDR_FWK_TEST_TL is referenced by following:

APPS
SYNONYM - EDR_FWK_TEST_TL

[top of page]

Table: EDR_IDX_XML_ELEMENT_B

Description: eRecord indexed xml element base table for storing indexed xml elements
Primary Key: EDR_IDX_XML_ELEMENT_B_P
  1. ELEMENT_ID
Primary Key: EDR_IDX_XML_ELEMENT_B_U
  1. INDEX_TAG
Comments

eRecord indexed xml element base table for storing indexed xml elements

Indexes
Index Type Tablespace Column
EDR_IDX_XML_ELEMENT_B_P UNIQUE APPS_TS_TX_IDX ELEMENT_ID
EDR_IDX_XML_ELEMENT_B_U UNIQUE APPS_TS_TX_IDX INDEX_TAG
EDR_IDX_XML_ELEMENT_B_N1 NONUNIQUE APPS_TS_TX_IDX STATUS
Columns
Name Datatype Length Mandatory Comments
ELEMENT_ID NUMBER
Y Surrogate key of indexed xml element
XML_ELEMENT VARCHAR2 (30) Y XML Element name for indexed xml element
DTD_ROOT_ELEMENT VARCHAR2 (30)
Root element of the DTD specific for the indexed xml element
APPLICATION_ID NUMBER
Y Application ID of the application owning the indexed xml element
INDEX_SECTION_NAME VARCHAR2 (30) Y Index section name for indexed xml element
INDEX_TAG VARCHAR2 (64) Y XML tag used in indexing
STATUS VARCHAR2 (1) Y Status of the indexed xml element
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_IDX_XML_ELEMENT_B does not reference any database object

EDR.EDR_IDX_XML_ELEMENT_B is referenced by following:

APPS
SYNONYM - EDR_IDX_XML_ELEMENT_B

[top of page]

Table: EDR_IDX_XML_ELEMENT_TL

Description: E-Record indexed xml element translation table
Primary Key: EDR_IDX_XML_ELEMENT_TL_P
  1. ELEMENT_ID
  2. LANGUAGE
Comments

E-Record indexed xml element translation table

Indexes
Index Type Tablespace Column
EDR_IDX_XML_ELEMENT_TL_P UNIQUE APPS_TS_TX_IDX ELEMENT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ELEMENT_ID NUMBER
Y Surrogate key
LANGUAGE VARCHAR2 (4) Y Language of user display
SOURCE_LANG VARCHAR2 (4)
Source language for display name
DISPLAY_NAME VARCHAR2 (100) Y User display name of indexed xml element
DESCRIPTION VARCHAR2 (100)
Description of indexed xml element
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_IDX_XML_ELEMENT_TL does not reference any database object

EDR.EDR_IDX_XML_ELEMENT_TL is referenced by following:

APPS
SYNONYM - EDR_IDX_XML_ELEMENT_TL

[top of page]

Table: EDR_IDX_XML_ELEMENT_USAGES

Description: E-Record indexed xml element usage table
Primary Key: EDR_IDX_XML_ELEMENT_USAGES_P
  1. USAGE_ID
Comments

E-Record indexed xml element usage table

Indexes
Index Type Tablespace Column
EDR_IDX_XML_ELEMENT_USAGES_P UNIQUE APPS_TS_TX_IDX USAGE_ID
Columns
Name Datatype Length Mandatory Comments
USAGE_ID NUMBER
Y Surrogate key
ELEMENT_ID NUMBER
Y Element Id of the indexed xml element
ELEMENT_USAGE VARCHAR2 (1) Y Usage code of the indexed xml element
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_IDX_XML_ELEMENT_USAGES does not reference any database object

EDR.EDR_IDX_XML_ELEMENT_USAGES is referenced by following:

APPS
SYNONYM - EDR_IDX_XML_ELEMENT_USAGES

[top of page]

Table: EDR_INTER_EVENT_TEST_EVENTS

Description: EDR_INTER_EVENT_TEST_EVENTS is to store information about Events to be raised in a test scenario instance. This is detail table for EDR_INTER_EVENT_TEST_SCENARIOS Table.
Primary Key: EDR_INTER_EVENT_TEST_EVENTS_P
  1. INTER_EVENT_TEST_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_INTER_EVENT_TEST_EVENTS_P UNIQUE APPS_TS_TX_IDX INTER_EVENT_TEST_ID
Columns
Name Datatype Length Mandatory Comments
INTER_EVENT_TEST_ID NUMBER
Y Primary Key for ERES Inter Event Test Table
TEST_SCENARIO_ID NUMBER

Test Scenario Identifier. Foreign Key to EDR_INTER_EVENT_TEST_SCENATIOS.
EVENT_NAME VARCHAR2 (240)
Business Event being Raised
EVENT_RAISE_TYPE VARCHAR2 (1)
This provides information how to queue an event in a scenario for processing. Allowed values are C for Raise Separate and T for Raise with other events.
EVENT_RAISE_MODE VARCHAR2 (8)
This provides information how to process an event. Allowed values are DB for total offline, N for Online only, Y for Deferred allowed.
EVENT_EXECUTION_ORDER NUMBER

This provides order in which event need to be queued for processing.
RELATED_EVENT_NAME VARCHAR2 (240)
Related Event to Business Event Raised
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category for the descriptive flexfield
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment

[top of page]

EDR.EDR_INTER_EVENT_TEST_EVENTS does not reference any database object

EDR.EDR_INTER_EVENT_TEST_EVENTS is referenced by following:

APPS
SYNONYM - EDR_INTER_EVENT_TEST_EVENTS

[top of page]

Table: EDR_INTER_EVENT_TEST_SCENARIOS

Description: EDR_INTER_EVENT_TEST_SCENATIOS is to store information about Test scenario instances created using Inter Event Verification form. There is a flag to indicate ERES Signature Requested or not for current test scenario instance.
Primary Key: EDR_INTEREVENT_TEST_SCENARIO_P
  1. TEST_SCENARIO_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_INTEREVENT_TEST_SCENARIO_P UNIQUE APPS_TS_TX_IDX TEST_SCENARIO_ID
EDR_INTEREVENT_TST_SCENARIO_U1 UNIQUE APPS_TS_TX_IDX TEST_SCENARIO
TEST_SCENARIO_INSTANCE
Columns
Name Datatype Length Mandatory Comments
TEST_SCENARIO_ID NUMBER
Y Primary Key for ERES Inter Event Test scenario Table
TEST_SCENARIO VARCHAR2 (40)
Test Scenario. This is part of User Key to Identify a test scenario performed to test Inter event functionality. This is used to identify an event set setup.
TEST_SCENARIO_INSTANCE VARCHAR2 (40)
Test Scenario Instance. This in conjunction with Test scenario is unique. This can be used as a user Identifier for variations in a test scenario.
ERES_REQUESTED_FLAG VARCHAR2 (1)
This indicates ERES is requested or not. This can have Y to indicated ERES Requested and N to indicate ERES is not initiated. If this value is Y then no changes are allowed for event set.
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
TEST_SCENARIO_TYPE VARCHAR2 (10)
Inter Event Test Scenario Type

[top of page]

EDR.EDR_INTER_EVENT_TEST_SCENARIOS does not reference any database object

EDR.EDR_INTER_EVENT_TEST_SCENARIOS is referenced by following:

APPS
SYNONYM - EDR_INTER_EVENT_TEST_SCENARIOS

[top of page]

Table: EDR_PREPARE_DOCUMENT_TEMP

Description: To Store transient PDF of individual E-Records selected for printing
Primary Key: EDR_PREPARE_DOCUMENT_TEMP_PK
  1. DOCUMENT_ID
  2. REQUEST_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_PREPARE_DOCUMENT_TEMP_PK UNIQUE APPS_TS_INTERFACE DOCUMENT_ID
REQUEST_ID
SYS_IL0000324985C00003$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000324985C00004$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000324985C00005$$ UNIQUE APPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Y E-Record Id
REQUEST_ID NUMBER
Y Collation Identifier, Same for a set of Documents belonging to same print request
ERECORD_SUMMARY_PDF BLOB (4000)
E-Record summary data (Signature and Event details) in PDF format
ERECORD_PDF BLOB (4000)
E-Record in PDF format
TRANSIENT_PDF BLOB (4000)
Final Transient PDF Document of E-Record, produced in merge process, and used during collate process

[top of page]

EDR.EDR_PREPARE_DOCUMENT_TEMP does not reference any database object

EDR.EDR_PREPARE_DOCUMENT_TEMP is referenced by following:

APPS
SYNONYM - EDR_PREPARE_DOCUMENT_TEMP

[top of page]

Table: EDR_PROCESS_ERECORDS_T

Description: Temporary table to hold the run time erecord object data
Primary Key: EDR_PROCESS_ERECORDS_T_P
  1. ERECORD_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EDR_PROCESS_ERECORDS_T.REQUESTER FND_USER
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_PROCESS_ERECORDS_T_P UNIQUE APPS_TS_INTERFACE ERECORD_SEQUENCE_ID
SYS_IL0000396569C00005$$ UNIQUE APPS_TS_INTERFACE
EDR_PROCESS_ERECORDS_T_N1 NONUNIQUE APPS_TS_INTERFACE ERES_PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
ERECORD_SEQUENCE_ID NUMBER
Y Primary Key which identifies a specific row
ERES_PROCESS_ID NUMBER

The process ID which identified the transaction
TRANSACTION_NAME VARCHAR2 (80)
The transaction name of the e-record
TRANSACTION_KEY VARCHAR2 (240)
The transaction key of the e-record
PAYLOAD CLOB (4000)
The runtime transaction data
REQUESTER VARCHAR2 (100)
The user requesting the transaction
DEFERRED_MODE VARCHAR2 (1)
Specifies whether deferred mode is allowed
POST_OP_API VARCHAR2 (240)
The post operation API to be executed after ERES processing in case of deferred transactions
USER_KEY_LABEL VARCHAR2 (240)
The user key label
USER_KEY_VALUE VARCHAR2 (240)
The user key value
TRANSACTION_AUDIT_ID NUMBER

The transaction sudit id
STATUS VARCHAR2 (32)
The e-record approval status
ERECORD_ID NUMBER

The e-record ID as stored in evidence store
PARENT_NAME VARCHAR2 (80)
The parent event name of the e-record
PARENT_KEY VARCHAR2 (240)
The parent key of the e-record
PARENT_ERECORD_ID NUMBER

The parent e-record ID
CHILD_ERECORD_IDS VARCHAR2 (100)
Comma separated values of child e-record IDs
WF_ITEM_TYPE VARCHAR2 (30)
The workflow item type
WF_ITEM_KEY VARCHAR2 (30)
The workflow item key
WF_PROCESS VARCHAR2 (30)
The workflow process
SOURCE_APPLICATION VARCHAR2 (15)
The source application type from which ERES is triggered
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column

[top of page]

EDR.EDR_PROCESS_ERECORDS_T does not reference any database object

EDR.EDR_PROCESS_ERECORDS_T is referenced by following:

APPS
SYNONYM - EDR_PROCESS_ERECORDS_T

[top of page]

Table: EDR_PSIG_DETAILS

Description: Electronic signature document details
Foreign Keys from this table:
Foreign Key Column Foreign Table
EDR_PSIG_DETAILS.USER_NAME FND_USER
Comments

Electronic signature document details

Indexes
Index Type Tablespace Column
EDR_PSIG_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX USER_NAME
Columns
Name Datatype Length Mandatory Comments
SIGNATURE_ID NUMBER

Singnature ID
DOCUMENT_ID NUMBER

Document Id Refers EDR_PSIG_DOCUMENTS
EVIDENCE_STORE_ID NUMBER

Evidence Store Id if the signature are present in Server Tech Storage
USER_NAME VARCHAR2 (100)
User Name who Signed the Document
USER_RESPONSE VARCHAR2 (100)
User Repsonse
SIGNATURE_TIMESTAMP DATE

Singed Time and date
SIGNATURE_TIMEZONE VARCHAR2 (240)
Signature Time Zone
SIGNATURE_STATUS VARCHAR2 (32)
Signature Status (PENDING,COMPLETE,ERROR)
CREATION_DATE DATE

WHO Columns
CREATED_BY NUMBER

WHO Column
LAST_UPDATE_DATE DATE

WHO Column
LAST_UPDATED_BY NUMBER

WHO Column
LAST_UPDATE_LOGIN NUMBER

WHO COlumn
ORIGINAL_RECIPIENT VARCHAR2 (100)
Original recipient of the eSignature
SIGNATURE_OVERRIDING_COMMENTS VARCHAR2 (4000)
Details of Routing information from original recipient to current recipient
ADHOC_STATUS VARCHAR2 (32)
Identify the adhoc status of the user. Default values are Add and Delete.
SIGNATURE_SEQUENCE NUMBER

Identify the signature sequence for the user
ORIG_SYSTEM VARCHAR2 (240)
Originating User System Name
ORIG_SYSTEM_ID NUMBER

Originating User System ID
USER_DISPLAY_NAME VARCHAR2 (360)
The User Display Name

[top of page]

EDR.EDR_PSIG_DETAILS does not reference any database object

EDR.EDR_PSIG_DETAILS is referenced by following:

APPS
SYNONYM - EDR_PSIG_DETAILS

[top of page]

Table: EDR_PSIG_DOCUMENTS

Description: Electronic Signature Document store
Primary Key: EDR_PSIG_DOCUMENTS_P
  1. DOCUMENT_ID
Comments

Electronic Signature Document store

Indexes
Index Type Tablespace Column
EDR_PSIG_DOCUMENTS_P UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
SYS_IL0000240378C00002$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000240378C00003$$ UNIQUE APPS_TS_TX_DATA
EDR_PSIG_DOCUMENTS_N1 NONUNIQUE APPS_TS_TX_IDX EVENT_NAME
EVENT_KEY
EDR_PSIG_DOCUMENTS_N2 NONUNIQUE APPS_TS_TX_IDX PSIG_TIMESTAMP
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Y Unique document id
PSIG_XML CLOB (4000)
XML document
PSIG_DOCUMENT CLOB (4000)
electronic record as seen by user
PSIG_DOCUMENTFORMAT VARCHAR2 (100)
Format of the Document
PSIG_TIMESTAMP DATE

Timestamp when the document was requested
PSIG_TIMEZONE VARCHAR2 (240)
Time Zone the document was initiated
DOCUMENT_REQUESTER VARCHAR2 (240)
Document requester
PSIG_STATUS VARCHAR2 (32)
Status of the document ERROR,PENDING,COMPLETE
PSIG_SOURCE VARCHAR2 (32)
Source of the Document
EVENT_NAME VARCHAR2 (80)
Event associated to the document
EVENT_KEY VARCHAR2 (240)
Event instance identifier
PRINT_COUNT NUMBER

Number of time document requested from printing
CREATION_DATE DATE

WHO Column
CREATED_BY NUMBER

WHO Column
LAST_UPDATE_DATE DATE

WHO Column
LAST_UPDATED_BY NUMBER

WHO Column
LAST_UPDATE_LOGIN NUMBER

WHO Column
DOC_REQ_DISP_NAME VARCHAR2 (360)
This column stores the document requesters display name as stored in WF directory at the time of creation of e-record

[top of page]

EDR.EDR_PSIG_DOCUMENTS does not reference any database object

EDR.EDR_PSIG_DOCUMENTS is referenced by following:

APPS
SYNONYM - EDR_PSIG_DOCUMENTS

[top of page]

Table: EDR_PSIG_DOC_PARAMS_B

Description: Electronic Signature Document Attributes
Primary Key: EDR_PSIG_DOC_PARAMS_B_P
  1. PARAMETER_ID
Comments

Electronic Signature Document Attributes

Indexes
Index Type Tablespace Column
EDR_PSIG_DOC_PARAMS_B_N1 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_ID
NAME
EDR_PSIG_DOC_PARAMS_B_P NONUNIQUE APPS_TS_TX_IDX PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Y Primary key for this Table
DOCUMENT_ID NUMBER

Docuemnt id of the parameters
NAME VARCHAR2 (100)
Name of the parameter
VALUE VARCHAR2 (4000)
Value of the parameter
CREATION_DATE DATE

Who Column
CREATED_BY NUMBER

Who Column
LAST_UPDATE_DATE DATE

Who Column
LAST_UPDATED_BY NUMBER

Who Column
LAST_UPDATE_LOGIN NUMBER

Who Column

[top of page]

EDR.EDR_PSIG_DOC_PARAMS_B does not reference any database object

EDR.EDR_PSIG_DOC_PARAMS_B is referenced by following:

APPS
SYNONYM - EDR_PSIG_DOC_PARAMS_B

[top of page]

Table: EDR_PSIG_DOC_PARAMS_TL

Description: Translation Table for document parameter
Comments

Translation Table for document parameter

Indexes
Index Type Tablespace Column
EDR_PSIG_DOC_PARAMS_TL_N1 NONUNIQUE APPS_TS_TX_IDX PARAMETER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER

Primary Key
LANGUAGE VARCHAR2 (4)
Application installed Language
SOURCE_LANG VARCHAR2 (4)
Application Source Language
DISPLAY_NAME VARCHAR2 (240)
Display name of the parameter
CREATION_DATE DATE

WHO Column
CREATED_BY NUMBER

WHO Column
LAST_UPDATE_DATE DATE

WHO Column
LAST_UPDATED_BY NUMBER

WHO Column
LAST_UPDATE_LOGIN NUMBER

WHO Column

[top of page]

EDR.EDR_PSIG_DOC_PARAMS_TL does not reference any database object

EDR.EDR_PSIG_DOC_PARAMS_TL is referenced by following:

APPS
SYNONYM - EDR_PSIG_DOC_PARAMS_TL

[top of page]

Table: EDR_PSIG_PRINT_HISTORY

Description: Maintain print history for a e-record
Primary Key: EDR_PSIG_PRINT_HISTORY_PK
  1. DOCUMENT_ID
  2. PRINT_COUNT
Comments

Maintain print history for a e-record

Indexes
Index Type Tablespace Column
EDR_PSIG_PRINT_HISTORY_PK UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
PRINT_COUNT
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Y Document Id to be printed
PRINT_DOCUMENT_ID NUMBER

Document ID of the print e-record
PRINT_COUNT NUMBER
Y Print Count
PRINT_REQUESTED_BY VARCHAR2 (240)
Print requested by
PRINT_REQUESTED_DATE DATE

Print requested date
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
ORIG_SYSTEM VARCHAR2 (240)
Originating User System Name
ORIG_SYSTEM_ID NUMBER

Originating User System ID
USER_DISPLAY_NAME VARCHAR2 (360)
The User Display Name

[top of page]

EDR.EDR_PSIG_PRINT_HISTORY does not reference any database object

EDR.EDR_PSIG_PRINT_HISTORY is referenced by following:

APPS
SYNONYM - EDR_PSIG_PRINT_HISTORY

[top of page]

Table: EDR_PSIG_SIGN_PARAMS_B

Description: Electronic Signature Signature Attributes
Primary Key: EDR_PSIG_SIGN_PARAMS_B_P
  1. PARAMETER_ID
Comments

Electronic Signature Signature Attributes

Indexes
Index Type Tablespace Column
EDR_PSIG_SIGN_PARAMS_B_N1 NONUNIQUE APPS_TS_TX_IDX SIGNATURE_ID
NAME
EDR_PSIG_SIGN_PARAMS_B_P NONUNIQUE APPS_TS_TX_IDX PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Y Primary key for this Table
SIGNATURE_ID NUMBER

Docuemnt id of the parameters
NAME VARCHAR2 (100)
Name of the parameter
VALUE VARCHAR2 (4000)
Value of the parameter
CREATION_DATE DATE

Who Column
CREATED_BY NUMBER

Who Column
LAST_UPDATE_DATE DATE

Who Column
LAST_UPDATED_BY NUMBER

Who Column
LAST_UPDATE_LOGIN NUMBER

Who Column

[top of page]

EDR.EDR_PSIG_SIGN_PARAMS_B does not reference any database object

EDR.EDR_PSIG_SIGN_PARAMS_B is referenced by following:

APPS
SYNONYM - EDR_PSIG_SIGN_PARAMS_B

[top of page]

Table: EDR_PSIG_SIGN_PARAMS_TL

Description: Translation Table for Signature parameter
Comments

Translation Table for Signature parameter

Indexes
Index Type Tablespace Column
EDR_PSIG_SIGN_PARAMS_TL_N1 NONUNIQUE APPS_TS_TX_IDX PARAMETER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER

Primary Key
LANGUAGE VARCHAR2 (4)
Application installed Language
SOURCE_LANG VARCHAR2 (4)
Application Source Language
DISPLAY_NAME VARCHAR2 (240)
Display name of the parameter
CREATION_DATE DATE

WHO Column
CREATED_BY NUMBER

WHO Column
LAST_UPDATE_DATE DATE

WHO Column
LAST_UPDATED_BY NUMBER

WHO Column
LAST_UPDATE_LOGIN NUMBER

WHO Column

[top of page]

EDR.EDR_PSIG_SIGN_PARAMS_TL does not reference any database object

EDR.EDR_PSIG_SIGN_PARAMS_TL is referenced by following:

APPS
SYNONYM - EDR_PSIG_SIGN_PARAMS_TL

[top of page]

Table: EDR_RAW_XML_T

Description:
Primary Key: EDR_RAW_XML_T_P
  1. EVENT_NAME
  2. EVENT_KEY
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_RAW_XML_T_P UNIQUE APPS_TS_INTERFACE EVENT_NAME
EVENT_KEY
SYS_IL0000396575C00003$$ UNIQUE APPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
EVENT_NAME VARCHAR2 (80) Y
EVENT_KEY VARCHAR2 (240) Y
RAW_XML CLOB (4000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

EDR.EDR_RAW_XML_T does not reference any database object

EDR.EDR_RAW_XML_T is referenced by following:

APPS
SYNONYM - EDR_RAW_XML_T

[top of page]

Table: EDR_REDLINE_TRANS_DATA

Description: EDR Redlining temporary table
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
SYS_IL0000396590C00002$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000396590C00003$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000396590C00006$$ UNIQUE APPS_TS_INTERFACE
SYS_IL0000396590C00007$$ UNIQUE APPS_TS_INTERFACE
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (22) Y EVENT ID of the Current Transaction
PRE_XML_DATA CLOB (4000)
Pre Transaction XML Data
POST_XML_DATA CLOB (4000)
Current Transaction XML Data
ERR_CODE NUMBER (22)
Error Code generated during Ecx API Call
ERR_MSG VARCHAR2 (2000)
Error Message generated during Ecx API Call
DIFF_XML CLOB (4000)
Difference between Pre and post Current Transaction XML Data
APPENDIX_GEN_XML CLOB (4000)
Generic XML derived from DIFF_XML for Appendix Section in E Record pdf

[top of page]

EDR.EDR_REDLINE_TRANS_DATA does not reference any database object

EDR.EDR_REDLINE_TRANS_DATA is referenced by following:

APPS
SYNONYM - EDR_REDLINE_TRANS_DATA

[top of page]

Table: EDR_RULE_CONDITION_TEMP

Description: EDR temp table in ERES support for input variable eRecord showing rule conditions
Primary Key: EDR_RULE_CONDITION_TEMP_PK
  1. SESSION_ID
  2. TRANSACTION_TYPE_ID
  3. RULE_ID
  4. CONDITION_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Session ID
TRANSACTION_TYPE_ID VARCHAR2 (100) Y Transaction type ID
RULE_ID NUMBER
Y Rule ID
CONDITION_ID NUMBER
Y Condition ID
CONDITION_DESC VARCHAR2 (4000)
Condition description

[top of page]

EDR.EDR_RULE_CONDITION_TEMP does not reference any database object

EDR.EDR_RULE_CONDITION_TEMP is referenced by following:

APPS
SYNONYM - EDR_RULE_CONDITION_TEMP

[top of page]

Table: EDR_RULE_DETAIL_TEMP

Description: EDR temp table in ERES support for input variable eRecord showing rule detail info
Primary Key: EDR_RULE_DETAIL_TEMP_PK
  1. SESSION_ID
  2. TRANSACTION_TYPE_ID
  3. RULE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y current sql session id
TRANSACTION_TYPE_ID VARCHAR2 (100) Y current transaction type id
RULE_ID NUMBER
Y current rule id for a rule under the transaction
RULE_NAME VARCHAR2 (100)
rule name for rule id
RULE_TYPE VARCHAR2 (100)
rule type for rule id
APPR_TYPE VARCHAR2 (100)
rule approval type
APPR_DESC VARCHAR2 (100)
rule approval description
DEFAULT_VAR VARCHAR2 (1)
whether this rule use default value of the transaction variable
START_DATE DATE
Y rule effective start date
END_DATE DATE

rule effective end date

[top of page]

EDR.EDR_RULE_DETAIL_TEMP does not reference any database object

EDR.EDR_RULE_DETAIL_TEMP is referenced by following:

APPS
SYNONYM - EDR_RULE_DETAIL_TEMP

[top of page]

Table: EDR_SECURITY_RULES

Description: E-Record security rule table for storing the security rules used by VPD
Primary Key: EDR_SECURITY_RULES_P
  1. RULE_ID
Comments

E-Record security rule table for storing the security rules used by VPD

Indexes
Index Type Tablespace Column
EDR_SECURITY_RULES_P UNIQUE APPS_TS_TX_IDX RULE_ID
EDR_SECURITY_RULES_N1 NONUNIQUE APPS_TS_TX_IDX ACCESS_CODE
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Y Surrogate Key
ELEMENT_ID NUMBER
Y Element Id of the indexed xml element
EVENT_NAME VARCHAR2 (240)
Internal event Name of the ERES event
SECURE_VALUE VARCHAR2 (100) Y Secured value for the element
USER_ID NUMBER (15)
User ID of the actor for the rule
RESPONSIBILITY_ID NUMBER (15)
Responsibility ID of the actor for the rule
ACCESS_CODE VARCHAR2 (1) Y Access Code for the rule
START_DATE DATE
Y Start date of the security rule
END_DATE DATE

End date of the security rule
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_SECURITY_RULES does not reference any database object

EDR.EDR_SECURITY_RULES is referenced by following:

APPS
SYNONYM - EDR_SECURITY_RULES

[top of page]

Table: EDR_TRANS_ACKN

Description: Table to store the transaction acknowledgement for erecords
Primary Key: EDR_TRANS_ACKN_P
  1. ACKN_ID
Primary Key: EDR_TRANS_ACKN_U
  1. ERECORD_ID
  2. TRANSACTION_STATUS
Comments

Table to store the transaction acknowledgement for erecords

Indexes
Index Type Tablespace Column
EDR_TRANS_ACKN_P UNIQUE APPS_TS_TX_IDX ACKN_ID
EDR_TRANS_ACKN_U UNIQUE APPS_TS_TX_IDX ERECORD_ID
TRANSACTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ACKN_ID NUMBER
Y Surrogate key of the table
ERECORD_ID NUMBER
Y eRecord ID of the eRecord for which acknowledgement is created
ACKN_DATE DATE
Y Date on which acknowledgement is recorded
TRANSACTION_STATUS VARCHAR2 (30) Y Status of the transaction for which eREcord is created
ACKN_BY VARCHAR2 (200)
Details of the source from where the acknowledgement is received
ACKN_NOTE VARCHAR2 (2000)
General notes (comments) about the acknowledgement providing more information
CREATED_BY NUMBER (15) Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

EDR.EDR_TRANS_ACKN does not reference any database object

EDR.EDR_TRANS_ACKN is referenced by following:

APPS
SYNONYM - EDR_TRANS_ACKN

[top of page]

Table: EDR_TRANS_QUERY_TEMP

Description: eRecords Reports Temporary Table
Primary Key: EDR_TRANS_QUERY_TEMP_P
  1. QUERY_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EDR_TRANS_QUERY_TEMP_P NONUNIQUE APPS_TS_INTERFACE QUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y Query ID
DOCUMENT_ID NUMBER

Document ID
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
PRINT_FLAG VARCHAR2 (1)
Print flag

[top of page]

EDR.EDR_TRANS_QUERY_TEMP does not reference any database object

EDR.EDR_TRANS_QUERY_TEMP is referenced by following:

APPS
SYNONYM - EDR_TRANS_QUERY_TEMP

[top of page]

View: EDR_FILES_LATEST_VERSION_V

Comments
View Type

MultiLingual view (a language resolved view of the data.)

The latest version of the files in the File Upload System

Columns
Name Datatype Length Mandatory Comments
ORIGINAL_FILE_NAME VARCHAR2 (255)
Original file name of the file
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Category Name of the File
VERSION_NUMBER NUMBER

Latest Version Number of the file
COUNT NUMBER

Number of versions of the file

[top of page]

APPS.EDR_FILES_LATEST_VERSION_V references the following:

APPS
VIEW - EDR_FILES_VL

APPS.EDR_FILES_LATEST_VERSION_V is not referenced by any database object

[top of page]

View: EDR_FILES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

MLS view to store the files uploaded using the ERES File Upload System

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id for the view row
FILE_ID NUMBER
Y Surrogate key of a file
FILE_NAME VARCHAR2 (300) Y File Name of the file having the appended version number
ORIGINAL_FILE_NAME VARCHAR2 (255) Y File Name of the file as uploaded by the user
VERSION_LABEL VARCHAR2 (15) Y Version label specified by the user
CATEGORY_ID NUMBER
Y Category of the file
CONTENT_TYPE VARCHAR2 (255) Y Content type as specified during the uploading process. This string is an unparsed entity-header for the entity Content-Type
FILE_FORMAT VARCHAR2 (10) Y Format of the file binary/text
STATUS VARCHAR2 (1)
Approval status of the file. Can be Approved, Rejected, etc.
VERSION_NUMBER NUMBER
Y Internal version number, this is a running number
FND_DOCUMENT_ID NUMBER

Document id in the fnd scehma corresponding to this file
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category for the descriptive flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DESCRIPTION VARCHAR2 (255)
Description of the file
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

APPS.EDR_FILES_VL references the following:

APPS
SYNONYM - EDR_FILES_B
SYNONYM - EDR_FILES_TL
APPS.EDR_FILES_VL is referenced by following:

APPS
PACKAGE BODY - EDR_ATTACHMENTS_GRP
VIEW - EDR_FILES_LATEST_VERSION_V
PACKAGE BODY - EDR_FILE_UTIL_PUB

[top of page]

View: EDR_FWK_TEST_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

MLS view for ERES Framework Testing table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FWK_TEST_ID NUMBER (10) Y Primary Key for ERES Framework Test Table
FWK_TEST_NO VARCHAR2 (32)
ERES Framework Test Number
NUMBER_VALUE NUMBER

Numeric Input field
DATE_VALUE DATE

Date Input field
STATUS VARCHAR2 (32)
Current Record ERES Status
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE21 VARCHAR2 (240)
ATTRIBUTE22 VARCHAR2 (240)
ATTRIBUTE23 VARCHAR2 (240)
ATTRIBUTE24 VARCHAR2 (240)
ATTRIBUTE25 VARCHAR2 (240)
ATTRIBUTE26 VARCHAR2 (240)
ATTRIBUTE27 VARCHAR2 (240)
ATTRIBUTE28 VARCHAR2 (240)
ATTRIBUTE29 VARCHAR2 (240)
ATTRIBUTE30 VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category for the descriptive flexfield
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
FWK_TEST_DESCRIPTION VARCHAR2 (100)
Description

[top of page]

APPS.EDR_FWK_TEST_VL references the following:

APPS
SYNONYM - EDR_FWK_TEST_B
SYNONYM - EDR_FWK_TEST_TL
APPS.EDR_FWK_TEST_VL is referenced by following:

APPS
TRIGGER - EDR_FWK_TEST_DL
TRIGGER - EDR_FWK_TEST_IL
TRIGGER - EDR_FWK_TEST_UL
PACKAGE BODY - EDR_FWK_VERIFY

[top of page]

View: EDR_IDX_XML_ELEMENT_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

E-Record indexed xml element MLS view

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ELEMENT_ID NUMBER
Y Element Id of the indexed xml element
XML_ELEMENT VARCHAR2 (30) Y XML Element name for indexed xml element
DTD_ROOT_ELEMENT VARCHAR2 (30)
Root element of the DTD specific for the indexed xml element
APPLICATION_ID NUMBER
Y Application ID of the application owning the indexed xml element
INDEX_SECTION_NAME VARCHAR2 (30) Y Index section name for indexed xml element
INDEX_TAG VARCHAR2 (64) Y XML tag used in indexing
STATUS VARCHAR2 (1) Y Status of the indexed xml element
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
DISPLAY_NAME VARCHAR2 (100) Y User display name of indexed xml element
DESCRIPTION VARCHAR2 (100)
Description of indexed xml element

[top of page]

APPS.EDR_IDX_XML_ELEMENT_VL references the following:

APPS
SYNONYM - EDR_IDX_XML_ELEMENT_B
SYNONYM - EDR_IDX_XML_ELEMENT_TL
APPS.EDR_IDX_XML_ELEMENT_VL is referenced by following:

APPS
PACKAGE BODY - EDR_IDX_XML_ELEMENT_PKG
PACKAGE BODY - EDR_INDEXED_XML_UTIL
VIEW - EDR_SECURE_ELEMENTS_V

[top of page]

View: EDR_INTER_EVENT_TEST_EVENTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TEST_SCENARIO_ID NUMBER
Y Primary Key for ERES Inter Event Test scenario Table
TEST_SCENARIO VARCHAR2 (40)
Test Scenario. This is part of User Key to Identify a test scenario performed to test Inter event functionality. This is used to identify an event set setup.
TEST_SCENARIO_INSTANCE VARCHAR2 (40)
Test Scenario Instance. This in conjunction with Test scenario is unique. This can be used as a user Identifier for variations in a test scenario.
INTER_EVENT_TEST_ID NUMBER
Y Primary Key for ERES Inter Event Test Table
EVENT_NAME VARCHAR2 (240)
Business Event being Raised
EVENT_DISPLAY_NAME VARCHAR2 (80) Y Event Display name
EVENT_RAISE_TYPE VARCHAR2 (1)
Event Raise Type
EVENT_RAISE_MODE VARCHAR2 (8)
Event Raise Mode
EVENT_EXECUTION_ORDER NUMBER

Order
RELATED_EVENT_NAME VARCHAR2 (240)
Related Event Name
RELATED_EVENT_DISPLAY_NAME VARCHAR2 (80)
Related Event Display Name
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flex attribute Category
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flex attributes
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flex attributes

[top of page]

APPS.EDR_INTER_EVENT_TEST_EVENTS_V references the following:

APPS
SYNONYM - EDR_INTER_EVENT_TEST_EVENTS
SYNONYM - EDR_INTER_EVENT_TEST_SCENARIOS
VIEW - WF_EVENTS_VL

APPS.EDR_INTER_EVENT_TEST_EVENTS_V is not referenced by any database object

[top of page]

View: EDR_PSIG_DOC_PARAMS_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Document Parameter MLS View

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW ID
PARAMETER_ID NUMBER
Y Parameter ID
DOCUMENT_ID NUMBER

Document ID
NAME VARCHAR2 (100)
Parameter Name
VALUE VARCHAR2 (4000)
Parameter Value
DISPLAY_NAME VARCHAR2 (240)
Parameter Display name

[top of page]

APPS.EDR_PSIG_DOC_PARAMS_VL references the following:

APPS
SYNONYM - EDR_PSIG_DOC_PARAMS_B
SYNONYM - EDR_PSIG_DOC_PARAMS_TL
APPS.EDR_PSIG_DOC_PARAMS_VL is referenced by following:

APPS
PACKAGE BODY - EDR_PSIG

[top of page]

View: EDR_PSIG_SIGN_PARAMS_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Signature Parameter MLS View

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW ID
PARAMETER_ID NUMBER
Y Parameter ID
SIGNATURE_ID NUMBER

Signature Detail ID
NAME VARCHAR2 (100)
Signer Parameter Name
VALUE VARCHAR2 (4000)
Signer Parameter Value
DISPLAY_NAME VARCHAR2 (240)
Signer Parameter Display Name

[top of page]

APPS.EDR_PSIG_SIGN_PARAMS_VL references the following:

APPS
SYNONYM - EDR_PSIG_SIGN_PARAMS_B
SYNONYM - EDR_PSIG_SIGN_PARAMS_TL
APPS.EDR_PSIG_SIGN_PARAMS_VL is referenced by following:

APPS
PACKAGE BODY - EDR_PSIG

[top of page]

View: EDR_SECURE_ELEMENTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Indexed XML elements defined to be used in creating security rules

Columns
Name Datatype Length Mandatory Comments
ELEMENT_ID NUMBER
Y Primary key of the indexed xml element
XML_ELEMENT VARCHAR2 (30) Y XML Element name for indexed xml element
DTD_ROOT_ELEMENT VARCHAR2 (30)
Root element of the DTD specific for the indexed xml element
APPLICATION_ID NUMBER
Y Application ID of the application owning the indexed xml element
INDEX_SECTION_NAME VARCHAR2 (30) Y Index section name for indexed xml element
INDEX_TAG VARCHAR2 (64) Y XML tag used in indexing
DISPLAY_NAME VARCHAR2 (100) Y User display name of indexed xml element
DESCRIPTION VARCHAR2 (100)
Description of indexed xml element
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

APPS.EDR_SECURE_ELEMENTS_V references the following:

APPS
SYNONYM - EDR_IDX_XML_ELEMENT_USAGES
VIEW - EDR_IDX_XML_ELEMENT_VL
APPS.EDR_SECURE_ELEMENTS_V is referenced by following:

APPS
PACKAGE BODY - EDR_POLICY_FUNCTION_PKG

[top of page]

View: EDR_WFEVENT_XMLMAP_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View containing X-ref of ERES event name and its XML gateway map code

Columns
Name Datatype Length Mandatory Comments
OWNER_APPLICATION VARCHAR2 (30)
Owner Application
EVENT_DISPLAY_NAME VARCHAR2 (80) Y Event Display Name
EVENT_NAME VARCHAR2 (240) Y Event Name
XML_MAPCODE VARCHAR2 (4000)
Map code

[top of page]

APPS.EDR_WFEVENT_XMLMAP_V references the following:

APPS
PACKAGE - EDR_INDEXED_XML_UTIL
PACKAGE - WF_CORE
VIEW - WF_EVENTS_VL
SYNONYM - WF_EVENT_SUBSCRIPTIONS

APPS.EDR_WFEVENT_XMLMAP_V is not referenced by any database object

[top of page]

View: EDR_XMLMAP_ELEMENTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View containing X-ref of XML element and dtd root elements

Columns
Name Datatype Length Mandatory Comments
ROOT_ELEMENT VARCHAR2 (255)
Root element of the XML element
MAP_CODE VARCHAR2 (30) Y Map code of the XML Gateway map containing the XML element
XML_ELEMENT VARCHAR2 (255)
The individual XML element

[top of page]

APPS.EDR_XMLMAP_ELEMENTS_V references the following:

APPS
SYNONYM - ECX_MAPPINGS
SYNONYM - ECX_OBJECTS
SYNONYM - ECX_OBJECT_ATTRIBUTES
SYNONYM - ECX_OBJECT_LEVELS

APPS.EDR_XMLMAP_ELEMENTS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract