You are browsing the archive for Setups.

General Ledger Profile Options

Oracle General Ledger module profile options:

PROFILE OPTION SHORT CODEPROFILE OPTION NAME
GLDI_AHE_SAVING_ALLOWEDGL AHE: Saving Allowed
GL_ACCESS_SET_IDGL: Data Access Set
GL_ACCOUNTS_TO_PROCESSGL: Number of Accounts In Memory
GL_ADI_VIEWERGL : Default Desktop Viewer
GL_ALLOC_NUMBER_OF_FORMULAS_TO_VALIDATEGL: Number of formulas to validate for each MassAllocation batch
GL_GLCCON_PRESERVE_JE_DATEGL Consolidation: Preserve Journal Effective Date
GL_GLLEZL_ARCHIVE_ROWSGL: Archive Journal Import Data
GL_ITG_ADJUSTMENT_PDGL OFSA: Adjustment Period Data in Last Fiscal Period
GL_ITG_CURRENCY_TYPE_CODEGL OFSA: Transfer All Currency Types
GL_ITG_DAILY_CONVERSION_TYPESGL OFSA: Conversion Rate Type for OFSA Source Transactions
GL_ITG_OFSA_LEAF_INSERTGL OFSA: Automatically Create OFSA Leaf Values
GL_ITG_SOURCE_CURRENCY_CODEGL OFSA: Include Source Currency Code in Transfer
GL_ITG_SPECIAL_CURRENCY_CODEGL OFSA: Special Functional Currency Code
GL_RECORDS_TO_PROCESSGL: Number of Records to Process at Once
GL_RJE_NUMBER_OF_FORMULAS_TO_VALIDATEGL: Number of formulas to validate for each Recurring Journal batch
GL_MRC_IS_CONVERSION_TYPEGL/MRC: Income Statement Conversion Type
GL_MRC_OVERRIDE_HIST_AMTGL/MRC: Historical Amount Segment
GL_MRC_OVERRIDE_HIST_RATEGL/MRC: Historical Rate Segment
GL_MRC_REPT_SOB_WITH_OVERRIDEGL/MRC: Reporting Currency using Overriding Historical Rates/Amounts
GL_MRC_SPAWN_POSTINGGL/MRC: Post Reporting Journals Automatically
GL_VALIDATE_REFERENCE_DATEEnter Journals: Validate Reference Date
GLDI_ANALYSIS_PRIVSGLDI: Analysis Wizard Privileges
GLDI_AHE_PRIVSGLDI: AHE Privileges
ADI_WHEN_SYSADMIN_OUTPUT_VIEWADI: Allow Sysadmin to View all Output
GLDI_MAX_EFFECT_RANGE_DRILLGLDI: Maximum Effective Ranges for Drilldown
GLDI_BALANCE_ACCOUNTING_DATEGLDI: Balance by Accounting Date
GLDI_FORCE_FULL_VALIDATIONGLDI: Force Full Validation
GLDI_CREATE_GROUP_IDGLDI: Create Group ID
ADI_USE_FUNCTIONAL_SECURITYADI: Use Function Security
GLDI_FORCE_JOURNAL_BALANCEGLDI: Force Journal to Balance
GLDI_JOURNAL_SOURCEGLDI: Journal Source
GLDI_CONVERTED_ENTRY_THRESHOLDGLDI: Converted Entry Threshold
GL_GLPPOS_AVGBAL_POST_WORKERSGL: Number of Average Balance Post Workers
GLDI_ALLOW_DRILL_ACROSS_BOOKSGLDI: Allow Drill Across Ledgers
GL_JAHE_DB_HOSTGL AHM: Database Host
GL_GLCCON_FILTER_BY_CATEGORYGL Consolidation: Exclude Journal Category During Transfer
GL_JAHE_DB_PORTGL AHM: Database Port
GL_GLCCON_PRESERVE_JEGL Consolidation: Preserve Journal Batching
FNDNAMGL AHM: FND Schema Name
GL_JAHE_SAVING_ALLOWEDGL AHM: Allow Users to Modify Hierarchy
GL_JAHE_MAX_FETCH_SIZEGL AHM: Maximum Items Displayed At a Time
GL_SUMMARY_USE_OLD_OPT_METHODGL Journals: Use Alternative Optimization Method For Summarization
GL_GLCCIT_EMAIL_CONTACTGL Consolidation: Cross Instance Workflow Notification Contact
GL_STD_ANALYSIS_REPORT_BALANCE_SECURITYGL Account Analysis Report: Enable Segment Value Security on Beginning/Ending Balances
INTERFUNDGL:Create Interfund Entries
ATTRIBUTE_REPORTINGFSG:Enable Attribute Reporting
ACCOUNT_CATEGORY_BALANCINGGL:Enforce Account Category Balancing
CREATE_BUDGETARY_ENCUMBRANCESGL:Create Encumbrance Entries for Budgetary Accounts
USSGL_OPTIONEnable Transaction Code
GL_MRC_INHERIT_CREATED_BYGL/MRC: Inherit the creation user for the reporting currency’s journal from the primary ledger’s journal
GL_REVENUE_EXPENSE_TRANSLATION_RULEGL Translation: Revenue/Expense Translation Rule
GL_REVAL_MAX_DAYS_TO_ROLL_RATEGL Revaluation: Days to Roll Forward Daily Rates
GL_DEBUG_MODEGL: Debug Mode
GL_AUTO_ALLOC_CONTINUE_NEXT_STEPGL AutoAllocation: Continue to Next Step if No Journal Created
GL_REVAL_VALIDATE_GAINLOSSGL Revaluation: Validate Gain/Loss Accounts
GL_CRM_CR_OVERRIDEGL Daily Rates: Cross Rates Override
GL_REVAL_MRC_FROM_PRIMARY_CURRENCYGL/MRC Revaluation: Use Primary Book Currency Instead of Entered Currency
GL_GLCCON_SPLITGL Consolidation: Separate rows for debit and credit account balances in consolidation journal
GL_MJE_FIND_WINDOW_STATEGL Journals: Last Find Window State
GL_JI_ALWAYS_GROUP_BY_DATEGL Journal Import: Separate Journals by Accounting Date
GL_REVERSE_TC_OPTIONGL: Reverse Transaction Codes on Un-natural Balances
BUDGETARY_CONTROL_OPTIONBudgetary Control Group
DISPLAY_INVERSE_RATEJournals: Display Inverse Rate
GLDI_ALLOW_DRILLDOWN_ACROSS_BOOKSGLDI: Allow Drilldown Across Ledgers
GLDI_AUTOCOPY_ENF_LEVELGLDI: Autocopy Enforcement Level
GLDI_BUDGET_WIZ_PRIVSGLDI: Budget Wizard Privileges
GLDI_BUD_WIZ_SEG_VAL_SECURITYGLDI: Enforce Budget Wizard Segment Security
GLDI_JOURNAL_WIZ_PRIVSGLDI: Journal Wizard Privileges
GLDI_REPORT_WIZ_PRIVSGLDI: Report Wizard Privileges
GL_AHE_SAVING_ALLOWEDGL AHE: Saving Allowed (Obsolete)
GL_ALLOW_NON_BUSINESS_DAYJournals: Allow Non-Business Day Transactions
GL_ALLOW_PREPARER_APPROVALJournals: Allow Preparer Approval
GL_ALLOW_USER_RATE_BETWEEN_EMU_AND_NONEMUCurrency: Allow Direct EMU/Non-EMU User Rates
GL_AUTOREV_AFTER_OPEN_PERIODGL: Launch AutoReverse After Open Period
GL_AUTO_ALLOC_ROLLBACK_ALLOWEDGL: Auto Allocation Rollback Allowed
GL_DAILY_RATES_ENFORCE_INVERSEDaily Rates Window: Enforce Inverse Relationship During Entry
GL_DEBUG_LOG_DIRECTORYGL: Debug Log Directory
GL_DEFAULT_JE_CATEGORYJournals: Default Category
GL_DUAL_CURRENCYDual Currency
GL_DUAL_DEFAULT_RATE_TYPEDual Currency Default Rate Type
GL_ENABLE_PRIOR_PERIOD_NOTIFICATIONJournals: Enable Prior Period Notification
GL_FIND_APPROVER_METHODJournals: Find Approver Method
GL_GLCCON_OPTM_FACTORGL Consolidation: Optimizer Factor
GL_GLPURGE_JE_SET_SIZEGL: Journal Entry Purge Set Size
GL_GLPURGE_LINE_SET_SIZEGL: Journal Line Purge Set Size
GL_GLSTPM_OPTM_FACTORSummarization: Optimizer Factor
GL_IEA_PROTECT_NATURAL_ACCTIntercompany/Interfund: Protect Receiver Natural Account
GL_IEA_SUBSIDIARY_IDIntercompany/Interfund: Subsidiary
GL_IEA_USE_AUTO_TRANS_NUMIntercompany/Interfund: Use Automatic Transaction Numbering
GL_JRNL_REVW_REQUIREDGL: Journal Review Required
GL_NUMBER_OF_PURGE_WORKERSGL: Number of Purge Workers
GL_OVERRIDE_REVERSAL_OPTIONJournals: Override Reversal Method
GL_OWNERS_EQUITY_TRANSLATION_RULEGL: Owner’s Equity Translation Rule
GL_REVAL_INC_ACC_RULEGL: Income Statement Accounts Revaluation Rule
GL_REVAL_USE_LAST_RANGEGL Revaluation: AutoQuery Last Run Ranges
GL_SET_OF_BKS_IDGL Ledger ID
GL_SET_OF_BKS_NAMEGL Ledger Name
GL_SUMMARY_ACCT_SET_SIZEGL Summarization: Accounts Processed at a Time Per Delete Worker
GL_SUMMARY_DEL_WORKERSGL Summarization: Number of Delete Workers
GL_SUMMARY_MAINTAIN_FACTORGL Summarization: Maintenance Index Selection Factor
GL_SUMMARY_ROWS_PER_COMMITGL Summarization: Rows Deleted Per Commit
POP_UP_STAT_ACCOUNTJournals: Mix Statistical and Monetary
USE_PERFORMANCE_MODULEUse Performance Module
MRC_MAX_DAYS_TO_ROLL_RATEMRC: Maximum Days to Roll Forward Conversion Rate
MULTIPLE_RATES_PER_JEJournals: Allow Multiple Exchange Rates
GL_REVAL_BAL_BY_COST_CENTERGL Revaluation: Tracking by Cost Center
GL_MRC_BS_CONVERSION_TYPEGL/MRC: Balance Sheet Conversion Type

General Ledger Descriptive Flex Fields

Oracle General Ledger module DFF list

DFF ViewDFF CODE NAMEDFF name
GL_SHARES_ACTIVITY_DFVGL_SHARES_ACTIVITYCommon Stocks: Share Activity
GL_SHARES_OUTSTANDING_DFVGL_SHARES_OUTSTANDINGCommon Stocks: Outstanding Shares
GL_SUMMARY_TEMPLATES_DFVGL_SUMMARY_TEMPLATESSummary Accounts
GL_SUSPENSE_ACCOUNTS_DFVGL_SUSPENSE_ACCOUNTSSuspense Accounts
GL_TAX_CODES_DFVGL_TAX_CODESEnter Journals: Value Added Tax
GL_TAX_OPTIONS_DFVGL_TAX_OPTIONSTax Options
GL_TAX_OPTION_ACCOUNTS_DFVGL_TAX_OPTION_ACCOUNTSTax Options: Accounts
GL_TEMPORARY_COMBINATIONS_DFVGL_TEMPORARY_COMBINATIONSTemporary Combinations
GL_TRANSACTION_CALENDAR_DFVGL_TRANSACTION_CALENDARTransaction Calendar
GL_TRANSACTION_DATES_DFVGL_TRANSACTION_DATESTransaction Dates
GL_TRANSACTION_RATE_EXCEPT_DFVGL_TRANSACTION_RATE_EXCEPTIONSTransaction Rate Exceptions
GL_TRANSLATION_RATES_DFVGL_TRANSLATION_RATESPeriod Rates
GL_USSGL_ACCOUNT_PAIRS_DFVGL_USSGL_ACCOUNT_PAIRSGovernment Trans Codes: Account Pairs
GL_USSGL_TRANSACTION_CODES_DFVGL_USSGL_TRANSACTION_CODESGovernment Transaction Codes: Code
GL_WEIGHTED_AVG_DETAILS_DFVGL_WEIGHTED_AVG_DETAILSWeighted Average Details
GL_JE_HEADERS1_DFVHEADERS_USSGL_TRANSACTION_CODEEnter Journals: Journal Transaction Code
GL_JE_LINES2_DFVLINES_USSGL_TRANSACTION_CODEEnter Journals: Line Transaction Code
GL_REVALUATIONS_DFVGL_REVALUATIONSRevaluations
GL_REVAL_ACCOUNT_RANGES_DFVGL_REVAL_ACCOUNT_RANGESRevaluations: Account Ranges
GL_JE_BATCHES1_DFVBATCH_USSGL_TRANSACTION_CODEEnter Journals: Batch Transaction Code
GL_AUTO_ALLOC_BATCHES_DFVGL_ALLOCATION_BATCHESAutoAllocation Batch
GL_AUTO_ALLOC_SETS_DFVGL_ALLOCATION_SETSDefine AutoAllocation Set
GL_AUTHORIZATION_LIMITS_DFVGL_AUTHORIZATION_LIMITSJournal Authorization Limits
GL_AUTOMATIC_POSTING_OPTIO_DFVGL_AUTOMATIC_POSTING_OPTIONSAutoPost Criteria
GL_AUTOMATIC_POSTING_SETS_DFVGL_AUTOMATIC_POSTING_SETSAutomatic Posting Sets
GL_AUTOREVERSE_OPTIONS_DFVGL_AUTOREVERSE_OPTIONSAutoReversal Criteria
GL_BC_OPTIONS_DFVGL_BC_OPTIONSBudgetary Control Group: Group
GL_BC_OPTION_DETAILS_DFVGL_BC_OPTION_DETAILSBudgetary Control Group: Rules
GL_BUDGETS_DFVGL_BUDGETSDefine Budget
GL_BUDGET_ASSIGNMENTS_DFVGL_BUDGET_ASSIGNMENTSDefine Budget Organization: Assignments
GL_BUDGET_ASSIGNMENT_RANGE_DFVGL_BUDGET_ASSIGNMENT_RANGESDefine Budget Org: Assignment Ranges
GL_BUDGET_ENTITIES_DFVGL_BUDGET_ENTITIESDefine Budget Organization: Organization
GL_BUDGET_TYPES_DFVGL_BUDGET_TYPESBudget Types
GL_BUDGET_VERSIONS_DFVGL_BUDGET_VERSIONSBudget Versions
GL_CAPTURED_INFO_DFVGL_CAPTURED_INFOEnter Journals: Captured Information
GL_CODE_COMBINATIONS_DFVGL_CODE_COMBINATIONSGL Accounts
GL_CONCURRENT_SCHEDULES_DFVGL_CONCURRENT_SCHEDULESDefine Submission Schedules
GL_DAILY_CONVERSION_RATES_DFVGL_DAILY_CONVERSION_RATESDaily Conversion Rates
GL_DAILY_CONVERSION_TYPES_DFVGL_DAILY_CONVERSION_TYPESConversion Rate Types
GL_DAILY_RATES_DFVGL_DAILY_RATESDaily Rates
GL_ELIM_ACCOUNTS_MAP_DFVGL_ELIMINATION_ACCOUNTSElimination Accounts
GL_ELIMINATION_JOURNALS_DFVGL_ELIMINATION_JOURNALSElimination Journal
GL_ELIMINATION_SETS_DFVGL_ELIMINATION_SETSDefine Elimination Set
GL_ENTITY_BUDGETS_DFVGL_ENTITY_BUDGETSEntity Budgets
GL_HISTORICAL_RATES_DFVGL_HISTORICAL_RATESHistorical Rates
GL_IEA_AUTOGEN_MAP_DFVGL_IEA_AUTOGEN_MAPAutoAccounting Rules
GL_IEA_CLEARING_ACCOUNTS_DFVGL_IEA_CLEARING_ACCOUNTSIntercompany/Interfund: Clearing Accounts
GL_IEA_RECUR_TRANSACTIONS_DFVGL_IEA_RECUR_TRANSACTIONSIntercompany/Interfund: Recurring Transactions
GL_IEA_SEGMENT_MAP_DFVGL_IEA_SEGMENT_MAPAutoAccounting Rules: Segment Action
GL_IEA_SEGMENT_RULE_MAP_DFVGL_IEA_SEGMENT_RULE_MAPAutoAccounting Rules: Segment Rules
GL_IEA_SUBSIDIARIES_DFVGL_IEA_SUBSIDIARIESIntercompany/Interfund: Subsidiaries
GL_IEA_TRANSACTIONS_DFVGL_IEA_TRANSACTIONSIntercompany/Interfund: Transactions
GL_IEA_TRANSACTION_LINES_DFVGL_IEA_TRANSACTION_LINESIntercompany/Interfund: Transaction Lines
GL_IEA_TRANSACTION_TYPES_DFVGL_IEA_TRANSACTION_TYPESIntercompany/Interfund: Transaction Types
GL_INTERCOMPANY_ACCOUNTS_DFVGL_INTERCOMPANY_ACCOUNTSIntercompany/Interfund: Accounts
GL_INTERCOMPANY_ACC_SETS_DFVGL_INTERCOMPANY_ACC_SETSIntercompany/Interfund: Source and Category
GL_JE_BATCHES_DFVGL_JE_BATCHESEnter Journals: Batches
GL_JE_CATEGORIES_TL_DFVGL_JE_CATEGORIESJournal Categories
GL_JE_HEADERS_DFVGL_JE_HEADERSEnter Journals: Journals
GL_JE_LINES_DFVGL_JE_LINESEnter Journals: Lines
GL_JE_LINES1_DFVGL_JE_LINES_TAXEnter Journals: Tax Information
GL_JE_SOURCES_TL_DFVGL_JE_SOURCESJournal Sources
GL_LOOKUPS_OLD_DFVGL_LOOKUPSLookup Codes
GL_MC_CONVERSION_RULES_DFVGL_MC_CONVERSION_RULESConversion Rules: Additional Info.
GL_MC_CONVERSION_RULES1_DFVGL_MC_CONVERSION_RULES_GBConversion Rules: Global Info
GL_MOVEMERGE_ACCOUNTS_DFVGL_MOVEMERGE_ACCOUNTSMass Maintenance Accounts
GL_MOVEMERGE_REQUESTS_DFVGL_MOVEMERGE_REQUESTSMass Maintenance Requests
GL_PERIODS_DFVGL_PERIODSAccounting Calendar: Periods
GL_PERIOD_STATUSES_DFVGL_PERIOD_STATUSESOpen and Close Periods
GL_PERIOD_TYPES_DFVGL_PERIOD_TYPESPeriod Types
GL_RECURRING_BATCHES_DFVGL_RECURRING_BATCHESDefine Recurring Journal: Batch
GL_RECURRING_LINES_DFVGL_RECURRING_LINESDefine Recurring Journal: Line
GL_RECURRING_LINE_CALC_RUL_DFVGL_RECURRING_LINE_CALC_RULESDefine Recurring Journal: Formula
GL_SETS_OF_BOOKS_DFVGL_SETS_OF_BOOKSSet of Books
GL_PERIOD_SETS_DFVGL_PERIOD_SETSAccounting Calendar: Calendar
GL_RECURRING_HEADERS_DFVGL_RECURRING_HEADERSDefine Recurring Journal: Journal Entry
GL_IEA_RECUR_LINES_DFVGL_IEA_RECUR_LINESIntercompany/Interfund: Recurring Lines
GL_ACCESS_SETS_DFVGL_ACCESS_SETSAccess Sets
GL_ACCESS_SET_NORM_ASSIGN_DFVGL_ACCESS_SET_NORM_ASSIGNAccess Set: Access Details
GL_AUTOREV_CRITERIA_SETS_DFVGL_AUTOREV_CRITERIA_SETSAutoReversal Criteria Set
GL_DEFAS_ACCESS_SETS_DFVGL_DEFAS_ACCESS_SETSDefinition Access Sets
GL_DEFAS_ASSIGNMENTS_DFVGL_DEFAS_ASSIGNMENTSDefinition Access Set: Access Details
GL_DEFAS_RESP_ASSIGN_DFVGL_DEFAS_RESP_ASSIGNResponsibility: Definition Access Sets
GL_LEDGERS_DFVGL_LEDGERSLedgers
GL_LEDGER_SETS_DFVGL_LEDGER_SETSLedger Sets
GL_LEDGER_SET_NORM_ASSIGN_DFVGL_LEDGER_SET_NORM_ASSIGNLedger Set: Ledger Assignments