EDR Tables (34)

EDR - E-Records — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
EDR_AMERULE_INPUT_VAR 12 AME Rule Input Variable Table
EDR_AMETRAN_INPUT_VAR 13 AME Transaction Input Variable Table
EDR_COLLATE_PRINT_TEMP 9 To store the Final Collated PDF to be printed
EDR_ERECORDS 13 Oracle eRecords
EDR_ERECORD_ID_TEMP 1
EDR_ERESMANAGER_T 9 Temporary table to hold run time ERES Manager object details
EDR_ERESPARAMETERS_T 5 Table to store user defined parameters for ORES
EDR_ESIGNATURES 15 Oracle eSignatures
EDR_EVENT_RELATIONSHIP 12 Table to store the relationship between erecords.
EDR_FILES_B 31 Base table to store the files uploaded using the ERES File Upload System
EDR_FILES_TL 9 Translation table to store the files uploaded using the ERES File Upload System
EDR_FWK_TEST_B 41 This table is to support ERES Framework Testing in new environments. This is not a functional Table.
EDR_FWK_TEST_TL 9 Translation table to store the ERES Framework Test data
EDR_IDX_XML_ELEMENT_B 13 eRecord indexed xml element base table for storing indexed xml elements
EDR_IDX_XML_ELEMENT_TL 11 E-Record indexed xml element translation table
EDR_IDX_XML_ELEMENT_USAGES 9 E-Record indexed xml element usage table
EDR_INTER_EVENT_TEST_EVENTS 43 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_INTE
EDR_INTER_EVENT_TEST_SCENARIOS 10 EDR_INTER_EVENT_TEST_SCENATIOS is to store information about Test scenario instances created using Inter Event Verification form. There is a
EDR_PREPARE_DOCUMENT_TEMP 5 To Store transient PDF of individual E-Records selected for printing
EDR_PROCESS_ERECORDS_T 26 Temporary table to hold the run time erecord object data
EDR_PSIG_DETAILS 20 Electronic signature document details
EDR_PSIG_DOCUMENTS 18 Electronic Signature Document store
EDR_PSIG_DOC_PARAMS_B 9 Electronic Signature Document Attributes
EDR_PSIG_DOC_PARAMS_TL 9 Translation Table for document parameter
EDR_PSIG_PRINT_HISTORY 13 Maintain print history for a e-record
EDR_PSIG_SIGN_PARAMS_B 9 Electronic Signature Signature Attributes
EDR_PSIG_SIGN_PARAMS_TL 9 Translation Table for Signature parameter
EDR_RAW_XML_T 8
EDR_REDLINE_TRANS_DATA 7 EDR Redlining temporary table
EDR_RULE_CONDITION_TEMP 5 EDR temp table in ERES support for input variable eRecord showing rule conditions
EDR_RULE_DETAIL_TEMP 10 EDR temp table in ERES support for input variable eRecord showing rule detail info
EDR_SECURITY_RULES 14 E-Record security rule table for storing the security rules used by VPD
EDR_TRANS_ACKN 11 Table to store the transaction acknowledgement for erecords
EDR_TRANS_QUERY_TEMP 8 eRecords Reports Temporary Table