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

Last updated on JUNE 09, 2017

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

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