how can we check if specific credit card transaction created Payment Request Invoice in AP

Summary:

We are using Company Pay process in Expense. Due to different payment date to the corporate card provider and statement load in Oracle , we are facing reconciliation issue between payment amount and Invoice amount for card provider.

We would like find out if for any credit card statement, AP invoice is not created . Also user run the create corporate card payment issue for a date of range. So we would like to know how can we using queries link credit card transactions to AP payment request invoice?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):