What's new in Customer Journeys?

Connect and learn more! ×
DelegateExpense ReportDFF(Default Value) not populating based on the Owner but based on Creator — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DelegateExpense ReportDFF(Default Value) not populating based on the Owner but based on Creator

Received Response
13
Views
1
Comments
edited Oct 17, 2023 4:32PM in Expenses 1 comment

Summary: we Created DFF(Based on Default - SQL) to default the Supervisor based on the Expense report owner.

Content (required):

e.g User A - Expense Report Owner , User B - Delegate(creating expense report on behalf of UserA)

User C - Supervisor of User A, User D - Supervisor of User B.

Scenario: UserB is creating Expense report on behalf of User A, expectation is to have the DFF Supervisor name of User A which is UserC.

we used the FND_GLOBAL.USER_GUID variable to get the Expense report user id to be used in Default SQL Query(attached), such that userid is mapped to userid variable in query and derived the Supervisore name value. this works as expected when the creator is same as the Expense report owner, but when delegates created the Proxy Expense report, the DFF is defaulting the supervisor name of the Creator(User D )rather than Owner Supervisor of Expense report User C.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!