How to create a lookup table to be used in BPM rules
Summary:
We have our AP Invoice approval rules setup in BPM. Our requirement is to determine approvers based on a lookup table for examples -
First get the cost center from line distribution. Then check
if cost center is 123 and BU is 456789 then it should go to Approver A
if cost center is 125 and BU is 789123 then it should go to Approver B
etc..
Here, BU is not available in fusion. Hence we cannot directly fetch it using BPM attribute. So, we would need to create and maintain this lookup table but I am not sure where?
Can someone please suggest or recommend - where should we create and maintain such lookup tables which we can use in our BPM rules?