Why Do Receipts Exist Without Receipt Lines/Transactions?
Issue
Why do Receipt Numbers (rcv_shipment_headers records) exist when there
are no Receipt Lines (rcv_shipment_lines) or Transactions (rcv_transactions)
associated with the Receipt Number?
Solution
It is correct functionality that Receipt Numbers can be Saved without
corresponding Receipt Lines. The
existence of Receipt Numbers (Receipt Headers) without Receipt Lines does not
cause any problems so those Receipts Numbers can be ignored or can be utilized
for Add To Receipt functionality for adding to the receipt at later time.
--------------------------------------------------------------------------------------------
Records in rcv_shipment_headers may exist without a corresponding
rcv_shipment_lines record when transactions were processed using Receiving Open
Interface functionality (including iSupplier Portal for creation of ASNs,
receiving data populated via EDI and 3rd Party software). Also, when using RCV:
Processing Mode=Immediate (or Batch), Receipt Header (rcv_shipment_headers) is
saved before Receiving Transaction Processor processes the transaction; so, if
the transaction fails (or does not process at all), rcv_shipment_headers record
will exist without corresponding rcv_shipment_lines records. By design, Oracle
software does not delete Receipt Headers that are created when using RCV:
Processing Mode=Immediate (or Batch.)
--------------------------------------------------------------------------------------------
The following steps can be used to created Receipt Headers without
Receipt lines using RCV: Processing Mode=On-line:
Purchasing Responsibility (or
equivalent) > Receiving > Receipts
Query using any criteria
Select a line then deselect
the line (or skip this Step and proceed to Step 4)
Click on Receipt Header
window
Save
Please note that Receipt Headers (with or without associated Receipt
Lines) can be used for subsequent transactions by choosing (Add to Receipt).
If you would like you can use below data fix
Datafix for Orphan Receipt or Shipment Headers (rcv_shipment_headers)
Identification script:
select *
from rcv_shipment_headers rsh
where receipt_source_code in
('VENDOR','CUSTOMER')
and trunc(creation_date) like '%AUG-15%'
and not exists
(select 1
from rcv_shipment_lines rsl
where rsl.shipment_header_id =
rsh.shipment_header_id)
and not exists
(select 1
from rcv_transactions
rt
where
rt.shipment_header_id = rsh.shipment_header_id)
and not exists
(select 1
from rcv_transactions_interface rti
where rti.shipment_header_id =
rsh.shipment_header_id
and (rti.processing_status_code in
('RUNNING','PENDING')
or
nvl(rti.validation_flag,'N') = 'N' ));
Datafix:
create table orphan_rsh_bk as
select *
from rcv_shipment_headers rsh
where receipt_source_code in
('VENDOR','CUSTOMER')
and trunc(creation_date) like '%AUG-15%'
and not exists
(select 1
from rcv_shipment_lines rsl
where rsl.shipment_header_id =
rsh.shipment_header_id)
and not exists
(select 1
from rcv_transactions
rt
where
rt.shipment_header_id = rsh.shipment_header_id)
and not exists
(select 1
from
rcv_transactions_interface rti
where rti.shipment_header_id =
rsh.shipment_header_id
and (rti.processing_status_code in
('RUNNING','PENDING')
or
nvl(rti.validation_flag,'N') = 'N' ));
delete from rcv_shipment_headers
rsh
where receipt_source_code in
('VENDOR','CUSTOMER')
and trunc(creation_date) like '%AUG-15%'
and not exists
(select 1
from rcv_shipment_lines rsl
where rsl.shipment_header_id =
rsh.shipment_header_id)
and not exists
(select 1
from rcv_transactions
rt
where
rt.shipment_header_id = rsh.shipment_header_id)
and not exists
(select 1
from
rcv_transactions_interface rti
where rti.shipment_header_id =
rsh.shipment_header_id
and (rti.processing_status_code in
('RUNNING','PENDING')
or
nvl(rti.validation_flag,'N') = 'N' ));
