EPC / EMM : WM_PM Process (Run Preventive Maintenance) Is Incorrectly Publishing A Blank Transaction On PROJ_ACTIVITY_STATUS_SYNC. This Is Causing Error on HCM Side When Processing The Message - "Fatal SQL error occurred (2,125)" (Doc ID 2814847.1)

Last updated on DECEMBER 15, 2021

Applies to:

Symptoms

When the WMPM process (Maintenance Management > Preventive Maintenance > Run Preventive Maintenance) is run for a PM schedule, the PROJ_ACTIVITY_STATUS_SYNC is incorrectly getting triggered with blank values for an activity associated with the work order. There are no records in the PS_PROJ_ACT_STATUS table for this activity. This is causing errors on the HCM side when processing the message.

Replication Steps:

1. Set up the Integration Broker Configuration that integrates Project, Activity, and Activity Status.
2. For an Asset, Create a PM schedule in Maintenance Management.
3. Run WMPM (Run Preventive Maintenance) job. Navigation: Maintenance Management > Preventive Maintenance > Run Preventive Maintenance.
4. A work order will be created with a Project and Activity associated with it.
5. Notice that a new message is triggered for PROJ_ACTIVITY_STATUS_SYNC. PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Monitor Asynchronous Services.
6. Review the XML for the message. Notice that the XML tags for the transaction section show blank project and activity information.
7. There is no data in the PS_PROJ_ACT_STATUS for this activity associated with the work order.
8. When this blank message is received on the HCM side, the message is not processed and fails with an error message. The error message can be seen on the Monitor Asynchronous Services page. (PeopleTools > Integration Broker > Service Operations  Monitor > Monitoring > Monitor Asynchronous Services)

Demo Screenshots

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.