[jira] [Commented] (OFBIZ-13460) Add durable MRP run history and provenance

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-13460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18106583#comment-18106583 ] 

ASF subversion and git services commented on OFBIZ-13460:
---------------------------------------------------------

Commit d34901e830085b6ac64d9e23c905c9391cd5ee78 in ofbiz-framework's branch refs/heads/trunk from diveshdut
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=d34901e830 ]

OFBIZ-13460 Add MRP run lifecycle logging

Add durable run lifecycle logging for MRP execution so queued, running, finished, and failed runs can be tracked independently from the transient event rows produced by the engine.

Update services_mrp.xml with the run-log service contracts. launchMrpRun queues executeMrp as persisted async work, createMrpRunLogAndTrackerBeforeQueueingMrp creates the durable MrpRunLog and JobTracker records before queueing, and the update services keep the run status, timing, job id, error text, and generated mrpId current as the run progresses.

Update MrpServices.java with the core lifecycle behavior used by both API callers and Manufacturing screens. The launch path creates the run log before queueing executeMrp, records queue failures when executeMrp never starts, attaches the JobSandbox job id when queueing succeeds, and lets executeMrp mark MrpRunLog as SERVICE_RUNNING, SERVICE_FINISHED, or SERVICE_FAILED.

Update the Manufacturing run-MRP controller action to call launchMrpRun instead of directly queueing executeMrp, so the standard screen and REST/API flows use the same lifecycle handling.

Add ManufacturingUiLabels entries for the run-log outcome and queue-failure messages shown by the lifecycle services.


> Add durable MRP run history and provenance
> ------------------------------------------
>
>                 Key: OFBIZ-13460
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-13460
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: manufacturing
>    Affects Versions: Upcoming Branch
>            Reporter: Divesh Dutta
>            Assignee: Divesh Dutta
>            Priority: Trivial
>             Fix For: Upcoming Branch
>
>
> *Summary*
> Today, MRP execution details are not preserved in a durable way across runs. The current process reinitializes {{{}MrpEvent{}}}data at the start of a new run, so prior run context is lost. In addition, once related job/runtime records are cleared from {{{}JobSandbox{}}}, key audit details such as who triggered the run, when it ran, whether it completed successfully, and how long it took are no longer easily available.
> This improvement adds a lightweight, additive run-log model for MRP execution. The goal is to preserve durable run-level history and provenance without changing the existing {{MrpEvent}} reinitialization behavior.
> *Scope*
> This work introduces a new {{MrpRunLog}} entity and updates MRP execution so each run can persist:
>  * who triggered the run
>  * when it started and finished
>  * which facility or facility group it ran for
>  * the resulting {{mrpId}}
>  * run duration
>  * run status such as running, finished, or failed
>  * concise failure details
>  * a success summary including counts of created MRP events and proposed requirements
> *Acceptance Criteria*
>  * A durable {{MrpRunLog}} record should be created for each MRP run.
>  * MRP execution should update the run log as the run moves through running, finished, or failed states.
>  * The run log should store {{{}mrpId{}}}, timestamps, duration, and user/facility context when available.
>  * On failure, the run log should store a concise failure reason/message.
>  * On success, the run log should store a concise outcome summary and counts for created MRP events and proposed requirements.
>  * Existing OFBiz MRP screens should continue to work without regression.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)