Discussions
Categories
- 5.4K All Categories
- 15 Introduce Yourself!
- 456 Community Feedback - NEW! (No Product Questions)
- 108 General Community Platform Concerns/Kudos/Feedback
- 83 Community Platform Bug Reports
- 86 How Do I Use the Community?
- 65 Where is the...? (Community Platform Locations)
- 18 Ideas and Suggestions for the Community Platform
- 71 Personal Document & Blog Archive
- 5 Community Programs
- 5 Get-Togethers
- 4.8K Certification Community
- 4.7K Certification Community Discussions
- 22 Oracle Certified Master Profiles
- 31 Oracle Database 12c Administrator Certified Master Profiles
- 83 Visual Builder Cloud Service
Rate service cache getting reset to 0
Hi All,
We have identified an issue within our rate service cache where few of the cached lane pair is having value 0. But, this is not the case with master data setup respectively.
For example : We have rate service with DAYDURATION and all the service lanes defined are non-zero values. But, in some point of time we are able to see 0 value is getting reset .
When we do the replication, OTM behaves as expected
Example :
Case1 – POST CLEARING THE RATE SERVICE CACHE
- Cleared rate service & distance cache under Atlas - QA
- Planned order movement with lane (835763-> 1222ART), captured logs for the same.
- Rate service details are retrieved from database while planning and as well stored under cache (captured at logs).
- Planned order movement again with lane (835763-> 1222ART), captured logs.
- In this case rate service details are retrieved from cache as recorded under logs.
Case2 – EDIT & FINISH RATE SERVICE - UI
- Identified the rate service details under cache for the lane (835763-> 1222ART) / RS_DPSTATIC_DD_ROAD in exist.
- Edit & Finish the Rate Service RS_DPSTATIC_DD_ROAD with out adding any lane to the same.
- Identified that rate service details under cache for the lane (835763-> 1222ART) / RS_DPSTATIC_DD_ROAD deleted automatically.
- Planned order movement with lane (835763-> 1222ART), captured logs for the same.
- Rate service details are retrieved from database while planning and as well stored under cache (captured at logs).
We are not able to find the actions any which leads to the cached value to reset being 0 .
Whether anyone has any idea. Kindly assist regards to the same.
Regards,
Harish
Answers
-
- APEX version?
- DB version?
- How do you access APEX? (ORDS? which version?)
- What is your J2EE server? Version?
- You mentioned a cache server. Which one? Version?
- I see it is on OCI (Oracle Cloud): how are these servers organized? (Proper affinity? Same container? Region?)
- Anything else we should know about your setup?
It really seems like this problem is not an APEX problem.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,587 Red Diamond@User_QMOOY Your post has been moded out of the APEX forum as it is not clear the problem is related to APEX.
The community is categorized by products. As I don't see enough information about the product you are using I can't move the post to the right forum. Provide detailed information about the product you are using, please.
Timo
-
We are using ORACLE TRANSPORATION MANAGEMENT (OTM) product.
Software Version OTMv21c
Database Edition OTM21C
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,587 Red Diamond
Your topic is handled over in this community https://community.oracle.com/customerconnect/categories/supply-chain
Try to access the forum from the categories
Select the 'Supply Chain & Manufacturing category under Applications in the picture.
And if this won't work, you can check your profile when you are logged in to the Cloud Customer Connect community. In your profile click on the 'Edit Profile' link and check that you have checked the cloud infrastructure stuff. Application Development is needed at least.
Timo
