top of page



Oracle Fusion Query to get GL Segment values

SELECT segvalsets.value_set_code , value , segvals.description , enabled_flag , start_date_active , end_date_active , summary_flag , flex_value_attribute1 AS POSTING_ALLOWED , flex_value_attribute2 AS BUDGETING_ALLOWED , flex_value_attribute3 AS ACCOUNT_TYPE , flex_value_attribute4 AS CONTROL_ACCOUNT , flex_value_attribute5 AS RECONCILIATION_FLAG, flex_value_attribute6 AS FINANCIAL_CATEGORY FROM fusion.fnd_vs_values_vl segvals, fusion.fnd_vs_value_sets segvalsets WHERE segvals.value_set_id = segvalsets.value_Set_id AND segvalsets.value_Set_id IN (SELECT value_set_id FROM FUSION.fnd_kf_segment_instances WHERE structure_instance_id IN (SELECT fusion.fnd_kf_str_instances_b.structure_instance_id FROM FUSION.fnd_kf_str_instances_b WHERE application_id =101 AND key_flexfield_code = 'GL#' ) )

205 views0 comments

Recent Posts

See All

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested 

bottom of page