IEX — Collections
80 documented tables · 0 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
IEX_CALL_HISTORIES_ALL |
OBSOLETED.History for all contacts | hub-leaning |
IEX_DELINQUENCIES_ALL |
Holds transaction data about customer delinquencies. | hub-leaning |
IEX_INVOICES_ALL |
OBSOLETED - Stores invoices paid and disputed through Colections | satellite-leaning |
IEX_PAY_HISTORIES_ALL |
OBSOLETED - All payments and promises | satellite-leaning |
IEX_REPOSSESSIONS |
Details for Repossession | standalone |
IEX_DISPUTES |
Holds data about all disputes processed through collections UI. | standalone |
IEX_COSTS |
Maintains the actual and budgeted costs for a case or delinquency | standalone |
IEX_CASES_ALL_B |
Details of the Case | standalone |
IEX_STRATEGY_TEMPLATE_GROUPS |
standalone | |
IEX_PAY_OKL_XREF |
Table stores all OKL consolidated invoices or contracts paid in IEX | standalone |
IEX_QUERY_STRINGS |
standalone | |
IEX_SCORE_COMP_TYPES_TL |
Stores configuration data on score components. | standalone |
IEX_CGI_SWITCHES |
Metadata for query string switches | standalone |
IEX_DUNNINGS |
Holds data on all dunning transactions sent by the system. | standalone |
IEX_DEL_PAY_XREF |
This table stores what delinquencies were paid by an A/R payment. | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
IEX_DEBUG_PUB |
PUB | 4 | 88 packages |
IEX_STRY_UTL_PUB |
PUB | 14 | 7 packages |
IEX_DELINQUENCY_PUB |
PUB | 8 | 5 packages |
IEX_WF_BAN_STATUS_PUB |
PUB | 12 | 5 packages |
IEX_DUNNING_PUB |
PUB | 9 | 5 packages |
IEX_STRATEGY_PUB |
PUB | 5 | 4 packages |
IEX_FILTER_PUB |
PUB | 6 | 4 packages |
IEX_OPEN_INTERFACE_PUB |
PUB | 11 | 3 packages |
IEX_TERR_WINNERS_PUB |
PUB | 2 | 3 packages |
IEX_STRATEGY_WF_PUB |
PUB | 2 | 2 packages |