Wrong Item Description Displayed for One Time Items in Purchase Requisition Status Report (XML) and Cancelled Requisition Report (XML) When Run in Non-English Language (Doc ID 2045508.1)

Last updated on OCTOBER 08, 2015

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When using non-English (in this case in Spanish language) template for this report: Purchase Requisition Status (XML), instead of item number an error message is displayed in this field (translated into local language):


"Program Error: An error occurred when searching for a combination of the segment pattern. Please inform the representative of the assistance that:
Approval function FND_FLEX_SERVER encountered zero or negative combination of ID () when trying to find the value of the segments for this combination.
This could indicate an incorrect entry in the column of the table a unique ID combinations."


It is caused by the incorrect construction of the F_FLEX_ITEM_ field on the purchasing report templates that does not take into consideration non-English languages.
 
The same issue is also for these two reports:
Cancelled Requisition Report (XML), Receiving Transactions Register (XML).

 

 

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