Receiving Error when Copying Any Requisition Special Request Req to Purchase Order. Assignment of "100000000.00000" to PO_LINE_SHIP.UNIT_PRC_TOL_L failed. (2,119) PO_REQ_WRK.COPY_REQ.FieldChange (Doc ID 1980555.1)

Last updated on JUNE 18, 2021

Applies to:

Symptoms

When attempting to copy a requisition, ePro or core, into a new PO, when clicking the Copy to PO button, the following error occurs.

Error: 
Assignment of "100000000.00000" to PO_LINE_SHIP.UNIT_PRC_TOL_L failed. (2,119) PO_REQ_WRK.COPY_REQ.FieldChange Name:updt_cat_Non_Item_Dflts PCPC:52087 Statement:670
Called from:PO_REQ_WRK.COPY_REQ.FieldChange Name:copy_req_to_po Statement:1031
Called from:PO_REQ_WRK.COPY_REQ.FieldChange Statement:1451

The assignment to the specified field failed.

The failure can be caused by any one of several problems. The new value could be too long to fit into the field, the new value could have too many digits (possibly including a sign) to the left of the decimal point to fit into the numeric field, there could be problems converting the new value to internal format, the field might not be present in the page buffers (rare), or there could be a memory allocation error (very rare).

Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed. A trace including "Show Assignments to Variables" will trace the new value.


The issue can be reproduced at will with the following steps:
1. Set Category Matching Tolerances to maximum values.
2. Create an epro requisition or core requisition.
3. Create a new PO, Copy the req into the PO.
4. Error received when clicking the Copy to PO button.


The issue has the following business impact:
Due to this issue, users cannot copy requisitions to purchase orders.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.