Data Synchronization between Worksheets and Database
I have a doubt regarding synchronization of data between Worksheets and database.
Whenever we run collection and 'EBS Full Download' workflow to load data into Demantra, it collect new data as well as changes in the Item or Location Hierarchy and these changes are instantly reflected in Demantra worksheets.
For example, if the planner for a customer changes from X to Y, then when the updated data is loaded via 'EBS FULL DOWNLOAD' workflow, the change is instantly reflected in Demantra Worksheets.However if instead of using Demantra Workflows, we directly update the base table (like mdp_matrix) with the new planner name, this change does not get reflected in Demantra worksheets, unless we bounce the Demantra Application server.