General Ledger - EBS (MOSC)

MOSC Banner

API to Validate accounts and Cross Validation Rules

edited Jan 28, 2013 11:06PM in General Ledger - EBS (MOSC) 3 commentsAnswered
Hello

I was wondering how does the API fnd_flex.get_ccid works, hence I was wondering whether you can share with me any example.

I have just the following information

You should code it like this:
ccid := FND_FLEX_EXT.GET_CCID
( 'SQLGL'
, 'GL#'
, '50332'
, fnd_date.date_to_canonical(SYSDATE)
, '<your vsegs'
);

Another example

DECLARE
-- pragma autonomous_transaction; -- if you need autonomy!
p_concat_segs VARCHAR2(1000) := '09411.96042.81000000.4230.00000.00000.0000';
l_keyval_status BOOLEAN;
l_coa_id NUMBER;
begin
begin
select chart_of_accounts_id
into l_coa_id
from gl_sets_of_books
where set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center