Insufficient Digit For IDR Base Amount When Raise Requisition REQ_LINE.PRICE_REQ
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.
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
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.
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 hundreds of Community platforms