查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博客

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

Cause

Solution

最新文章