.. if so i'll bye yer code !! or offer it exposure on a whiz project !! . ... or even a few pointers ? . ... starter for 10 ? . . :idea:

Neill . .Starter for 10: . .To the best of my knowledge the current list of standard OTA apis is: . .ota_nhs_api.create_non_ota_histories/ .update_non_ota_histories .ota_ocl_api.create_competence_language/.update_competence_language .ota_tcc_api.create_cross_charge/.update_cross_charge .ota_tdb_waitlist_api.auto_enroll_from_waitlist .ota_thg_api.create_hr_gl_flex/ .update_hr_gl_flex . .None are legislation-specific neither are they known to DataPump. . .I have something that will use the first of those. But it's what it says on the tin - no real connection with any true OTA functionality just a standalone repository for historical training records. . .BTW don't be fooled by the _nhs_ in the package name - it is a standard package! . .Clive . .PS Stewards' enquiry on your stated age innit???

Cheers .. . .A few of the base tables have been cut in half and the row level handles have disappeared for the category inc and versions etc - so we are looking for the replacement tables and on the prowl for the new row handlers. We can get anything to work in dp so thats not to much problem.. Current users in 5.9 get a concurrent program to migrate their data to 5.10 .. where can we buy one of those ? . .(it was suggested we migrate to 5.9 using current code then use the CP to move it to 5.10 ... HELP) . ... what we need is some serious technical knowledeg starting here really soon .. any suggestions ?

Not sure if it's still a problem these days but at the site of the well-known administrator of the nation's health we ran into some local difficulties with running ota_nhs_api via DP. We eventually traced the issue to some internal lame code that tried to validate the organization against a date-tracked view of the assignments table - the problem being of course that DP didn't set a session date hence it always failed to validate. So let that be a lesson to you young man...

...and so DP was hacked to set a row in fnd_sessions for each thread invoked. .It was a neat idea that completely failed to grab the attention of anyone in HRDev. .Best way to grab the updated row handlers is to pull apart the forms. Thats what i did eons ago for a well-known drugs company (before they merged with another well-known drugs company).

.. thanks for the info .. we can rebuild dp here too !! waiting on the functional lot again !! so we have loads of time to play ;-)

Did you really post this at 1:47 am???? Please tell me you weren't at work???