OLM How to Update Classes Status

Is there An API To Update Scores Or to UPDATE/CREATE Records For OTA_ATTEMPTS, OTA_PERFORMANCES,OTA_TEST_QUESTIONS, OTA_QUESTION_BANKS, OTA_UTEST_RESPONSES, OTA_LO_FOLDERS, OTA_LEARNING_OBJECTS ? (Doc ID 406223.1)

Column LESSON_STATUS in table OTA_PERFORMANCES hold the player status value. Currently there are no publicly callable API's available the will permit a user to manually manipulate LESSON_STATUS. The only supported method for changing this value would require having the learner attempt and complete the learning object again though the Learner UI.

So We have to do direct base table update if this is feasible. I have done the direct base table update for one class and it worked fine.

select * from ota_activity_versions

where version_name like ‘Course Name’;-- course

select * from OTA_OFFERINGS

where activity_version_id=83037;-- offering

select * from ota_events

where activity_version_id=83037;-- class

select * from ota_learning_objects

where learning_object_id=81017;--learning objects

select * from OTA_DELEGATE_BOOKINGS

where event_id=108019

and delegate_contact_email='Jon.Hillegeist@taconic.com';--contains enrollments

select * from ota_performances

where lesson_status='P'

and user_id=22461

and   learning_object_id=81017; -- contains test results

select * from ota.ota_attempts

where event_id=108019

and  learning_object_id=81017

and user_id=22461

and attempt_id=217626

and attempt_status='F';-- contains attempt details for the test

update ota_performances

set lesson_status='P'

where performance_id=293169;

update ota_attempts set attempt_status='P'

where attempt_id=217626;

commit;