Home / Configurations-GL

Configurations-GL

Query To find the details of the Accounting Flexfield structure

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             WHEN fvs.validation_type = ‘F’ THEN fvt.application_table_name             ELSE ‘Not Applicable’           END )          validation_table_name  FROM   gl_ledgers gls,         fnd_id_flex_segments idfs,         fnd_flex_value_sets fvs,         fnd_flex_validation_tables fvt  WHERE  gls.chart_of_accounts_id (+) = idfs.id_flex_num         AND fvs.flex_value_set_id = idfs.flex_value_set_id         AND gls.ledger_id = &ledgerid  …

Read More »

Oracle financials interface tables

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 (AP) Interface Tables AP_INTERFACE_CONTROLS AP_INTERFACE_REJECTIONS AP_INVOICE_INTERFACE AP_INVOICE_LINES_INTERFACE OIE_POL_RATES_INTERFACE   Account …

Read More »