Rate Factor Effective_Date Stored With 08:00:00
(Doc ID 2344692.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 6.4.1 and later
Information in this document applies to any platform.
When you create a rate factor you are giving effective date from 01-JAN-2018 but in database it stored as 01-JAN-18 08.00.00.
You need to understand from where this 08.00.00 is coming and why OTM is adding it.
Table Name is RATE_FACTOR
Column name is EFFECTIVE_DATE
Navigate to Contract and Rate Management -> Power Data ->General ->R ate Factor.
- Enter Source Rate Factor ID, Click on New Rate Factor Button
- Enter effective date from 01-JAN-2018 and some expiration date and put some value in Factor Value and click on "Save".
- Check the inserted value in RATE_FACTOR table you will see effective date has 01-JAN-18 08.00.00
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