Appointment Information Not Available In APPT_DETAIL
(Doc ID 2966006.1)
Last updated on AUGUST 10, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.
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).
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document