Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
TAPSS-1826
- sekar.krishnan
Description
Spend Plan(Salesforce) receives the GMR RC PC details through a MuleSoft service at 5:30 AM. The spend plan is missing this information on Sunday and Monday Morning.
Spendplan application executes a subsequent Process flow(GMRRCPC_DailyProcessAfterGMRLoad - https://sydneyuni.atlassian.net/browse/HOG-5064 ) at 7 AM which updates the Quartined Flag in Spendplan to be in sync with Peoplesoft which runs for all 7 days.
Investigation
On Discussion with John Cooper(From PeopleSoft) and Rick (Mulesoft), John has confirmed that PeopleSoft is extracting the files on Peoplesoft only from Tuesday to Saturday. However, on the Spendplan application, the process(flow) to sync the Quartined Flag with Peoplesoft runs for all 7 days.
Currently, Spend plan checks for the formula flag “System_is_updated_today__c” on the GMR RC PC object, and if the flag hasn’t been updated, records will be considered for the quartine process.
Changes made to the “System_is_updated_today__c” flag on Spendplan to bypass the validation on Sun, and Mon as Peoplesoft doesn’t generate files on Sun and Monday morning.
Implementation
Salesforce had a limitation on the flow schedule to set the frequency as frequency can only be set to run Once, Daily, and Week. It doesn’t allow the flow to run particular day of the week. So, Change the Entry Criteria for the flow to exclude the records on a Sunday and Monday.
Formula changed from
System_is_updated_today__c = <formula>System_GMR_Load_Date__c == TODAY()</formula>
To
System_is_updated_today__c = <formula>OR(WEEKDAY(TODAY()) == 1 ,WEEKDAY(TODAY()) == 2 ,System_GMR_Load_Date__c == TODAY())</formula>