Tech Trainings

Oracle Cloud ERP -Fusion (SaaS) – Key FlexField (KFF) Creation and Query to extract

September 7, 2020 by admin

Steps to Create/View

1. In the Setup and Maintenance work area, go to:
   • Task: Manage Key Flexfields

--COA Structure Details
SELECT 
fksb.STRUCTURE_ID, KEY_FLEXFIELD_CODE,
fksb.STRucTuRe_CODE, DELIMITER
FROM FND_KF_STRUCTURES_B fksb
WHERE 1=1
and fksb.KEY_FLEXFIELD_CODE  ='GL#'

--COA Segment Details – for GL 

SELECT 
fkseg.segment_code, fkseg.segment_identifier, fkseg.column_name,
fkseg.default_value_set_id, fkseg.sequence_number,
fksb.STRUCTURE_ID, KEY_FLEXFIELD_CODE,
fksb.STRucTuRe_CODE, DELIMITER
FROM FND_KF_STRUCTURES_B fksb , FND_KF_SEGMENTS_B fkseg
WHERE 1=1
and fkseg.structure_id = fksb.structure_id
and fksb.KEY_FLEXFIELD_CODE  ='GL#'
--and fkseg.structure_id =101
ORDER BY fkseg.sequence_number

Comments |0|