Performance Issue in API fnd_flex_ext.get_ccid

HI,

Ebs Version: 12.2.5

DB Version: 12c

We are trying to create code combinations using API fnd_flex_ext.get_ccid. Below is the code snippet we are using to call the API. The API takes so much time to complete, approximately 2 seconds for each record. This is causing performance issue in our code to process large amount of data.

c_combination_id := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL'

                                                            , key_flex_code          => 'GL#'

                                                            , structure_number       => i_structure_number

                                                            , validation_date        => to_char(SYSDATE, fnd_flex_ext.date_format)

                                                            , concatenated_segments  => i_concatenated_segments);

Please let us know if there is any resolution for this.