tag:blogger.com,1999:blog-7046973884293068385.post6323089900590753095..comments2024-01-12T00:37:09.675-08:00Comments on Oracle HCM for YOU: Mass Loading Time into TimesheetJiju Vengalhttp://www.blogger.com/profile/15074963527904600326noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7046973884293068385.post-38865709997701847092010-06-08T23:31:20.082-07:002010-06-08T23:31:20.082-07:00Hi Jiju, Firstly I would like to thank you for the...Hi Jiju, Firstly I would like to thank you for the latest blogs and information on T&L modules. It hardly any resouces especially on the latest tools.<br /><br />We are on HCM 9.0 with tools release 8.49.20. I am using Application Engine and CI to populate PS_TL_RPTD_TIME record through peoplecode using delivered Component Interface named TL_RPTD_TIME_CI. I have tested cI in Application Designer to insert rows into target table. <br /><br />When I execute the application engine, I am getting below errors in the output file from Application Server.<br /><br />01.05.04 ..(XX_BITFCE.PrcsTL.ReadFile) (PeopleCode)<br />Instance must exist to set property {TL_RPTD_TIME_CI.EMPLID} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.EMPL_RCD} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.DUR} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.SEQ_NBR} (91,14)<br />This is an invalid property {TL_RPTD_TIME_CI.TRC} (91,11)<br />File: /vob/peopletools/src/psppr/ramupd.cppSQL error. Stmt #: 911 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_AUDIT_TLRPTTIME"."DUR") <br />Failed SQL stmt:INSERT INTO PS_AUDIT_TLRPTTIME(AUDIT_OPRID,AUDIT_STAMP,....:59,:60)<br />Error saving Component Interface. {TL_RPTD_TIME_CI} (91,37)<br /><br /><br /><br />I have written peoplecode using FileLayouts and to narrow down where the issue could be, I have written the simplest PC given below and still getting the above errors in logs though the program is going to success with no rows inserted. I have research forums and a few mentioned that security could be a reason and I added CI to the permission list, given full access to all the methods with no success. Any help is highly appreciated.<br /><br />Local ApiObject &MYSESSION;<br />Local ApiObject &MYCI;<br /><br /><br />&MYSESSION = %Session;<br />&MYCI = &MYSESSION.GetCompIntfc(CompIntfc.TL_RPTD_TIME_CI);<br />&MYCI.EMPLID = "00001244";<br />&MYCI.EMPL_RCD = 1;<br />&MYCI.DUR = "2010-05-20";<br />&MYCI.SEQ_NBR = 0;<br /><br /><br />&MYCI.Create();<br />&MYCI.TRC = "REG00";<br /><br />If Not (&MYCI.Save()) Then<br /> /* save didn’t complete */<br /> &COLL = &MYSESSION.PSMessages;<br /> For &I = 1 To &COLL.Count<br /> &ERROR = &COLL.Item(&I);<br /> &TEXT = &ERROR.Text;<br /> /* do error processing */<br /> End-For;<br /> &COLL.DeleteAll();<br />End-If;Maverick_1979https://www.blogger.com/profile/18181285326567462784noreply@blogger.comtag:blogger.com,1999:blog-7046973884293068385.post-57470844669523427542010-06-08T23:29:21.717-07:002010-06-08T23:29:21.717-07:00Hi Jiju, We are on HCM 9.0 with tools release 8.49...Hi Jiju, We are on HCM 9.0 with tools release 8.49.20. I am using Application Engine and CI to populate PS_TL_RPTD_TIME record through peoplecode using delivered Component Interface named TL_RPTD_TIME_CI. I have tested cI in Application Designer to insert rows into target table. <br /><br />When I execute the application engine, I am getting below errors in the output file from Application Server.<br /><br />01.05.04 ..(XX_BITFCE.PrcsTL.ReadFile) (PeopleCode)<br />Instance must exist to set property {TL_RPTD_TIME_CI.EMPLID} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.EMPL_RCD} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.DUR} (91,14)<br />Instance must exist to set property {TL_RPTD_TIME_CI.SEQ_NBR} (91,14)<br />This is an invalid property {TL_RPTD_TIME_CI.TRC} (91,11)<br />File: /vob/peopletools/src/psppr/ramupd.cppSQL error. Stmt #: 911 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_AUDIT_TLRPTTIME"."DUR") <br />Failed SQL stmt:INSERT INTO PS_AUDIT_TLRPTTIME(AUDIT_OPRID,AUDIT_STAMP,....:59,:60)<br />Error saving Component Interface. {TL_RPTD_TIME_CI} (91,37)<br /><br /><br /><br />I have written peoplecode using FileLayouts and to narrow down where the issue could be, I have written the simplest PC given below and still getting the above errors in logs though the program is going to success with no rows inserted. I have research forums and a few mentioned that security could be a reason and I added CI to the permission list, given full access to all the methods with no success. Any help is highly appreciated.<br /><br />Local ApiObject &MYSESSION;<br />Local ApiObject &MYCI;<br /><br /><br />&MYSESSION = %Session;<br />&MYCI = &MYSESSION.GetCompIntfc(CompIntfc.TL_RPTD_TIME_CI);<br />&MYCI.EMPLID = "00001244";<br />&MYCI.EMPL_RCD = 1;<br />&MYCI.DUR = "2010-05-20";<br />&MYCI.SEQ_NBR = 0;<br /><br /><br />&MYCI.Create();<br />&MYCI.TRC = "REG00";<br /><br />If Not (&MYCI.Save()) Then<br /> /* save didn’t complete */<br /> &COLL = &MYSESSION.PSMessages;<br /> For &I = 1 To &COLL.Count<br /> &ERROR = &COLL.Item(&I);<br /> &TEXT = &ERROR.Text;<br /> /* do error processing */<br /> End-For;<br /> &COLL.DeleteAll();<br />End-If;Maverick_1979https://www.blogger.com/profile/18181285326567462784noreply@blogger.com