Thursday, October 19, 2006

Oracle Apps:Programmatically Compile a KFF View

Sometimes its required an API to call from our PL/SQL package to compile the KFV view in Apps.
request_id := fnd_request.submit_request('FND',
'FDFCMPK',
'Compiling Flexfield',
SYSDATE,
FALSE,
'K', -- Type of FF
, -- Application short name
p_ff_name, -- FF name
TO_CHAR(l_flex_num) -- ID_Flex_Num);

No comments: