Why 11i LOA Transactions (Submitted for Approval Before Migrating to R12) in R12 Are Not Routed For
It is observed that though a rule has been set up as expected with condition 'HR_IS_LEAVE_OF_ABSENCE_SS' as TRUE, the Real Test Transaction shows that
HR_IS_LEAVE_OF_ABSENCE_SS = FLASE and so NO rules get applied and hence the transactions are getting approved without further routing for approval for the next approvers.
Why is attribute HR_IS_LEAVE_OF_ABSENCE_SS returning FALSE?
The attribute HR_IS_LEAVE_OF_ABSENCE_SS is based on Dynamic SQL and the SQL is as below:
SELECT hr_ameutil_ss.isLOAChange(:transactionId) FROM DUAL;
An extract of the seeded function HR_AMEUTIL_SS.isLOAChange which derives the value for the attribute is as below: