Rate Factor Effective_Date Stored With 08:00:00
Last updated on JANUARY 02, 2018
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms