Receivable Specialists Join to Receipt Header

Question

When we try to tie the specialist to the receipt we can’t seem to get past the receipt having multiple specialist coming creating additional rows on the BIP Report. We have gotten the number of multiple row returns down but there is still something restricting us from linking the receipt number to the specialist. There are several receivable specialist tables that have a direct linkage to the receipt but they all come in NULL for us. Can anyone provide the specifications/tables on how the specialist was linked to the receipt header?

We have tried:

Joining the AR_COLLECTORS table NAME field to the AR_CASH_RECEIPTS_ALL

Joining the AR_COLLECTORS table NAME field to the AR_PAYMENT_SCHEDULES_ALL

Joining the AR_COLLECTORS table NAME field to the AR_RECEIVABLE_APPLICATIONS_ALL

Joining the AR_COLLECTORS table NAME field to the AR_RECEIPT_METHODS

Sinduja Sekar-Oracle · Answer

Hi @Mblankenship ,

Thank you for visiting and posting in Oracle Business Intelligence (OBI) Product Community Page.

This forum is for OBI product and looks like your question is for Fusion Applications - BI Publisher.

Kindly use the below URLs to post Fusion Apps / BIP questions, submit ideas, receive support from our experts and check out the resources they have available for you.

Oracle Cloud Customer Connect ( https://community.oracle.com/customerconnect ).

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

Regards,

Sinduja