Last updated on MAY 15, 2017
Applies to:Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.
When customer creates a Purchase Order in Buyer Work Center, other than functional currency, customer use a foreign currency at header level, when the PO is saved the error occurs:
po.plsql.PO_VALIDATIONS.VALIDATE_SET.-110: C_OOP_ENTER_ALL_FIELDS Cause: A SQL error has occurred in po.plsql.PO_VALIDATIONS.VALIDATE_SET.. The SQL error is ORA-01403: no data found. Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
1.Go to Buyer Work Center on Tab Orders;
2.Create Standard Purchase Order;
3.The functional currency is defaulting at header level;
4.Change the currency at header level;
5.Save the Purchase Order;
6.The error occurs.
From Fnd Debug Log file we can see these errors:
'po.plsql.PO_VAL_DISTRIBUTIONS.OOP_ENTER_ALL_FIELDS.0.EXCEPTION ';SQLERRM = ORA-01403: no data found
po.plsql.PO_VALIDATIONS.VALIDATE_SET.110.EXCEPTION 'Validation subroutine C_OOP_ENTER_ALL_FIELDS threw exception;SQLERRM = ORA-01403: no data found
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms