R12: AP: Creation_Date and Last_Update_Date Time Stamp missing hh:mm:ss in IBY_EXTERNAL_PAYEES_ALL
(Doc ID 2860524.1)
Last updated on APRIL 13, 2022
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
When querying table data from IBY_EXTERNAL_PAYEES_ALL, the date fields are missing hh:mm:ss and only show mm-dd-yyy.
Steps to reproduce:
In a SQL session run the following:
SELECT * FROM IBY_EXTERNAL_PAYEES_ALL;
Review the output for the data fields (Creation_Date and Last_Update_Date).
The fields do not show hh:mm:ss.
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