You are browsing the archive for Oracle Latin America Localizations.

by oracleguru

Oracle Latin America Localizations Tables

ORACLE APPS COMMUNITY > Tutorial > Localizations > Oracle Latin America Localizations

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

Tags: No Comments »

by oracleguru

Latin America Localizations Forms

ORACLE APPS COMMUNITY > Tutorial > Localizations > Oracle Latin America Localizations

Oracle Latin America Localizations Forms:

FORM SHORT CODE ORACLE FORM NAME
JLARFEAG Exhibit of Fixed Assets Groups
JLARPDTC Set up DGI transaction codes
JLARPPRO Set up provinces
JLARPWHL Enter supplier withholding credit letters
JLARRDOL VAT Document Letter Assignments
JLBRPACD Manual Association of Collection Documents
JLBRPCCD Imported Collection Documents
JLBRPECD Enter Collection Documents
JLBRPECI Enter Consolidated Invoices
JLBRPETC Define Tax Calendars
JLBRPOFC Define Operation Fiscal Codes
JLBRRCDB Correct Bank Returns
JLBRRCOI Complementary Invoice
JLBRRDBO Bank Occurrence Codes
JLBRRDIC Bank Instruction Codes
JLBRRDPM Define Global Receipt Method Accounts
JLBRREMR Bank Returns
JLBRRIOB Bank Occurrences
JLBRRPRB Post Bank Return
JLBRRSAB Create Bank Transfer Remittance Batches
JLBRRSBO Create Occurrences Remittance Batches
JLBRRSEB Format Remittance Batches
JLBRSDCI Define Company Information
JLBRSDLH Define Local Holidays Sets
JLBRUDFC Define Fiscal Classification Code
JLBRUDFM Define Tax Functional Matrix
JLBRUDTL Define Tax Locations
JLBRUTEF Define Tax Exceptions by FCC
JLBRUTEI Define Tax Exceptions by Items
JLCOFTAA Maintain Technical Appraisals
JLCOGLCA Define Control Accounts
JLCOGLIM Define Literals
JLCOGLTP Define Third Party Information
JLZZGAAM Accounting Models
JLZZGSUB Run Inflation Adjustments
JLZZPCWH Set up company withholding applicability
JLZZPDWT Set up withholding tax types
JLZZPIDW Define invoice distribution withholdings
JLZZPSWH Set up supplier withholding applicability
JLZZTATC Tax Condition Classes
JLZZTCAC Define Customer Site Tax Profile
JLZZTCAV Associate Tax Category with Conditions and Values
JLZZTCTD Tax Category Details
JLZZTCTG Tax Categories
JLZZTCTS Tax Category Schedules
JLZZTECS Tax Exceptions by Customer Site
JLZZTEFS Tax Exceptions by Fiscal Classification
JLZZTEIT Tax Exceptions by Items
JLZZTFSC Fiscal Classifications
JLZZTLMR Associate Tax Legal Messages
JLZZTLOC Tax Locations
JLZZTLTG Tax Groups
JLZZTTNR Tax Exceptions by Transaction Condition Values
JLZZTTXR Tax Rules
JLBRPSUP Define Participant Setup
JLBRPRSP Define Participant Relationship Setup
JLBRBKTP Define Bookkeeping Types
JLBREINV Electronic Invoice Attributes
JLBREISH Electronic Invoice Status History

Tags: No Comments »

by oracleguru

Latin America Localizations Profile Options

ORACLE APPS COMMUNITY > Tutorial > Localizations > Oracle Latin America Localizations

Oracle Latin America Localizations Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
JLBR_CHECKDATE_BDC_VALIDATION JLBR Check Date BDC Validation
JLZZ_TAXID_RAISE_ERROR JL: Tax ID Validation Failure
JLBR_SPED_AGGLU_SOURCE JLBR : SPED Agglutination Code Source
EXT_AWT_DEBUG_FLAG Extended Withholding: Debug Flag
EXT_AWT_DEBUG_FILE_LOCATION Extended Withholding: Debug File Directory
JL_ZZ_RUN_INFL_ADJ JL:Perform Inflation Adjustment
JLBR_AUTOMATIC_PAY_BATCH_NAME Obsolete in R12 – JLBR Automatically Populate Payment Batch Name
JLBR_BANK_TRANSFER_CURRENCY JLBR:Bank Transfer Currency
JLBR_BILLING_ON JLBR Billing On
JLBR_CALENDAR JLBR Calendar Name
JLBR_CHANGE_DATE_AUTOMATICALLY JLBR Automatically Change Date
JLBR_PAYMENT_ACTION JLBR Payment Action
JLBR_PAYMENT_LOCATION JLBR Payment Location
JLZZ_AR_TX_USE_WHOLE_OPERATION JL: AR Tax: Use Related Transactions for Threshold checking
JLZZ_COPY_AND_VOID_INVOICES_TIMEOUT JL: Copy and Void Invoice Program Timeout
JLZZ_COPY_CUS_SUP_NUM JL: Copy Tax Identifier Number
JLZZ_DEBUG_MODE JL: Debug Mode
JLZZ_INF_RATIO_PRECISION JL: Inflation Ratio Precision
JLZZ_RUN_INFL_ADJ JL :  Perform Inflation Adjustment
JLBR_SPED_PARTIC_TYPES JLBR : SPED Participant Types

Tags: No Comments »