EDR — E-Records
34 documented tables · 12 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
EDR_RULE_CONDITION_TEMP |
EDR temp table in ERES support for input variable eRecord showing rule conditions | standalone |
EDR_PREPARE_DOCUMENT_TEMP |
To Store transient PDF of individual E-Records selected for printing | standalone |
EDR_SEC_ADMIN_TL |
E-Record security administration translation table | standalone |
EDR_PSIG_DOCUMENTS |
Electronic Signature Document store | standalone |
EDR_FWK_TEST_B |
This table is to support ERES Framework Testing in new environments. This is not a functional Table. | standalone |
EDR_IDX_XML_ELEMENT_USAGES |
E-Record indexed xml element usage table | standalone |
EDR_COLLATE_PRINT_TEMP |
To store the Final Collated PDF to be printed | standalone |
EDR_FILES_TL |
Translation table to store the files uploaded using the ERES File Upload System | standalone |
EDR_FILES_B |
Base table to store the files uploaded using the ERES File Upload System | standalone |
EDR_SEC_ADMIN_B |
E-Record security administration base table | standalone |
EDR_PSIG_DOC_PARAMS_B |
Electronic Signature Document Attributes | standalone |
EDR_PSIG_SIGN_PARAMS_B |
Electronic Signature Signature Attributes | standalone |
EDR_TRANS_ACKN |
Table to store the transaction acknowledgement for erecords | standalone |
EDR_PROCESS_ERECORDS_T |
Temporary table to hold the run time erecord object data | satellite-leaning |
EDR_ERESPARAMETERS_T |
Table to store user defined parameters for ORES | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
EDR_ERES_EVENT_PUB |
PUB | 7 | 12 packages |
EDR_CONSTANTS_GRP |
GRP | 0 | 11 packages |
EDR_STANDARD_PUB |
PUB | 18 | 7 packages |
EDR_TRANS_ACKN_PUB |
PUB | 1 | 6 packages |
EDR_EVIDENCESTORE_PUB |
PUB | 12 | 5 packages |
EDR_FILE_UTIL_PUB |
PUB | 6 | 3 packages |
EDR_ATTACHMENTS_GRP |
GRP | 12 | 3 packages |
EDR_CONSTANTS_PUB |
PUB | 0 | 2 packages |
EDR_EVENT_RELATIONSHIP_PUB |
PUB | 2 | 2 packages |
EDR_FILES_PUB |
PUB | 1 | 1 packages |