R12: Unable To Create Expense Account Rules (Doc ID 1566045.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

While attempting to create a Expense Account Rule, the following error occurs in the web page :

Error

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "RULE_ACC_U1" violated during post operation:"Insert" using SQL Statement "INSERT INTO PO_RULE_EXPENSE_ACCOUNTS(ACCOUNT_RULE_ID,RULE_TYPE,RULE_VALUE_ID,SEGMENT_NUM,SEGMENT_VALUE,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,ORG_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)". at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720) at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152).......

Steps to reproduce

1. Purchasing Responsibility> Setup > Financial > Accounting> Expense Account Rules
2. Click on create
3. Accounting Rule type  :Item category
4. Accounting rule Value :Exp-Facilities-Services-Materials
5. Segment name :Account
6. Segment value : Enter a segment value ( example: 64022) > click on Apply > Error occurs

 

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