Adding if/then statement in attribute for extract definition
I have an employee extract that creates new users in a third party system when new hires added to HCM. One of the requirements is to pass the users reimbursement currency. Unfortunately there is no data point requirement within Oracle for reimbursement currency so I have no database item to grab it from. I need a way to do an if/then statement.
This is the way that attribute is currently configured. Unfortunately the USD is breaking all of our Canadian employees expense reports. I need to somehow get it to be USD or CAD based on what business unit the employee is a member of. Any assistance is greatly appreciated.