My Oracle Support Banner

Insufficient Digit For IDR Base Amount When Raise Requisition REQ_LINE.PRICE_REQ (Doc ID 2410524.1)

Last updated on JUNE 13, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Having a problem with insufficient digit for IDR base amount when user raise a purchase requisition because sometimes, for 1 item in Indonesia the
price could reach 11 digits and above. PeopleSoft changed amount field length to Sign 23.5 for all but missed out for the field PRICE_REQ(Sign 10.5) which is used in REQ_LINE.

Steps to reproduce the issue:

1.Add/Update Requisitions > Enter Price
2.Value is 10000000000.00000

Error -

Assignment of "10000000000.00000" to REQ_LINE.PRICE_REQ failed. (2,119)
REQ_LINE_WRK.PRICE_REQ_C.FieldEdit PCPC:289 Statement:5

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.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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