Subject Area -- Custom Column Formula Issue

JPorisVU

We have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time."

Results return on a data table, but when trying to build out a chart, two of the columns fail. This is the first time I've encountered such an issue. It appears that something in the custom formula is causing the results to balk.

Additionally, I used the Logical SQL to build a data model in OAC. The data profiled and previewed without issue, but when I pulled into a new workbook, it was not accessible. When commenting out the two columns, there was no issue.

I'm attaching the SQL here and would appreciate any advice or input.

Columns with Issues SQL.txt

John Hung-Oracle

Hi, To better serve you, I have moved your post to the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.

Moved to: https://community.oracle.com/customerconnect/discussion/819263/subject-area-custom-column-formula-issue

JPorisVU

Thank you @John Hung-Oracle , I wasn't certain if it would fall under that forum.