JBO-27023 error When creating a new customer account

Last updated on JUNE 02, 2014

Applies to:

Symptoms

On : 11.1.5.0.0 version, Other Issues

If payment term or automatch rule set in DEFAULT customer profile class is
out of date, the following error occurs when creating a new customer with the
DEFAULT customer profile class.

  --------------------
  oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
  ADF_FACES-60097:For more information, please see the server's error log for
  an entry beginning with: ADF_FACS-60096:Server Exception during PPR, #XX
  --------------------

However, the customer is created. When opening the Profile History tab for
the customer, the following error occurs.

  --------------------
  javax.el.ELException: java.lang.NullPointerException
  ADF_FACES-60097:For more information, please see the server's error log for
  an entry beginning with: ADF_FACS-60096:Server Exception during PPR, #XX
  --------------------


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. In "Manage Receivables Customer Profile Classes" task, check the payment
   term and automatch rule set of DEFAULT profile class.
2. In "Manage Receivables Payment Terms" task, set end_date for the payment
   term, which is set for DEFAULT profile class.
3. In "Manage AutoMatch Rule Sets" task,  set end_date for the automatch rule set,
   which is set for DEFAULT profile class.

4. Navigator > Billing > Create Customer
5. Enter Name, Account Number..etc
6. Click "Save" or "Save and Close", the following error occurs.

  --------------------
  oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
  ADF_FACES-60097:For more information, please see the server's error log for
  an entry beginning with: ADF_FACS-60096:Server Exception during PPR, #XX
  --------------------

7. Click "Cancel"
8. Navigator > Billing > Manage Customer
9. Search the Organization Name, which is set at step 5.

 --> Customer is found.

10. Click Account Number link
11. Click Profile History tab, the following error occurs.

  --------------------
  javax.el.ELException: java.lang.NullPointerException
  ADF_FACES-60097:For more information, please see the server's error log for
  an entry beginning with: ADF_FACS-60096:Server Exception during PPR, #XX
  --------------------

Cause