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

Last updated on MARCH 07, 2023

Applies to:

Symptoms

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: 

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

  ln_ccid := fnd_flex_ext.get_ccid('SQLGL',
                                   'GL#',
                                   xxxxx,
                                   to_char(SYSDATE, 'YYYY-MM-DD'),
                                   'xxx.xxxx.xxxxx.xxxx.xxx.xxxxx.xxxxx');

  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.

Cause

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