Transfer In 'P' Status Not Been Closed (Doc ID 2938654.1)

Last updated on MARCH 30, 2023

Applies to:

Goal

How to close transfers in 'P' status? They are not getting closed off by tsfclose and this is affecting the transfer reserved qty.

example:
select * From tsfhead a, tsfdetail b
where a.tsf_no = b.tsf_no
and   a.tsf_type = 'CO'
and   a.status   = 'P'
and   a.exp_dc_date < '21-DEC-22 00:00:00'
and   b.tsf_qty > 0
and   b.tsf_qty > b.cancelled_qty
order by a.exp_dc_date;
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.