Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Project, Task and Expenditure type details related with Team Time Card details

Received Response
61
Views
6
Comments
Gurupreet S
Gurupreet S Rank 1 - Community Starter
edited Apr 4, 2024 7:31AM in Oracle Analytics Publisher

Dear Team,

I trust this message finds you all well. We're currently working on a report to retrieve Team Time Card entries. Our objective is to include specific columns (Project, Task, and Expenditure Types) that are visible in the frontend.

In previous attempts to meet this requirement, I utilized the 'PJC_EXP_ITEMS_ALL' table. However, I encountered an issue where the highlighted values were missing when the Time card entries were not costed. Instead, null values were displayed in those columns. It's mandate for us to retrieve these values regardless of whether the entries are costed or not.

If anyone has experience working with a similar requirement, kindly share your insights. Your assistance on this matter would be immensely valuable.

image-7db79d8fc43aa-2dd1.png

Thanks & Regards,

Vamsi S,

Tech Consultant.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Is this about FAW or directly a Fusion product?

    If it's just Fusion, then you should ask in the forum looking after Fusion, because your question is about data and not a technical feature of the Publisher product.

    Fusion is covered in a parallel forum (lot of categories there, look for the best one): https://community.oracle.com/customerconnect/

    If it's about FAW, if you specify which part (you tagged HCM, just want to confirm), the question can be moved in the right location.

  • Gurupreet S
    Gurupreet S Rank 1 - Community Starter

    Hello Gianni,

    Noted on the same, Apologies for posting this question here.

    Yes, it's just Fusion. I'm developing a BI publisher report in HCM module.

    Thank you for the information provided and will post the same question there.

    Thanks & Regards,

    Vamsi S

  • Gianni Ceresa
    Gianni Ceresa Mod

    No worries, in case of doubts it's always better to post :D

    But asking in the other forum will probably get you a better answer, and faster, because many more people will know Fusion HCM and its data objects.

  • Gurupreet S
    Gurupreet S Rank 1 - Community Starter
    edited Apr 4, 2024 11:35AM

    Yes, I agree! 😅
    When attempting to post the question on the mentioned forum, I was prompted to change my display name from a randomly generated username to a more valid one, which I promptly did. However, I'm still unable to proceed past this point. PFA FYR, please help me with this.

    image.png
  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Apr 4, 2024 11:40AM

    Well … that's a strange priority: I would focus first in helping users and after in trying to get them set a user. And in the end, you are free to use any name you want, so even a random one works. But well …

    I really don't know how/where you can change your display name, mine was set already before they did deploy these forums 😅

    And maybe somebody will see this post and have an answer for you in here anyway.

  • Gurupreet S
    Gurupreet S Rank 1 - Community Starter

    Despite changing multiple times, I am unable to post my question. I will explore other alternative options, but thank you so much for guiding me through.