Reports
Discussion List
-
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen…Cansel Karasoy 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 11 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 …
-
"Failing to execute" report errorSummary: I get a "Failed to execute report due to an unexpected failure from the data source." error when running a report I was able to run previously. The report conta…
-
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 22 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…
-
How to use RTP in MR ?Summary: Hello , Recently we have a requirement to build a MR keeping the Year Dimension as RTP . However we want use same RTP (Enter Year) for both Current Year : Singl…
-
Project invoice table to subledger table joinSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):KOTTHURI ASHOKBABU 13 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
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 968 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. …Maddipati Ajay Kumar 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Reports (cloud) - calculations between lines of expanded segmentsSummary: I got a request for a report showing several blocks/segments of data using each time the same variable list of entities used in the rows. Each block would cover… -
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 54 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 61 views 3 comments 1 point Most recent by Maddipati Ajay Kumar Reporting and Analytics for HCM -
Financial Reporting Web Studio replaced?Summary: Hi all, I recall that I read somewhere that in the future "Financial Reporting Web Studio" will be fully replaced by "Reports". However, currently I'm not able …
-
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.9K 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 142 views 3 comments 0 points Most recent by Deepa Venkatesan 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 172 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Is there any way to obtain Report usage metrics/statistics?Summary: I am being asked to provide usage metrics/statistics for the reports we have built out in our EPBCS application. Content (required): I am being asked to provide…
-
Service Logistics OTBI OverviewSummary Presentation on the 3 Service Logistics Subject AreasContent Overview and sample reports for Service Logistics OTBI
-
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 11 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 222 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 11 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