Appointment Information Not Available In APPT_DETAIL (Doc ID 2966006.1)

Last updated on AUGUST 10, 2023

Applies to:

Goal

Appointment information not available in APPT_DETAIL

For certain ASNs, even though appointment is getting created and status is 'AC' (appointment closed) in APPT_HEAD table, there are no information available in APPT_DETAIL for that appointment.

Also we could see that the status of the order is also in closed status (tsfhead and ordhead).

Sample data:
ASN = 3103698

select * from iia.stg_manht_receipt_in where asn_nbr = '3103698'; -- all are POs
select * from appt_head where appt = '797378'; --appointment status is 'AC'
select * from ordhead where order_no = '57857154'; --order status is 'C'

Similarly they could see that about 2665 appointments are there where appt_detail is empty.

Would like to know the functional aspect of it, as below:
1. Are these appointment information not getting updated/added into appt_detail for some functional reason?
2. Are these appointment information getting updated and and getting deleted from appt_detail after some time?
3. We could see that all the orders are in Closed/Shipped status (not Open), so will there by any Business impact because of this?
 

Solution

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