You are browsing the archive for Oracle Latin America Localizations.

Oracle Latin America Localizations Tables

Oracle Latin America Localizations – List of database tables:

  • JL_AR_AP_AWT_CERTIF_ALL
  • JL_AR_AP_PROVINCES
  • JL_AR_AP_SUP_AWT_CR_LTS
  • JL_AR_AP_TRX_DGI_CODES
  • JL_AR_AR_DOC_LETTER_ALL
  • JL_AR_FA_EXHIBIT_GROUPS
  • JL_AR_FA_EXHIBIT_REPORT
  • JL_BR_AP_COLLECTION_DOCS_ALL
  • JL_BR_AP_CONSOLID_INVOICES_ALL
  • JL_BR_AP_INT_COLLECTION_TMP
  • JL_BR_AP_INT_COLLECT_ALL
  • JL_BR_AP_INT_COLLECT_EXT_ALL
  • JL_BR_AP_OPERATIONS
  • JL_BR_AP_TAX_CALENDAR_HEADERS
  • JL_BR_AP_TAX_CALENDAR_LINES
  • JL_BR_AR_BANK_INSTRUCTIONS
  • JL_BR_AR_BANK_OCCURRENCES
  • JL_BR_AR_BANK_RETURNS_ALL
  • JL_BR_AR_BORDEROS_ALL
  • JL_BR_AR_COLLECTION_DOCS_ALL
  • JL_BR_AR_COMP_INV_ALL
  • JL_BR_AR_CUST_INT_ERR
  • JL_BR_AR_DISTRIBUTNS_ALL
  • JL_BR_AR_MC_OCC_DOCS
  • JL_BR_AR_OCCURRENCE_DOCS_ALL
  • JL_BR_AR_PAY_SCHED_AUX
  • JL_BR_AR_POSTING_TMP
  • JL_BR_AR_REC_MET_ACCTS_EXT_ALL
  • JL_BR_AR_REMIT_BORDEROS_ALL
  • JL_BR_AR_RET_INTERFACE_ALL
  • JL_BR_AR_RET_INTERFACE_EXT_ALL
  • JL_BR_AR_RET_INTERFACE_TMP
  • JL_BR_AR_SELECT_ACCOUNTS_ALL
  • JL_BR_AR_SELECT_CONTROLS_ALL
  • JL_BR_AR_TX_CATEG_ALL
  • JL_BR_AR_TX_EXC_FSC_ALL
  • JL_BR_AR_TX_EXC_ITM_ALL
  • JL_BR_AR_TX_FSC_CLS_ALL
  • JL_BR_AR_TX_GROUP_ALL
  • JL_BR_AR_TX_LOCN_ALL
  • JL_BR_AR_TX_RULES_ALL
  • JL_BR_BALANCES_ALL
  • JL_BR_COMPANY_INFOS
  • JL_BR_GL_LEGAL_REP
  • JL_BR_JOURNALS_ALL
  • JL_BR_LOCAL_HOLIDAY_DATES
  • JL_BR_LOCAL_HOLIDAY_SETS
  • JL_BR_PO_FISC_CLASSIF_ALL
  • JL_BR_PO_FUNCTIONAL_MATRIX
  • JL_BR_PO_TAX_EXCEPTIONS_ALL
  • JL_BR_PO_TAX_EXC_ITEMS_ALL
  • JL_BR_PO_TAX_LOCATIONS_ALL
  • JL_BR_TAX_LMSG_ALL
  • JL_CANCEL_GT
  • JL_CL_AP_AWT_CERT
  • JL_CL_GL_ACCT_HIER_TMP
  • JL_CO_FA_ADJUSTMENTS
  • JL_CO_FA_APPRAISALS
  • JL_CO_FA_APPRAISAL_BOOKS
  • JL_CO_FA_ASSET_APPRS
  • JL_CO_FA_PURGE
  • JL_CO_GL_BALANCES
  • JL_CO_GL_CONC_CTRL
  • JL_CO_GL_CONC_ERRS
  • JL_CO_GL_MG_CONFIGS
  • JL_CO_GL_MG_HEADERS
  • JL_CO_GL_MG_LINES
  • JL_CO_GL_MG_LITERALS
  • JL_CO_GL_MG_RANGES
  • JL_CO_GL_NITS
  • JL_CO_GL_NIT_ACCTS
  • JL_CO_GL_TRX
  • JL_MX_FA_ISR_IMPAC
  • JL_REMIT3_GT
  • JL_REMIT_GT
  • JL_ZZ_AP_AWT_TYPES
  • JL_ZZ_AP_COMP_AWT_TYPES
  • JL_ZZ_AP_INV_DIS_WH_ALL
  • JL_ZZ_AP_INV_DIS_WH_ALL_T
  • JL_ZZ_AP_SUPP_AWT_TYPES
  • JL_ZZ_AP_SUP_AWT_CD_ALL
  • JL_ZZ_AR_TX_ATT_CLS_ALL
  • JL_ZZ_AR_TX_ATT_VAL_ALL
  • JL_ZZ_AR_TX_CATEG_ALL
  • JL_ZZ_AR_TX_CAT_ATT_ALL
  • JL_ZZ_AR_TX_CAT_DTL_ALL
  • JL_ZZ_AR_TX_CUS_CLS_ALL
  • JL_ZZ_AR_TX_EXC_CUS_ALL
  • JL_ZZ_AR_TX_EXC_FSC_ALL
  • JL_ZZ_AR_TX_EXC_ITM_ALL
  • JL_ZZ_AR_TX_FSC_CLS_ALL
  • JL_ZZ_AR_TX_GROUPS_ALL
  • JL_ZZ_AR_TX_LGL_MSG_ALL
  • JL_ZZ_AR_TX_LOCN_ALL
  • JL_ZZ_AR_TX_NAT_RAT_ALL
  • JL_ZZ_AR_TX_RULES_ALL
  • JL_ZZ_AR_TX_SCHEDULES_ALL
  • JL_ZZ_FA_RETIREMNT_ADJS
  • JL_ZZ_FA_RETIREMNT_JES
  • JL_ZZ_GL_AXI
  • JL_ZZ_GL_AXI_ACCOUNTS
  • JL_ZZ_GL_AXI_MODELS
  • JL_ZZ_GL_AXI_MODEL_RANGES
  • JL_ZZ_GL_AXI_TMP

Latin America Localizations Forms

Oracle Latin America Localizations Forms:

FORM SHORT CODEORACLE FORM NAME
JLARFEAGExhibit of Fixed Assets Groups
JLARPDTCSet up DGI transaction codes
JLARPPROSet up provinces
JLARPWHLEnter supplier withholding credit letters
JLARRDOLVAT Document Letter Assignments
JLBRPACDManual Association of Collection Documents
JLBRPCCDImported Collection Documents
JLBRPECDEnter Collection Documents
JLBRPECIEnter Consolidated Invoices
JLBRPETCDefine Tax Calendars
JLBRPOFCDefine Operation Fiscal Codes
JLBRRCDBCorrect Bank Returns
JLBRRCOIComplementary Invoice
JLBRRDBOBank Occurrence Codes
JLBRRDICBank Instruction Codes
JLBRRDPMDefine Global Receipt Method Accounts
JLBRREMRBank Returns
JLBRRIOBBank Occurrences
JLBRRPRBPost Bank Return
JLBRRSABCreate Bank Transfer Remittance Batches
JLBRRSBOCreate Occurrences Remittance Batches
JLBRRSEBFormat Remittance Batches
JLBRSDCIDefine Company Information
JLBRSDLHDefine Local Holidays Sets
JLBRUDFCDefine Fiscal Classification Code
JLBRUDFMDefine Tax Functional Matrix
JLBRUDTLDefine Tax Locations
JLBRUTEFDefine Tax Exceptions by FCC
JLBRUTEIDefine Tax Exceptions by Items
JLCOFTAAMaintain Technical Appraisals
JLCOGLCADefine Control Accounts
JLCOGLIMDefine Literals
JLCOGLTPDefine Third Party Information
JLZZGAAMAccounting Models
JLZZGSUBRun Inflation Adjustments
JLZZPCWHSet up company withholding applicability
JLZZPDWTSet up withholding tax types
JLZZPIDWDefine invoice distribution withholdings
JLZZPSWHSet up supplier withholding applicability
JLZZTATCTax Condition Classes
JLZZTCACDefine Customer Site Tax Profile
JLZZTCAVAssociate Tax Category with Conditions and Values
JLZZTCTDTax Category Details
JLZZTCTGTax Categories
JLZZTCTSTax Category Schedules
JLZZTECSTax Exceptions by Customer Site
JLZZTEFSTax Exceptions by Fiscal Classification
JLZZTEITTax Exceptions by Items
JLZZTFSCFiscal Classifications
JLZZTLMRAssociate Tax Legal Messages
JLZZTLOCTax Locations
JLZZTLTGTax Groups
JLZZTTNRTax Exceptions by Transaction Condition Values
JLZZTTXRTax Rules
JLBRPSUPDefine Participant Setup
JLBRPRSPDefine Participant Relationship Setup
JLBRBKTPDefine Bookkeeping Types
JLBREINVElectronic Invoice Attributes
JLBREISHElectronic Invoice Status History

Latin America Localizations Profile Options

Oracle Latin America Localizations Profile Options:

PROFILE OPTION SHORT CODEPROFILE OPTION NAME
JLBR_CHECKDATE_BDC_VALIDATIONJLBR Check Date BDC Validation
JLZZ_TAXID_RAISE_ERRORJL: Tax ID Validation Failure
JLBR_SPED_AGGLU_SOURCEJLBR : SPED Agglutination Code Source
EXT_AWT_DEBUG_FLAGExtended Withholding: Debug Flag
EXT_AWT_DEBUG_FILE_LOCATIONExtended Withholding: Debug File Directory
JL_ZZ_RUN_INFL_ADJJL:Perform Inflation Adjustment
JLBR_AUTOMATIC_PAY_BATCH_NAMEObsolete in R12 – JLBR Automatically Populate Payment Batch Name
JLBR_BANK_TRANSFER_CURRENCYJLBR:Bank Transfer Currency
JLBR_BILLING_ONJLBR Billing On
JLBR_CALENDARJLBR Calendar Name
JLBR_CHANGE_DATE_AUTOMATICALLYJLBR Automatically Change Date
JLBR_PAYMENT_ACTIONJLBR Payment Action
JLBR_PAYMENT_LOCATIONJLBR Payment Location
JLZZ_AR_TX_USE_WHOLE_OPERATIONJL: AR Tax: Use Related Transactions for Threshold checking
JLZZ_COPY_AND_VOID_INVOICES_TIMEOUTJL: Copy and Void Invoice Program Timeout
JLZZ_COPY_CUS_SUP_NUMJL: Copy Tax Identifier Number
JLZZ_DEBUG_MODEJL: Debug Mode
JLZZ_INF_RATIO_PRECISIONJL: Inflation Ratio Precision
JLZZ_RUN_INFL_ADJJL :  Perform Inflation Adjustment
JLBR_SPED_PARTIC_TYPESJLBR : SPED Participant Types