You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HWM_TM_STATUSES - Many entries for a given timecard entry (Human Workforce Management / Timecards)

in Reporting and Analytics for ERP

We would like to know how the HWM_TM_STATUSES table works in regards to timecard entry changes (when a timecard is submitted, approved, then modfied).

In our observed behavior on our environment, if a user saves a timecard and has it approved, we would expect 1 row to be inserted into the HWM_TM_STATUSES table (filtering on 'APPROVED' status_value). If the user then updates the timecard and it is approved again, we would expect a second row in HWM_TM_STATUSES. We are encountering 5 entries for the example that has been attached.

If we only query the HWM_TM_STATUSES table and count entries for a single time entry record (TM_BLDG_BLK_ID / TM_BLDG_BLK_VERSION / PART_GRP_TYPE_ID / STATUS_VALUE), we are seeing as many as 32 rows with a distinct STATUS_ID (primary key of the table). This seems very high, given the timecard would need to be approved 32 times for this to happen, which is not valid business test case.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!