Oracle Time and Labor Errors/Solutions

Errors/Solutions:

 Error 1:  An error has been generated because worker information has not been found.

Solution: While debugging this error I found that my user (FND_USER) did not have any employee attached to this. Once I attached a employee for the user this error got resolved. There are other reasons for this error.

Please refer Oracle Metalink Doc ID : 338340.1 for further details on this error.

 

Error 2:  20001 ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE, pay_hr_otc_retrieval_interface.extract_data_from_attr_tbl, N, STEP, tbb mismatch

This error occurs when we tried to transfer OTL to BEE where the concurrent program completes successfully but BEE will not been created.

Solution: Apply patch to resolve this error.Refer Oracle Metalink Bug No. 4180521 and Bug No. 5850046

 Before applying the patch: In seeded package hxt_interface_utilities the code should look like this

 TYPE flex_value_table IS TABLE OF flex_value_rec

      INDEX BY BINARY_INTEGER;

 

After applying the patch: In seeded package hxt_interface_utilities the code should look like this

TYPE flex_value_table IS TABLE OF flex_value_rec

      INDEX BY VARCHAR2(255);

 After applying patch I tried to transfer Time card from OTL to BEE, it got transferred successfully.