Creating PO In Foreign Currency In Buyer Work Center - PO_VALIDATIONS.VALIDATE_SET.-110: C_OOP_ENTER_ALL_FIELDS (Doc ID 2099725.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

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.

Reproducing steps:

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

Cause

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