You are browsing the archive for Setups.

General Ledger Profile Options

Oracle General Ledger module profile options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
GLDI_AHE_SAVING_ALLOWED GL AHE: Saving Allowed
GL_ACCESS_SET_ID GL: Data Access Set
GL_ACCOUNTS_TO_PROCESS GL: Number of Accounts In Memory
GL_ADI_VIEWER GL : Default Desktop Viewer
GL_ALLOC_NUMBER_OF_FORMULAS_TO_VALIDATE GL: Number of formulas to validate for each MassAllocation batch
GL_GLCCON_PRESERVE_JE_DATE GL Consolidation: Preserve Journal Effective Date
GL_GLLEZL_ARCHIVE_ROWS GL: Archive Journal Import Data
GL_ITG_ADJUSTMENT_PD GL OFSA: Adjustment Period Data in Last Fiscal Period
GL_ITG_CURRENCY_TYPE_CODE GL OFSA: Transfer All Currency Types
GL_ITG_DAILY_CONVERSION_TYPES GL OFSA: Conversion Rate Type for OFSA Source Transactions
GL_ITG_OFSA_LEAF_INSERT GL OFSA: Automatically Create OFSA Leaf Values
GL_ITG_SOURCE_CURRENCY_CODE GL OFSA: Include Source Currency Code in Transfer
GL_ITG_SPECIAL_CURRENCY_CODE GL OFSA: Special Functional Currency Code
GL_RECORDS_TO_PROCESS GL: Number of Records to Process at Once
GL_RJE_NUMBER_OF_FORMULAS_TO_VALIDATE GL: Number of formulas to validate for each Recurring Journal batch
GL_MRC_IS_CONVERSION_TYPE GL/MRC: Income Statement Conversion Type
GL_MRC_OVERRIDE_HIST_AMT GL/MRC: Historical Amount Segment
GL_MRC_OVERRIDE_HIST_RATE GL/MRC: Historical Rate Segment
GL_MRC_REPT_SOB_WITH_OVERRIDE GL/MRC: Reporting Currency using Overriding Historical Rates/Amounts
GL_MRC_SPAWN_POSTING GL/MRC: Post Reporting Journals Automatically
GL_VALIDATE_REFERENCE_DATE Enter Journals: Validate Reference Date
GLDI_ANALYSIS_PRIVS GLDI: Analysis Wizard Privileges
GLDI_AHE_PRIVS GLDI: AHE Privileges
ADI_WHEN_SYSADMIN_OUTPUT_VIEW ADI: Allow Sysadmin to View all Output
GLDI_MAX_EFFECT_RANGE_DRILL GLDI: Maximum Effective Ranges for Drilldown
GLDI_BALANCE_ACCOUNTING_DATE GLDI: Balance by Accounting Date
GLDI_FORCE_FULL_VALIDATION GLDI: Force Full Validation
GLDI_CREATE_GROUP_ID GLDI: Create Group ID
ADI_USE_FUNCTIONAL_SECURITY ADI: Use Function Security
GLDI_FORCE_JOURNAL_BALANCE GLDI: Force Journal to Balance
GLDI_JOURNAL_SOURCE GLDI: Journal Source
GLDI_CONVERTED_ENTRY_THRESHOLD GLDI: Converted Entry Threshold
GL_GLPPOS_AVGBAL_POST_WORKERS GL: Number of Average Balance Post Workers
GLDI_ALLOW_DRILL_ACROSS_BOOKS GLDI: Allow Drill Across Ledgers
GL_JAHE_DB_HOST GL AHM: Database Host
GL_GLCCON_FILTER_BY_CATEGORY GL Consolidation: Exclude Journal Category During Transfer
GL_JAHE_DB_PORT GL AHM: Database Port
GL_GLCCON_PRESERVE_JE GL Consolidation: Preserve Journal Batching
FNDNAM GL AHM: FND Schema Name
GL_JAHE_SAVING_ALLOWED GL AHM: Allow Users to Modify Hierarchy
GL_JAHE_MAX_FETCH_SIZE GL AHM: Maximum Items Displayed At a Time
GL_SUMMARY_USE_OLD_OPT_METHOD GL Journals: Use Alternative Optimization Method For Summarization
GL_GLCCIT_EMAIL_CONTACT GL Consolidation: Cross Instance Workflow Notification Contact
GL_STD_ANALYSIS_REPORT_BALANCE_SECURITY GL Account Analysis Report: Enable Segment Value Security on Beginning/Ending Balances
INTERFUND GL:Create Interfund Entries
ATTRIBUTE_REPORTING FSG:Enable Attribute Reporting
ACCOUNT_CATEGORY_BALANCING GL:Enforce Account Category Balancing
CREATE_BUDGETARY_ENCUMBRANCES GL:Create Encumbrance Entries for Budgetary Accounts
USSGL_OPTION Enable Transaction Code
GL_MRC_INHERIT_CREATED_BY GL/MRC: Inherit the creation user for the reporting currency’s journal from the primary ledger’s journal
GL_REVENUE_EXPENSE_TRANSLATION_RULE GL Translation: Revenue/Expense Translation Rule
GL_REVAL_MAX_DAYS_TO_ROLL_RATE GL Revaluation: Days to Roll Forward Daily Rates
GL_DEBUG_MODE GL: Debug Mode
GL_AUTO_ALLOC_CONTINUE_NEXT_STEP GL AutoAllocation: Continue to Next Step if No Journal Created
GL_REVAL_VALIDATE_GAINLOSS GL Revaluation: Validate Gain/Loss Accounts
GL_CRM_CR_OVERRIDE GL Daily Rates: Cross Rates Override
GL_REVAL_MRC_FROM_PRIMARY_CURRENCY GL/MRC Revaluation: Use Primary Book Currency Instead of Entered Currency
GL_GLCCON_SPLIT GL Consolidation: Separate rows for debit and credit account balances in consolidation journal
GL_MJE_FIND_WINDOW_STATE GL Journals: Last Find Window State
GL_JI_ALWAYS_GROUP_BY_DATE GL Journal Import: Separate Journals by Accounting Date
GL_REVERSE_TC_OPTION GL: Reverse Transaction Codes on Un-natural Balances
BUDGETARY_CONTROL_OPTION Budgetary Control Group
DISPLAY_INVERSE_RATE Journals: Display Inverse Rate
GLDI_ALLOW_DRILLDOWN_ACROSS_BOOKS GLDI: Allow Drilldown Across Ledgers
GLDI_AUTOCOPY_ENF_LEVEL GLDI: Autocopy Enforcement Level
GLDI_BUDGET_WIZ_PRIVS GLDI: Budget Wizard Privileges
GLDI_BUD_WIZ_SEG_VAL_SECURITY GLDI: Enforce Budget Wizard Segment Security
GLDI_JOURNAL_WIZ_PRIVS GLDI: Journal Wizard Privileges
GLDI_REPORT_WIZ_PRIVS GLDI: Report Wizard Privileges
GL_AHE_SAVING_ALLOWED GL AHE: Saving Allowed (Obsolete)
GL_ALLOW_NON_BUSINESS_DAY Journals: Allow Non-Business Day Transactions
GL_ALLOW_PREPARER_APPROVAL Journals: Allow Preparer Approval
GL_ALLOW_USER_RATE_BETWEEN_EMU_AND_NONEMU Currency: Allow Direct EMU/Non-EMU User Rates
GL_AUTOREV_AFTER_OPEN_PERIOD GL: Launch AutoReverse After Open Period
GL_AUTO_ALLOC_ROLLBACK_ALLOWED GL: Auto Allocation Rollback Allowed
GL_DAILY_RATES_ENFORCE_INVERSE Daily Rates Window: Enforce Inverse Relationship During Entry
GL_DEBUG_LOG_DIRECTORY GL: Debug Log Directory
GL_DEFAULT_JE_CATEGORY Journals: Default Category
GL_DUAL_CURRENCY Dual Currency
GL_DUAL_DEFAULT_RATE_TYPE Dual Currency Default Rate Type
GL_ENABLE_PRIOR_PERIOD_NOTIFICATION Journals: Enable Prior Period Notification
GL_FIND_APPROVER_METHOD Journals: Find Approver Method
GL_GLCCON_OPTM_FACTOR GL Consolidation: Optimizer Factor
GL_GLPURGE_JE_SET_SIZE GL: Journal Entry Purge Set Size
GL_GLPURGE_LINE_SET_SIZE GL: Journal Line Purge Set Size
GL_GLSTPM_OPTM_FACTOR Summarization: Optimizer Factor
GL_IEA_PROTECT_NATURAL_ACCT Intercompany/Interfund: Protect Receiver Natural Account
GL_IEA_SUBSIDIARY_ID Intercompany/Interfund: Subsidiary
GL_IEA_USE_AUTO_TRANS_NUM Intercompany/Interfund: Use Automatic Transaction Numbering
GL_JRNL_REVW_REQUIRED GL: Journal Review Required
GL_NUMBER_OF_PURGE_WORKERS GL: Number of Purge Workers
GL_OVERRIDE_REVERSAL_OPTION Journals: Override Reversal Method
GL_OWNERS_EQUITY_TRANSLATION_RULE GL: Owner’s Equity Translation Rule
GL_REVAL_INC_ACC_RULE GL: Income Statement Accounts Revaluation Rule
GL_REVAL_USE_LAST_RANGE GL Revaluation: AutoQuery Last Run Ranges
GL_SET_OF_BKS_ID GL Ledger ID
GL_SET_OF_BKS_NAME GL Ledger Name
GL_SUMMARY_ACCT_SET_SIZE GL Summarization: Accounts Processed at a Time Per Delete Worker
GL_SUMMARY_DEL_WORKERS GL Summarization: Number of Delete Workers
GL_SUMMARY_MAINTAIN_FACTOR GL Summarization: Maintenance Index Selection Factor
GL_SUMMARY_ROWS_PER_COMMIT GL Summarization: Rows Deleted Per Commit
POP_UP_STAT_ACCOUNT Journals: Mix Statistical and Monetary
USE_PERFORMANCE_MODULE Use Performance Module
MRC_MAX_DAYS_TO_ROLL_RATE MRC: Maximum Days to Roll Forward Conversion Rate
MULTIPLE_RATES_PER_JE Journals: Allow Multiple Exchange Rates
GL_REVAL_BAL_BY_COST_CENTER GL Revaluation: Tracking by Cost Center
GL_MRC_BS_CONVERSION_TYPE GL/MRC: Balance Sheet Conversion Type

General Ledger Descriptive Flex Fields

Oracle General Ledger module DFF list

DFF View DFF CODE NAME DFF name
GL_SHARES_ACTIVITY_DFV GL_SHARES_ACTIVITY Common Stocks: Share Activity
GL_SHARES_OUTSTANDING_DFV GL_SHARES_OUTSTANDING Common Stocks: Outstanding Shares
GL_SUMMARY_TEMPLATES_DFV GL_SUMMARY_TEMPLATES Summary Accounts
GL_SUSPENSE_ACCOUNTS_DFV GL_SUSPENSE_ACCOUNTS Suspense Accounts
GL_TAX_CODES_DFV GL_TAX_CODES Enter Journals: Value Added Tax
GL_TAX_OPTIONS_DFV GL_TAX_OPTIONS Tax Options
GL_TAX_OPTION_ACCOUNTS_DFV GL_TAX_OPTION_ACCOUNTS Tax Options: Accounts
GL_TEMPORARY_COMBINATIONS_DFV GL_TEMPORARY_COMBINATIONS Temporary Combinations
GL_TRANSACTION_CALENDAR_DFV GL_TRANSACTION_CALENDAR Transaction Calendar
GL_TRANSACTION_DATES_DFV GL_TRANSACTION_DATES Transaction Dates
GL_TRANSACTION_RATE_EXCEPT_DFV GL_TRANSACTION_RATE_EXCEPTIONS Transaction Rate Exceptions
GL_TRANSLATION_RATES_DFV GL_TRANSLATION_RATES Period Rates
GL_USSGL_ACCOUNT_PAIRS_DFV GL_USSGL_ACCOUNT_PAIRS Government Trans Codes: Account Pairs
GL_USSGL_TRANSACTION_CODES_DFV GL_USSGL_TRANSACTION_CODES Government Transaction Codes: Code
GL_WEIGHTED_AVG_DETAILS_DFV GL_WEIGHTED_AVG_DETAILS Weighted Average Details
GL_JE_HEADERS1_DFV HEADERS_USSGL_TRANSACTION_CODE Enter Journals: Journal Transaction Code
GL_JE_LINES2_DFV LINES_USSGL_TRANSACTION_CODE Enter Journals: Line Transaction Code
GL_REVALUATIONS_DFV GL_REVALUATIONS Revaluations
GL_REVAL_ACCOUNT_RANGES_DFV GL_REVAL_ACCOUNT_RANGES Revaluations: Account Ranges
GL_JE_BATCHES1_DFV BATCH_USSGL_TRANSACTION_CODE Enter Journals: Batch Transaction Code
GL_AUTO_ALLOC_BATCHES_DFV GL_ALLOCATION_BATCHES AutoAllocation Batch
GL_AUTO_ALLOC_SETS_DFV GL_ALLOCATION_SETS Define AutoAllocation Set
GL_AUTHORIZATION_LIMITS_DFV GL_AUTHORIZATION_LIMITS Journal Authorization Limits
GL_AUTOMATIC_POSTING_OPTIO_DFV GL_AUTOMATIC_POSTING_OPTIONS AutoPost Criteria
GL_AUTOMATIC_POSTING_SETS_DFV GL_AUTOMATIC_POSTING_SETS Automatic Posting Sets
GL_AUTOREVERSE_OPTIONS_DFV GL_AUTOREVERSE_OPTIONS AutoReversal Criteria
GL_BC_OPTIONS_DFV GL_BC_OPTIONS Budgetary Control Group: Group
GL_BC_OPTION_DETAILS_DFV GL_BC_OPTION_DETAILS Budgetary Control Group: Rules
GL_BUDGETS_DFV GL_BUDGETS Define Budget
GL_BUDGET_ASSIGNMENTS_DFV GL_BUDGET_ASSIGNMENTS Define Budget Organization: Assignments
GL_BUDGET_ASSIGNMENT_RANGE_DFV GL_BUDGET_ASSIGNMENT_RANGES Define Budget Org: Assignment Ranges
GL_BUDGET_ENTITIES_DFV GL_BUDGET_ENTITIES Define Budget Organization: Organization
GL_BUDGET_TYPES_DFV GL_BUDGET_TYPES Budget Types
GL_BUDGET_VERSIONS_DFV GL_BUDGET_VERSIONS Budget Versions
GL_CAPTURED_INFO_DFV GL_CAPTURED_INFO Enter Journals: Captured Information
GL_CODE_COMBINATIONS_DFV GL_CODE_COMBINATIONS GL Accounts
GL_CONCURRENT_SCHEDULES_DFV GL_CONCURRENT_SCHEDULES Define Submission Schedules
GL_DAILY_CONVERSION_RATES_DFV GL_DAILY_CONVERSION_RATES Daily Conversion Rates
GL_DAILY_CONVERSION_TYPES_DFV GL_DAILY_CONVERSION_TYPES Conversion Rate Types
GL_DAILY_RATES_DFV GL_DAILY_RATES Daily Rates
GL_ELIM_ACCOUNTS_MAP_DFV GL_ELIMINATION_ACCOUNTS Elimination Accounts
GL_ELIMINATION_JOURNALS_DFV GL_ELIMINATION_JOURNALS Elimination Journal
GL_ELIMINATION_SETS_DFV GL_ELIMINATION_SETS Define Elimination Set
GL_ENTITY_BUDGETS_DFV GL_ENTITY_BUDGETS Entity Budgets
GL_HISTORICAL_RATES_DFV GL_HISTORICAL_RATES Historical Rates
GL_IEA_AUTOGEN_MAP_DFV GL_IEA_AUTOGEN_MAP AutoAccounting Rules
GL_IEA_CLEARING_ACCOUNTS_DFV GL_IEA_CLEARING_ACCOUNTS Intercompany/Interfund: Clearing Accounts
GL_IEA_RECUR_TRANSACTIONS_DFV GL_IEA_RECUR_TRANSACTIONS Intercompany/Interfund: Recurring Transactions
GL_IEA_SEGMENT_MAP_DFV GL_IEA_SEGMENT_MAP AutoAccounting Rules: Segment Action
GL_IEA_SEGMENT_RULE_MAP_DFV GL_IEA_SEGMENT_RULE_MAP AutoAccounting Rules: Segment Rules
GL_IEA_SUBSIDIARIES_DFV GL_IEA_SUBSIDIARIES Intercompany/Interfund: Subsidiaries
GL_IEA_TRANSACTIONS_DFV GL_IEA_TRANSACTIONS Intercompany/Interfund: Transactions
GL_IEA_TRANSACTION_LINES_DFV GL_IEA_TRANSACTION_LINES Intercompany/Interfund: Transaction Lines
GL_IEA_TRANSACTION_TYPES_DFV GL_IEA_TRANSACTION_TYPES Intercompany/Interfund: Transaction Types
GL_INTERCOMPANY_ACCOUNTS_DFV GL_INTERCOMPANY_ACCOUNTS Intercompany/Interfund: Accounts
GL_INTERCOMPANY_ACC_SETS_DFV GL_INTERCOMPANY_ACC_SETS Intercompany/Interfund: Source and Category
GL_JE_BATCHES_DFV GL_JE_BATCHES Enter Journals: Batches
GL_JE_CATEGORIES_TL_DFV GL_JE_CATEGORIES Journal Categories
GL_JE_HEADERS_DFV GL_JE_HEADERS Enter Journals: Journals
GL_JE_LINES_DFV GL_JE_LINES Enter Journals: Lines
GL_JE_LINES1_DFV GL_JE_LINES_TAX Enter Journals: Tax Information
GL_JE_SOURCES_TL_DFV GL_JE_SOURCES Journal Sources
GL_LOOKUPS_OLD_DFV GL_LOOKUPS Lookup Codes
GL_MC_CONVERSION_RULES_DFV GL_MC_CONVERSION_RULES Conversion Rules: Additional Info.
GL_MC_CONVERSION_RULES1_DFV GL_MC_CONVERSION_RULES_GB Conversion Rules: Global Info
GL_MOVEMERGE_ACCOUNTS_DFV GL_MOVEMERGE_ACCOUNTS Mass Maintenance Accounts
GL_MOVEMERGE_REQUESTS_DFV GL_MOVEMERGE_REQUESTS Mass Maintenance Requests
GL_PERIODS_DFV GL_PERIODS Accounting Calendar: Periods
GL_PERIOD_STATUSES_DFV GL_PERIOD_STATUSES Open and Close Periods
GL_PERIOD_TYPES_DFV GL_PERIOD_TYPES Period Types
GL_RECURRING_BATCHES_DFV GL_RECURRING_BATCHES Define Recurring Journal: Batch
GL_RECURRING_LINES_DFV GL_RECURRING_LINES Define Recurring Journal: Line
GL_RECURRING_LINE_CALC_RUL_DFV GL_RECURRING_LINE_CALC_RULES Define Recurring Journal: Formula
GL_SETS_OF_BOOKS_DFV GL_SETS_OF_BOOKS Set of Books
GL_PERIOD_SETS_DFV GL_PERIOD_SETS Accounting Calendar: Calendar
GL_RECURRING_HEADERS_DFV GL_RECURRING_HEADERS Define Recurring Journal: Journal Entry
GL_IEA_RECUR_LINES_DFV GL_IEA_RECUR_LINES Intercompany/Interfund: Recurring Lines
GL_ACCESS_SETS_DFV GL_ACCESS_SETS Access Sets
GL_ACCESS_SET_NORM_ASSIGN_DFV GL_ACCESS_SET_NORM_ASSIGN Access Set: Access Details
GL_AUTOREV_CRITERIA_SETS_DFV GL_AUTOREV_CRITERIA_SETS AutoReversal Criteria Set
GL_DEFAS_ACCESS_SETS_DFV GL_DEFAS_ACCESS_SETS Definition Access Sets
GL_DEFAS_ASSIGNMENTS_DFV GL_DEFAS_ASSIGNMENTS Definition Access Set: Access Details
GL_DEFAS_RESP_ASSIGN_DFV GL_DEFAS_RESP_ASSIGN Responsibility: Definition Access Sets
GL_LEDGERS_DFV GL_LEDGERS Ledgers
GL_LEDGER_SETS_DFV GL_LEDGER_SETS Ledger Sets
GL_LEDGER_SET_NORM_ASSIGN_DFV GL_LEDGER_SET_NORM_ASSIGN Ledger Set: Ledger Assignments