Oracle Transactional Business Intelligence

Products Banner

we have two subject areas in ORC but unable to find Offer Extednded Date

162
Views
9
Comments

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

  • Bhaskar Konar
    Bhaskar Konar ✭✭✭✭✭

    Hi @AjayKumar Maddipati,

    Have you tried the 'Last Extended Date'? Please find below the navigation & SA details.


    Hope this help.

    Cheers,

  • Hi @Bhaskar Konar ,

    yes, I tried above navigation also but not showing data, its blank,

    any other ?

    Thanks,

    Ajay

  • 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

  • Bhaskar Konar
    Bhaskar Konar ✭✭✭✭✭

    Hi @AjayKumar Maddipati,

    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,

  • Bhaskar Konar
    Bhaskar Konar ✭✭✭✭✭

    Hi @AjayKumar Maddipati,

    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,

  • Sure, will check and update you on ?

    Thanks,

    Ajay

  • Bhaskar Konar
    Bhaskar Konar ✭✭✭✭✭

    Hi @AjayKumar Maddipati,

    Have you managed to resolve it.

    Thank You!