R12: request WIP Mass Load WIP 成批裝入出錯 Cannot read value for profile option RPM_CONC_PROCESS_ID in ro

peggypoon發表於2009-09-25

查metalink解決，在此記錄一下metalink真是個好東西，不過，要花錢的 ^_^

On 12.0.6 in Production:
When you are attempting to use the WIP Mass Load program,
the following error occurs.

ERROR
Cannot read value for profile option RPM_CONC_PROCESS_ID in routine &ROUTINE.

STEPS
The issue can be reproduced at will with the following steps:
1. Release the Planned Order from Planning Workbench
2. WIP mass Load program completes with Error message
Cannot read value for profile option RPM_CONC_PROCESS_ID in routine &ROUTINE.
3. No Job is imported in WIP.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, you cannot use the WIP Mass Load Program.

Cause

The cause of the issue is invalid / incorrect value of wip_interface_s
The data should not conflicting with the details in the WIP_JOB_SCHEDULE_INTERFACE table


The following bug was logged for this specific customer to receive a datafix from Oracle
Development:
Bug 8704835 - WIP MASS LOAD FAILS FROM ASCP PLANNING WORKBENCH
Oracle Development stated that the issue is due to invalid / incorrect data.

The following SQL identified the invalid / incorrect data:
select wip_interface_s.nextval from dual;

Solution

To implement the solution, please execute the following steps:


1) Make sure that there is no WIP Concurrent request running.

2) Execute the following SQL
ALTER SEQUENCE wip_interface_s INCREMENT BY 20000;
SELECT wip_interface_s.nextval from dual;
ALTER SEQUENCE wip_interface_s INCREMENT BY 1;

3) Resubmit the WIP Mass Load.

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/21988588/viewspace-1027361/，如需轉載，請註明出處，否則將追究法律責任。

相關文章