Configurations-GL

November 3, 2017 An Introduction to Financial Statement Generator (FSG)

Configurations-GLGeneral LedgerOracle Functional

An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) is a powerful reporting engine…

October 10, 2017 Query To find the details of the Accounting Flexfield structure

AppsDBA ScriptsConfigurations-GLScripts

SELECT gls.name, idfs.id_flex_num chart_of_accounts_id, idfs.segment_num, idfs.flex_value_set_id, fvs.flex_value_set_name, idfs.application_id, idfs.id_flex_code, idfs.application_column_name, idfs.segment_name, fvs.security_enabled_flag, ( CASE WHEN fvs.validation_type = ‘F’ THEN ‘Table’ WHEN fvs.validation_type = ‘I’ THEN ‘Independent’ WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’ WHEN fvs.validation_type = ‘N’ THEN ‘None’ WHEN fvs.validation_type = ‘P’ THEN ‘Pair’ WHEN fvs.validation_type = ‘U’ THEN ‘Special’ ELSE ‘Unknown Type’ END ) validation_type, ( CASE …

August 1, 2017 Oracle financials interface tables

Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts

General Ledger Interface Tables GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_DRM_HIERARCHY_INTERFACE GL_DRM_SEGVALUES_INTERFACE GL_IMP_COA_ERR_INTERFACE GL_IMP_COA_NORM_HIER_INTERFACE GL_IMP_COA_SEG_VAL_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY GL_REPORT_INTERFACE GL_XFR_INTERFACE Account Payables…

July 1, 2017 General Ledger (GL) Journals Profile Options

Configurations-GLGeneral LedgerOracle Functional

General Ledger (GL) Journals Profile Options Journals: Allow Multiple Exchange Rates Controls whether to allow multiple conversion rates…