APINV Approval Notification - Error Page After Approving Invoice Lines With Duplicate Line Number (Doc ID 2258920.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Getting error in Invoice Approval Notification while splitting the Distribution Line and Approving the Invoice.

STEPS to REPRODUCE

  1. create an invoice for supplier
  2. submit for approval
  3. open approval notification and split distribution with same distribution line number. Error is being thrown:

  

ERROR

Index violation error thrown because distribution line number should be unique.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException:
JBO-26048: Constraint "AP_INVOICE_DISTRIBUTIONS_U1" violated during post
operation:"Insert" using SQL Statement "BEGIN INSERT INTO
AP_INVOICE_DISTRIBUTIONS_ALL(ACCOUNTING_DATE,ACCRUAL_POSTED_FLAG,ASSETS_ADDITI
ON_FLAG,ASSETS_TRACKING_FLAG,CASH_POSTED_FLAG,DISTRIBUTION_LINE_NUMBER,DIST_CO
DE_COMBINATION_ID,INVOICE_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,LINE_TYPE_LOOKUP
_CODE,PERIOD_NAME,SET_OF_BOOKS_ID,AMOUNT,CREATED_BY,CREATION_DATE,LAST_UPDATE_
LOGIN,MATCH_STATUS_FLAG,POSTED_FLAG,REVERSAL_FLAG,ENCUMBERED_FLAG,PA_ADDITION_
FLAG,AWT_GROUP_ID,ORG_ID,DIST_MATCH_TYPE,INVOICE_DISTRIBUTION_ID,INVOICE_LINE_
NUMBER,DISTRIBUTION_CLASS,TOTAL_DIST_AMOUNT) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) RETURNING
DISTRIBUTION_LINE_NUMBER, INVOICE_ID, INVOICE_DISTRIBUTION_ID INTO ?, ?, ?;

  

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