JL — Latin America Localizations
115 documented tables · 73 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
JL_BR_AR_TX_CATEG_ALL |
Brazilian Tax Categories;no longer used | hub |
JL_CO_GL_MG_CONFIGS |
Magnetic Media Report Grouping Configurations | hub-leaning |
JL_CO_GL_MG_LITERALS |
Magnetic Media Literals | hub-leaning |
JL_CO_GL_CONC_CTRL |
Third Party Control Table Containing Log For Every Submission Of 'Generate Third Party Balances' Concurrent | hub-leaning |
JL_CO_FA_APPRAISALS |
Information about the technical appraisal header | hub-leaning |
JL_ZZ_AR_TX_CATEG_ALL |
Latin Tax Category Information | hub-leaning |
JL_ZZ_AR_TX_ATT_VAL_ALL |
Latin Tax Condition Values Information | hub-leaning |
JL_BR_LOCAL_HOLIDAY_SETS |
Brazilian local holiday sets | hub-leaning |
JL_BR_COMPANY_INFOS |
No Longer Used in R12 | satellite-leaning |
JL_BR_AP_TAX_CALENDAR_HEADERS |
Brazilian withholding tax calendar header information | hub-leaning |
JL_BR_AR_BORDEROS_ALL |
Bank Transfer Batches | satellite-leaning |
JL_BR_AR_SELECT_CONTROLS_ALL |
Selection Criteria for invoices sent to Bank transfer batches | hub-leaning |
JL_CO_GL_NITS |
Third Party Master Table | hub-leaning |
JL_BR_AR_SELECT_ACCOUNTS_ALL |
Bank Account distribution criteria for Bank Transfer batches | satellite-leaning |
JL_ZZ_GL_AXI_MODELS |
Accounting Models | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
JL_BR_SPED_DATA_EXTRACT_PUB |
PUB | 2 | 1 packages |
JL_BR_AP_VALIDATE_COLLECT_PUB |
PUB | 1 | 1 packages |
JL_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
JL_CUSTOM_PUB |
PUB | 1 | 0 packages |
JL_BR_SPED_PUB |
PUB | 3 | 0 packages |