Reports
Discussion List
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 12 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Is it possible to change time zone on CURRENT_DATE SQL filter?Summary We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content Hi … -
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 23 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM -
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see… -
DOR Workflow Notification CustomizationSummary: DOR Workflow Notification Customization Content (required): Hi All, We get a requirement like, whenever employee added their bank details in DOR, one approval n… -
Tables to get bursting output and delivery detailsSummary: Tables to get bursting output and delivery details Content (required): Hi All, Is it possible to get bursting delivery details? For example, which user the burs…Venkatesan 734 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! RavindraRavindr-Oracle 44 views 3 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM -
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 43 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation…Parag Hiremath 3.3K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 141 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM -
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 104 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …Sudarshan Uppara 132 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
SQL query need to be debugSummary: Hi all, The Query which I run is showing the field names and the data is not populating. please help me to debug the error. Content (required): Outer joins need…RamkumarKadhiravan 11 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
Is there way to get profile Strength number from the Skills and Qualifications pageSummary: We want to be able to get the the Profile Strength number from the Skills and Qualifications of employees from reporting? Content (required): Version (include t…Nizar Kassam 51 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI formulas to combine 2 criteriasSummary: Help on OTBI formula Content (required): I would like to create a formula that would allow me to get the AVERAGE individual bonus achievement BY workers and BY …Jacqueline GRANDIN 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 184 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM -
ZIP output file of an OTBIHi All, We have a requirement to zip the output file of an OTBI analysis before emailing. Is this possible? Regards,Vibha Pandey - Oracle 12 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I find correct security type to add to a role to run report?I have created a dashboard and a new role which I had inherited to another role. The issue though is when I go to run the report I get the following error which I know i…Aaron Reynolds 22 views 5 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 124 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante… -
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal… -
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
BPM Worklist Notification CustomizationHi , I want to edit the title information of the Absence Approval notification in the BPM Worklist. But is it possible and how is it possible to change the title only fo…Cansel Karasoy 245 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
pivot table sorting dataSummary: How to sort data in pivot table view Content (required): I created a report using a pivot table, but the data in pivot can be sorted in ascendent or discendent … -
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…Kumar, Nitin 14 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Registration Information OTBI columnSummary: Content (required): Hello experts, do you know the OTBI column name and subject area where finding the Legal Entity Registration Information fields? Please, fin…Valerio Curzi 11 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
WE have OTBI report On Prescreen questions but getting below errorSummary: HI Team, we have OTBI Report on Prescreen questions but getting below error only today onwords we getting (still yesterday working fine. ). Please find below sc…AjayKumar Maddipati 13 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM