Wednesday, July 24, 2013

Validating Chartfields Combinations in HCM

We just implemented Combo Edits in PeopleSoft HCM and we had a unique challenge, in that we track Location as a chartfield value and this meant that we would have to map our expenses below the Department ID.  So in order to properly map our expenses down to the employee's location we generated expense mapping for every employee at the emplid level!.  In order to maintain this data we created a process that compares the current employee's expense mapping to their current job chartfield values and if they were different, then we created a new expense mapping for that employee.  The cool thing I found was this  HMCF_CHARTFIELDS:CHARTFIELD_COMBINATION  Application Package.

This package has a method called ValidateCominationBatchMBU that takes these Inputs:

Accounting Date
Synchronous Call to FMS as Boolean
Rowset based on the Record CF_COMBO_WRK_BU


I used the Sync call to FMS and it worked like a champ!  Just remember to Activate the COMBO_CF_EDIT_REQUEST Message in Integration Broker and let Financials Validate all your Combo Edits in HCM.  Check out this Package, it has plenty of other great methods that I have not even had time to evaluate.

No comments:

Post a Comment