General OBIEE

Get Involved. Join the Conversation.

Topic

    Nirmal Kumar L
    Syntax to fetch pending transfer details from Data_cache...
    Topic posted November 23, 2017 by Nirmal Kumar LBronze Medal: 1,250+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Customizing Reports, Data Models, OBI Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, SQL 
    41 Views
    Title:
    Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data
    Summary:
    Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data
    Content:

    Hi,

    We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.

    Thanks,
    Nirmal kumar