Symptoms

Planning Process is failing at the Memory Based Snapshot Worker stage with the following error:

APP-MRP-22075: An internal error has occurred (mrnspgmsg, 1, 8674691, )

APP-FND-01564: ORACLE error 1455 in mslsnp_snp_po

Cause: mslsnp_snp_po failed due to ORA-01455: converting column overflows integer datatype

The issue can be reproduced at will with the following steps:

1.Supply Chain Plan --> Launch

Cause

The issue is caused by the following setup: huge number for purch_line_num comming in for order_number.

Changing the PO Line Number (purch_line_num) to a small number and rerunning the plan will complete successfully.

Solution

To implement the solution, please execute the following steps:

1.Search the PO Line Number which cause the issue by running the script. first into the APS Instance:

select * from msc_supplies
where purch_line_num > 10000
and plan_id = -1

select purch_line_num,order_number from msc_supplies
where plan_id = -1
and purch_line_num is not null
order by purch_line_num desc

Then into the Source Instance:

select LINE_NUM from apps.po_lines_all
where LINE_NUM > 3000

2.Change the PO Line Number (purch_line_num) to a smaller number.

3. Go into the responsibility: Purchasing > Navigate to Purchase Orders.

4. Query up the purchase order and correct the line number. If needed re-approve the PO (use script. poxrespo.sql from Note 390023.1 to reset Standard, Blanket, Planned and Contract purchase orders .

5. Allow the planning manager to cycle once.

6. Recollect the PO data.

7. Rerun the plan(s).

8. If the issue is resolved, please migrate the solution as appropriate to other environments.