Customer offset issue in IFS Cloud

Hi,

Are there any customer offset proposals which are not yet approved? If not, you may need to whether this preliminary ID is available in the database level

We have looked in the customer offset proposal and do not see any that are Not Approved.  We cannot seem to locate the preliminary ID number within IFS Cloud.  

We checked in the database and do see the transactions and header in these tables.  But cannot find it from the interface:

select * from prel_payment_trans_tab t
where prel_payment_id = 314909 ;

select * from prel_payment_tab t
where prel_payment_id = 314909;

I encountered the same issue in APPS 10 for supplier offset. We noticed that  the ‘Payment Type’ (Supplier Offset / Supplier Payment) of the transactions is empty. As a result, details of this preliminary payment ID cannot be seen from the application end. This may be the reason in your case too. As a correction, we updated the payment type & was able to see it in the interface.