How to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTS

Summary:

We need to be able to join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTS

Content (required):

Hi team,

We currently have a report to extract Paid Invoices where we gather various fields.

In order to capture some fields we had to left outer join AP_INVOICES_ALL with FND_ATTACHED_DOCUMENTS on INVOICE_ID=PK1_VALUE.

This report worked well until recently there were alphanumeric values populated in PK1_VALUE field.

We are repeatedly getting the error "Invalid Number".

When we queried for which ENTITY_NAME from FND_ATTACHED_DOCUMENTS alphanumeric values were populated it was for 'FND_BPM_TASK_ATTACHMENTS'