F986113 Subsystem Job Master Table Contains Multiple Records for R00460, R42950 and R09801

Purpose of Document

The Subsystem Job Master (F986113) contains a huge number of records with a Job Status of 'W' (F986113.SSOPCR='W') for the UBE reports R00460|ZJDE0001, R42950|ZJDE0005 and R09801|ZJDE0011. Can we delete this data? If so, how can we delete it?

Refer to the following documents before you take any action as these documents explain Subsystem Processing in detail.

• <Document 1265778.1> - E1: SS: Subsystem Jobs
• <Document 625418.1> - E1: 40: Subsystem Processing

All the data written in the F986113 Subsystem Master tables are records of reports executed through the subsystem and contain business logic information. Therefore, before deleting the records, you need to verify whether these reports/versions are needed for your business.

• Table of Contents:
• R00460|ZJDE0001 - Interoperability Generic Outbound Subsystem UBE
• R42950|ZJDE0005 - Sales Order Batch Price/Cost Update (subsystem submission of Price Cost Update)
• R09801|ZJDE0011 - General Ledger Post (G/L Post Subsystem Version)
• Conclusion:

R00460|ZJDE0001 - Interoperability Generic Outbound Subsystem UBE
This report/version is meant for dealing with the Interoperability Outbound process which is to create Z files per your needs. The Z file can be implemented purely for interoperability or auditing purposes. As per the processing options, it will write UB - Update Before Image and UA - Update After Image. The definition can be done either through P90701A/P90701 - Interoperability Event Definition and then form exit - Z File Events or P47002 - Flat File Cross-Reference where Transaction Type starting with 'JDE*' are definitions for the Interoperability Process.

The way you can check this is the following:

1. Check data from each listed tables (for example F0101Z2)
2. Check all the defined version of last Interactive application (2nd Level or 3rd level, P01012)
3. Check how it has definition for P0100041
4. If you do not need outbound interoperability against table F0101 - Address Book Master remove the defined version from the processing option parameter

Back To Top

R42950|ZJDE0005 - Sales Order Batch Price/Cost Update (subsystem submission of Price Cost Update)
First determine the functionality of this report R42950 which is to update cost/price/exchange rate after Sales Order Entry and this report updates the Transaction Files (F4211 - Sales Order Detail) based on Master files (F4205 - Item Cost, F4106 - Item Price and F0015 - Exchange Rate and so on). In a typical business environment, we can update Cost/Price before we run R42565 - Print Invoice or R42800 - Sales Update. Whereas subsystem job will be called after Shipment Confirmation is done through P4205 - Shipment Confirmation.

In case you do not need to update Cost/Price information from F4211 - Sales Order Detail, you may remove it from Processing Option of P4205 as below:

1. Check each versions you are running for P4205
2. Go to 'Process' tab
3. Remove parameter '1-Update Cost/Price' for item #6. Sales Order Batch Price/Cost Update

Back To Top

R09801|ZJDE0011 - General Ledger Post (G/L Post Subsystem Version)
Unlike other subsystem configuration, currently R09801|ZJDE0011 can be submitted to server only through P0011 - Work With Batch(Row Exit) Subsystem G/L Post. The risk of this subsystem job is that after the JDE service gets restarted and forgot to submit to server R09801|ZJDE0001, the report could end up with an out of balance situation between the F0911/F0902.

Back To Top

Conclusion:
In short, there may not be streamlined answer whether the records from F986113 can be deleted or not.

If any of the above configuration meets your daily/periodic business requirements then, submit the same version to the server. Once the JDE service gets started it will create one record into the F986113 with Job Status 'R - Running' (F986113.SSOPCR='R') along with inserting a new record into F986110 - Job Master table which the Queue Kernel can pick up and handle for the usual Batch Processing.

If you do not need the records, then you may delete them manually. Be noted that the table F986113 - Subsystem Job Master File is a system file which is sitting in Server Map, so the table owner is SVM812 not SYS812 for example. This file is also not governed by OCM mapping.

Currently there is no batch deletion of F986113 records available, so the records can be deleted either through P986113 - Subsystem Jobs row by row or through external database tools for batch deletion.

Back To Top