I had seen in many projects during the initial instance setup the functionals used to use the data loader to insert the GL code combinations. In fact if its just 1000 or 2000 records then it may be fine. But I had seen them using the data-loader to insert 70k – 200k records, which will take at-least 2 days for them to insert. Apart from this there will be some value set values might be missing which will interrupt there data loader.
Even I had come across this situation in one of my previous project. I have been asked to insert 100k code combinations using the data loader. First I tried data loader only. It took 3 hrs to insert 3k records
But finally I decided to write an API which will insert all these code combinations in 5-10 mins. Then I get to know this API fnd_flex_keyval.validate_segs.
This API will return a boolean value ‘TRUE’ or ‘FALSE’. This API is there in R12 instance also. Here is the sample call to this API which I used in my code,
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’);
l_keyval_status := fnd_flex_keyval.validate_segs (’CREATE_COMBINATION’, ‘SQLGL’, ‘GL#’, l_coa_id, gl_code_rec.concatenated_segments, ‘V’, SYSDATE, ‘ALL’, NULL, NULL, NULL, NULL, FALSE, FALSE, NULL, NULL,NULL );
About the Author | |
 |
AK Lakshmanan
Lakshmanan Ashok Kumar is an oracle EBS technical enthusiastic. He has hands full of experience on Oracle forms, reports, and BI Desktop Publisher. Otherwise Lakshmanan Ashok Kumar is also a Techno Functional person in Order 2 Cash and Manufacturing modules. We are glad to have Lakshmanan's thoughts and views of various oracle EBS stand and hope you enjoy his posts. |
Tags: api to insert code combination, fnd_flex_keyval.validate_segs, gl_code_combination
The latest Doodle:
|
