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.