My Oracle Support Banner

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

Last updated on JANUARY 12, 2021

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.


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


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( at oracle.apps.fnd.framework.server.OAUtility.invokeMethod( at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod( at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(

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: NNNNNN) > click on Apply > Error occurs



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.