Get Started with Redwood: Oracle Cloud SCM and Purchasing
Format of value passed to HierarchyBuilder.getPrincipal for FinApInvoiceApproval
Summary:
Format of value passed to HierarchyBuilder.getPrincipal for FinApInvoiceApproval
Content (required):
A customer I support has a DFF on the AP Invoice Header called "Invoice Approver" held in ATTRIBUTE7.
The SQL used to generate the list of values for that DFF results in a number of differently formatted values which have ended up in the ATTRIBUTE7 column - such as (assuming the customer's email domain is example.com):
- joe.bloggs@example.com
- joanne.smith@example.com
- Jim.Halpert@example.com
- Michael.Scott
- 22334
In the rules for the AP Invoice "FinApInvoiceApproval" Approval Task, the Starting Participant is set as:
HierarchyBuilder.getPrincipal(Invoice Header.Descriptive Flexfield Attribute7,-1,"","")
0