My Oracle Support Banner

API Fnd_flex_ext.get_ccid Returns 0 for a valid combination (Doc ID 1488394.1)

Last updated on MARCH 07, 2023

Applies to:

Oracle Application Object Library - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


Write a script to call API Fnd_flex_ext.get_ccid to get the CCID. Before calling the API, call fnd_global.APPS_INITIALIZE to initialize the context in the script.

For example: 

  fnd_global.apps_initialize(resp_appl_id => 101,
                             resp_id      => xxxxx,
                             user_id      => xxx);

  ln_ccid := fnd_flex_ext.get_ccid('SQLGL',
                                   to_char(SYSDATE, 'YYYY-MM-DD'),

  dbms_output.put_line(ln_ccid || ' - ' || fnd_flex_ext.get_message);

The result of this script is 0 even it is a valid combination. If comment out the function " fnd_global.apps_initialize", the script can return the valid result. The message is "Value Secured: <custom error message>. Line " dbms_output.put_line(ln_ccid || ' - ' || fnd_flex_ext.get_message);" was added just for debugging purposes to determine the real message the api fnd_flex_ext.get_ccid was returning.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.