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 - HOG-5064 - Getting issue details... STATUS ) at 7 AM which updates the Quartined Flag in Spendplan to be in sync with Peoplesoft which runs for all 7 days.
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>