Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report

Received Response
144
Views
6
Comments
Brennan
Brennan Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary:

Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report

Content (required):

We have loaded assignment EFF attributes using spreadsheet loader successfully and we are able to view the loaded data on the "Additional Assignment Info" page.

We also can see that records are inserted into table PER_ASSIGNMENT_EXTRA_INFO_M.

However, the OTBI report displays all the EFF column values as blank.

The subject area we use in the report is "Workforce Management - Worker Assignment Real Time".

Note: When we entered data on "Additional Assignment Info" page manually, the OTBI report displayed the manual input data correctly. It does not display any record if it is loaded via spreadsheet loader.


Is there any process we need to run in order for the OTBI report to show the loaded data?


Version (include the version you are using, if applicable):

Oracle Fusion Cloud HCM 22D


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    Brennan,

    Can you see any difference between the records created from UI and from HSDL in PER_ASSIGNMENT_EXTRA_INFO_M table?  

    Hi @Raghavendra Raghunath-Oracle ,

    Can you please help here?

    Thanks.

  • Brennan
    Brennan Rank 1 - Community Starter

    Hi @Mandeep Gupta

    I have compared both records (via manual entry and HSDL). They look the same.

    Thank You

    Brennan

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Hi @Brennan ,

    Can you please check the following note? Is there anything similar that can be explored ....?

    Document 2137038.1 (oracle.com)

    It might not be solving your issue but thought of double checking.

    Cheers,

  • Samarpan Das
    Samarpan Das Rank 1 - Community Starter

    Hi,

    Any update on this.

  • Brennan
    Brennan Rank 1 - Community Starter

    Hi All

    Thank you for your input.

    We have figured out why data is not displayed in the OTBI report after checking the NQQuery log.

    It is due to the assignment effective start date (PER_ALL_ASSIGNMENTS_M.EFFECTIVE_START_DATE) does not fall within the effective start date of Additional Assignment Info (PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_START_DATE) and the effective end date of Additional Assignment Info (PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_END_DATE)

    Data is displayed in the report after we updated the effective start date of the Additional Assignment Info (EFF) record as per the assignment start date.

    Thank You

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Hi @Brennan ,

    Glad you are managed to resolve the issue.

    Appreciate the detailed insight.

    Thank you very much.

    Cheers,