API Fnd_flex_ext.get_ccid Returns 0 for a valid combination

(Doc ID 1488394.1)

Last updated on NOVEMBER 08, 2017

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.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms