Subledger Accounting can't create an accounting entry for this event in the secondary ledger

Summary:

We have AP invoice with Prepayment but is not accounted successfully due to error that is showing.

We have Primary and Secondary Ledger and the error is:

Subledger Accounting can't create an accounting entry for this event in the secondary ledger or reporting currency.

Content (please ensure you mask any confidential information):

I did check from Oracle Docs and some of this issue is due to the Exchange Rates is in future or no available rates yet, but this is an old invoice and with available exchange rate from local currency to the reporting/secondary ledger currency. The transaction has been sweep to next period but we still need to get how to resolve this issue to avoid surfacing in the future.