My Oracle Support Banner

FA OTBI: Error When Using Distribution Concatenated Segments Column In OTBI Invoice Details Report (Doc ID 2205652.1)

Last updated on JUNE 28, 2022

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Technology Management - Reports/Analytics

Error when using Distribution concatenated segments column in OTBI Invoice Details Report


I have copied the Seeded OTBI report "Invoice Details Report" from Payables catalog report and edit the report to add the column Concatenated Segments from Distribution folder. Then the report results complete with error given below:

[nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - AP Account.Code Combination Description, case when Dim - AP Transaction Details.Payment Status Flag <> 'N' then Dim - AP Disbursement Details.Check Date else NULL end , case when Dim - AP Transaction Details.Payment Status Flag <> 'N' then Dim - AP Disbursement Details.Check Number else NULL end (HY000)


Cause

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
Symptoms
Cause
Solution
References


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