...
Spend Plan(Salesforce) receives the GMR RC PC details through a MuleSoft service at 5:30 AM. Spend The spend plan is missing this information on Sunday and Monday Morning.
Spendplan application executes a subsequent Process flow(GMRRCPC_DailyProcessAfterGMRLoad -
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
...
Rick from MuleSoft confirmed that they didn’t receive any files from PeopleSoft for those days to process and it was missing on the SFTP folder(refer the below image).
...
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>