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,"","")