...
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).
...
John Cooper(From PeopleSoft) and Rick (Mulesoft). John Cooper 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.
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>