Human Capital Management - EBS (MOSC)

MOSC Banner

HR Allocated Checklists - How to get the transactionID for AME

edited May 6, 2015 12:54PM in Human Capital Management - EBS (MOSC) 1 commentAnswered ✓

Hi,

I have configured HR Allocated Checklists and it is working fine. I have also configured AME rules to assign task owners. I would like to know how is the :transactionId generated for Checklist ? In which table can I find it ?

For SSHR transaction, the transactionId is from hr_api_transactions table.

So for the Allocated Checklist, from where does it get the transaction id?

The CHECKLIST ATTRIBUTE has the following query -

SELECT AME_ATTRIBUTE_IDENTIFIER FROM PER_TASKS_IN_CHECKLIST WHERE task_in_checklist_id= substr(:transactionId,1,instr(:transactionId,'-')-1)

I would like to know from where does this transactionId come from? How is it generated ? In which table is it stored?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center