Cost Change Approval Time Does Not Get Captured
(Doc ID 2990596.1)
Last updated on DECEMBER 08, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 to 23.1 [Release 23.1]Information in this document applies to any platform.
Symptoms
On : NA version, Operations & Maintenance
ACTUAL BEHAVIOR
---------------
When Cost Change is created & approved from MFCS UI, the APPROVAL_DATE field in COST_SUSP_SUP_HEAD table get populated with only date value. No timestamp gets populated
EXPECTED BEHAVIOR
-----------------------
When Cost Change is created & approved from MFCS UI, the APPROVAL_DATE field in COST_SUSP_SUP_HEAD table get populated with only date value. Timestamp should be populated
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into MFCS using below URL.
2. Navigate to 'Cost' --> 'Create Cost Change by Item'.
3. Provide Description - 'Sample Cost Change 0303'.
4. Select 'Reason' as '97' from the dropdown & select current date as Effective date.
5. Add Item by selecting Supplier, Item. Select 'Change by Amount' & provide 1.0 in 'Amount' field.
6. 'Submit' & 'Approve' the Cost Change.
7. 'Save' the Cost Change.
8. Check in COST_SUSP_SUP_HEAD table using below SQL (the last column).
select a.cost_change, a.cost_change_desc, a.create_date, a.create_id,
a.approval_id, to_char(a.approval_date, 'DD-MON-YY HH24:MI:SS') approval_date
from cost_susp_sup_head a
where a.cost_change = '535004';
9. See only date gets populated, but timestamp is truncated (Value - '00:00:00').
Cause
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
Symptoms |
Cause |
Solution |
References |