Categories
- All Categories
- 76 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
we have two subject areas in ORC but unable to find Offer Extednded Date
Summary:
Hi Team,
we have two subject areas recurting real time and recurting events real time we unable to find Offer Extednded Date -column how can we find that column .
Thanks,
Ajay
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Comments
-
Any one help me on above column
0 -
Have you tried the 'Last Extended Date'? Please find below the navigation & SA details.
Hope this help.
Cheers,
0 -
Hi @Bhaskar Konar ,
yes, I tried above navigation also but not showing data, its blank,
any other ?
Thanks,
Ajay
0 -
In BI taken table -IRC_OFFERS Ir
column-TO_CHAR(ir.EXTENDED_DATE,'MM/DD/YYYY') as EXTENDED_DATE.
but we need OTBI ?
entire report ready but need above column also
Any one help me
0 -
The field I suggested ('Last Extended Date') is coming from the table: IRC_OFFERS and the column name: EXTENDED_DATE which is matching with your BI Publisher Report.
There's a chance that security or any other settings are restricting you to view the data in OTBI.
If you attach the Report XML / Catalog here, it can be investigated more.
Here is the session query for 'Last Extended Date' where you can see the source of the column.
WITH SAWITH0 AS (select T3105544.C437879003 as c1 from (SELECT V364958216.EXTENDED_DATE AS C437879003, V364958216.OFFER_ID AS C62087102 FROM (SELECT OffersPEO.OFFER_ID, OffersPEO.EXTENDED_DATE FROM IRC_OFFERS OffersPEO WHERE (((EXISTS (SELECT 1 FROM IRC_TEAM_MEMBERS M WHERE OffersPEO.OFFER_ID = M.OBJECT_ID AND M.OBJECT_TYPE LIKE 'ORA_OFFER' AND M.PERSON_ID IN (SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL))) OR (EXISTS (SELECT 1 FROM IRC_TEAM_MEMBERS M WHERE OffersPEO.OFFER_ID = M.OBJECT_ID AND M.OBJECT_TYPE LIKE 'ORA_OFFER' AND M.PERSON_ID IN((SELECT ManagerHierarchy.PERSON_ID FROM PER_MANAGER_HRCHY_DN ManagerHierarchy WHERE ManagerHierarchy.MANAGER_ID = (SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL) AND ManagerHierarchy.MANAGER_TYPE = 'LINE_MANAGER' AND ManagerHierarchy.PRIMARY_MANAGER_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN ManagerHierarchy.EFFECTIVE_START_DATE AND ManagerHierarchy.EFFECTIVE_END_DATE)))))) OR ((1=1)) ) V364958216 WHERE ( ( NOT ( (V364958216.OFFER_ID IS NULL ) ) ) OR ( (V364958216.OFFER_ID IS NULL ) ) )) T3105544) select D1.c1 as c1, D1.c2 as c2 from ( select distinct 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 75001
Hope this help.
Cheers,
0 -
0
-
I executed your xml without the DFFs and it is returning data for the 'Last Extended Date'.
It might be a good idea to develop a small report with Requisition & Last Extended Date and then see if the data is visible and then adding other columns one after another to see which column is creating issue.
Hope this help.
Cheers,
0 -
Sure, will check and update you on ?
Thanks,
Ajay
0 -
0
