EBI 9.2: BI_IVCEXT Fails for Invoicing With Courtesy Copy When Language Codes Are Different (Doc ID 2244349.1)

Last updated on MARCH 17, 2017

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.2 version, when attempting to use the courtesy copy functionality on a Bill with a contact that has a different default language code than the defined on the bill and the Customer on the Bill has a default Customer message that is supposed to display on the invoice, the BI_IVCEXT program fails because of a duplicate insert. The following error occurs:

ERROR
-----------------------
Process 9193363 ABENDED at Step BI_IVCEXT.POPHNOTE.Step20 (SQL) -- RC = 805

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

  1. Customer with language code set on the Bill To Address
  2. Customer has standard not for Invoice
  3. Set courtesy copy contact on Invoice with different language code

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