MRP Unfirmed Jobs are getting a HDCaseNum added to them

Epicor ERP 10
1

Has anyone seen Unfirmed Jobs having a HDCaseNum associated with them. This is causing some issues with Case Management as it looks like these UJ jobs are linked to the Case, when they should not be.

I have a case open with Epicor, but they cannot duplicate the issue. Not sure why they cannot because they have a few copies of our database. I let the issue slid a bit because our users were not making as much noise about this. Well now the users are eager to get this fixed. I am asking the group incase there is something with how the MRP is configured that is causing this. We are on 10.1.400.32 at the moment.

The reason this is an issue as we have dashboards that exclude jobs when they are linked to cases.

I am open to ideas.

Thanks,

Ken

2

Are these jobs linked to Sales Order lines that have a casenum on them?

Mark W.

3

Mark.

Using the following query. I do not see the any Jobs Linked to Orders with a HDCase.
Is there a better way to see what you are recommending?

select oh.HDCaseNum, jh.HDCaseNum, oh.OrderNum, jh.JobNum
from OrderHed oh
inner join Erp.JobProd jp on oh.OrderNum = jp.OrderNum
inner join Erp.JobHead jh on jh.JobNum = jp.JobNum

4

OrderHed.HDCaseNum to JobHead.HDCasenum directly. There might not be a jobprod link (just in case)

5

That is the issue though Mark. UnFirmed Jobs are being created with an existing HDCaseNum. We are seeing the Unfirmed Job with an HDCaseNum of a case from a year ago. The Job is not related to the Order that has the same HDCaseNum.

When the Unfirmed Job is being created where does it get HDCaseNum from?

6

Could it be coming from a data directive BPM on the JobHead table?

7

I checked there is no BPM that is in play. The weird thing is that today it didn’t create any UJ with a HDCaseNum. Yesterday it did.

JobNum PartNum HDCaseNum
UJ000000000001 005-313 0
UJ000000000002 005-313 0
UJ000000000101 005-384 0

8

Today the UJ job has a HDCase. It has to do with how MRP creates the case.

jobnum PartNum HDCaseNum
UJ000000000001 005-313 9057
UJ000000000002 005-313 0
UJ000000000101 005-384 0