Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

obiee 12c producing error message I can't find an answer for

Big_ZAug 12 2020 — edited Aug 13 2020

OAMP2OPY: KNYNDVB7

I run my analysis and get this error. I can find the first have but not the second half. It seems to have something to do with a patch we applied in our DEV environment. The same Analysis works find in TEST and PROD.

Error

View Display Error

Error generating view. Error getting cursor in GenerateHead

Error Details

Error Codes: OAMP2OPY:KNYNDVB7

Invalid SQL Identifier: ( SELECT year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date") s_1, Count(distinct "UI - OP Segment Subject Area"."OP Segment Information"."SSN" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) s_2, sum("UI - OP Segment Subject Area"."OP Segment Accounts Receivable Information"."Total Accounts Receivable Amount" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) s_3, sum("UI - OP Segment Subject Area"."OP Segment Balance Due Information"."Total Owed to OED Amount" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) s_4, sum("UI - OP Segment Subject Area"."OP Segment Balance Due Information"."Total Owed to OED Amount" by year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date"))/CAST(sum("UI - OP Segment Subject Area"."OP Segment Accounts Receivable Information"."Total Accounts Receivable Amount" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) as double)*100 s_5 FROM "UI - OP Segment Subject Area" WHERE (("OP Segment Information"."Decision Date" <> date '1900-01-01') AND ("OP Segment Codes and Flags"."OP Type Code" <> 'B') AND ("OP Segment Codes and Flags"."OP Status Description" = 'ACTIVE') AND ("OP Segment Codes and Flags"."OP Cause Code" IN ('4', '5')) AND (year("OP Segment Information"."Finality Date") >= 1998)) )SubjectArea1 INNER JOIN ( SELECT year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date") s_1, Count(distinct "UI - OP Segment Subject Area"."OP Segment Information"."SSN" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) s_2, REPORT_SUM(Count(distinct "UI - OP Segment Subject Area"."OP Segment Information"."SSN" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) BY ) s_3, REPORT_SUM(sum("UI - OP Segment Subject Area"."OP Segment Transaction Information"."Amount of Payment Received"+"UI - OP Segment Subject Area"."OP Segment Transaction Information"."Amount of Principal Offset" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) BY ) s_4, sum("UI - OP Segment Subject Area"."OP Segment Transaction Information"."Amount of Payment Received"+"UI - OP Segment Subject Area"."OP Segment Transaction Information"."Amount of Principal Offset" BY year("UI - OP Segment Subject Area"."OP Segment Information"."Finality Date")) s_5 FROM "UI - OP Segment Subject Area" WHERE (("OP Segment Information"."Decision Date" <> date '1900-01-01') AND ("OP Segment Codes and Flags"."OP Type Code" <> 'B') AND ("OP Segment Codes and Flags"."OP Status Description" = 'ACTIVE') AND ("OP Segment Codes and Flags"."OP Cause Code" IN ('4', '5')) AND (year("OP Segment Information"."Finality Date") >= 1998)) ) SubjectArea2 ON SubjectArea1.s_1 = SubjectArea2.s_1.

Added on Aug 12 2020

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

1,402 views