R12.13. : fnd_flex_ext.get_ccid having issues in custom schema

Hi,
We have created a custom schema "FDD" and trying to execute fnd_flex_ext.get_ccid command from it.

From FDD schema

select fdd.fnd_flex_ext.get_ccid('SQLGL','GL#',101,to_char(sysdate, 'DD-MON-YYYY'), '100.791500.00957.T999.0000.000.000.000.000.0000.0000.0000') CODECOMBINATIONID from sys.dual;

CODECOMBINATIONID
-----------------
                0


From APPS schema

select fdd.fnd_flex_ext.get_ccid('SQLGL','GL#',101,to_char(sysdate, 'DD-MON-YYYY'), '100.791500.00957.T999.0000.000.000.000.000.0000.0000.0000') CODECOMBINATIONID from sys.dual;

CODECOMBINATIONID
-----------------
           185609


I am not able to get what the issue is with FDD schema.  I have given all grants.   Please help.

Thanks
Ram