FA OTBI: Error When Using Distribution Concatenated Segments Column In OTBI Invoice Details Report
(Doc ID 2205652.1)
Last updated on JULY 18, 2020
Applies to:Oracle Fusion Payables Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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)
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