Cashing In On JDEdwards EnterpriseOne (E1) Cache
Read Time:1 Min, 15 Sec
We recently had some questions about what tables are in cache.
Here is a great Oracle Support article on JDEdwards EnterpriseOne E1 Cache:
Frequently Asked Questions on Caching in EnterpriseOne [ID 944015.1]
The tables in the database cache are:
F0004 | User Defined Code Types |
F0005 | User Defined Codes |
F0006 | Cost Center Master |
F0007 | Work Day Calendar |
F0008 | Date Fiscal Patterns |
F0012 | Automatic Accounting Instructions Master |
F0013 | Currency Codes |
F0014 | Payment Terms |
F00144 | Installment Payment Terms |
F0015 | Currency Exchange Rates |
F0022 | Tax Rules |
F0025 | Ledger Type Master File |
F0026 | |
F01138 | |
F069016 | Payroll Tax Area Profile |
F069036 | Payroll Transaction Cross Reference |
F069056 | Establishment Constant File |
F069086 | Payroll Corporate Tax Identification |
F069096 | Payroll General Constants |
F069106 | Union Benefits Master |
F069116 | |
F069226 | Unemployment Insurance Rates |
F07901 | Pre-Payroll DBA Calculation Control Table |
F08040 | HR History Constants |
F0901 | Account Master |
F1609 | |
F1690 | |
F17001 | Service Warranty Constants Table |
F1724 | Service Contract Coverage |
F1725 | Service Contract Services |
F1752 | Case Types |
F1753 | Case Priority |
F1790 | Product Family/Model Master |
F1793 | S/WM Line Type Constants |
F3009 | Job Shop Manufacturing Constants |
F40039 | Document Type Master |
F40070 | Preference Master File |
F40073 | Preference Hierarchy File |
F4008 | Tax Areas |
F4009 | Distribution/Manufacturing Constants |
F40095 | Default Locations/Printers |
F40203 | Order Activity Rules |
F40205 | Line Type Control Constants File |
F4070 | Price Adjustment Schedule |
F4071 | Price Adjustment Type |
F4095 | |
F41001 | Inventory Constants |
F41002 | Item Units of Measure Conversion Factors |
F41003 | Unit of Measure standard conversion |
F48091 | |
F7306 | |
F95922 | |
F99410 | |
FF30L011 | |
FF30L012 | |
FF34S003 |
E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne [ID 944015.1]
Pretty cool. I vaguely reemebmr that there is more you can do with the ANSI syntax than the old (+) way but I’ve forgotten the details. This seems like a good example using a function in the outer join condition. I know I should abandon the old syntax but I’ve been resisting.