Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,
Content
I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner.
I am able to get all the columns except offering name, need input on the same.
Code Snippet
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160"> <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Learning - Learning Management Real Time"" withinHierarchy="true"> <saw:columns> <saw:column xsi:type="saw:regularColumn" columnID="c7c5e135da2d592d8"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Specialization Activities"."Activity Name"</sawx:expr></saw:columnFormula> <saw:tableHeading> <saw:caption fmt="text">
0