Category 81
Discussion List
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
what table stores payment date of quick prepayments?Summary: hi All , i need to get the below payment date for BIP but i am not able to get the table which stores this. Please help. i tried PAY_REL_PAYMENTS_VL PAY_PAYROLL…
-
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 170 views 4 comments 3 points Most recent by MFlannery Reporting and Analytics for HCM -
Unable to get requisition number value when combining with assignment subject areaSummary: Please find the report catalog , unable to see the value for Requisition number. I'm combining below three subject areas and for Recruiting I'm using Number of …
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 36 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 2 views 0 comments 0 points Started by Mamatha P-Oracle Reporting and Analytics for HCM
-
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the…Siddhesh Nisal 12 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…Nicolas-Vahman 35 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User unable to view Employee's address details in OTBI ReportsHi Experts, We have created a report using the subject area 'Workforce Management - Worker Assignment Real Time'. We got the other cloumn values except city, county, sta…
-
Is there a way to filter this way in OTBI?Summary: Content (please ensure you mask any confidential information): I'm extracting columnA from a table. It has both null and not null values. »»»Filter should only …Stefano_Mazzocca 14 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Report BI - double column headerHi, is there an alternative to RTF for making a report with two headers on the columns? Example I have these columns: Organization Tot Male Female Tot Male Female Org1 4…
-
Deeplink for line mamager to see direct reportee performance document.Summary: Hi Team, @Naga M -Oracle , I see below deep link will redirect to particular document in redwood version for line manager only when he is a document manager. 'h… -
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…zakir112443 42 views 1 comment 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for HCM
-
Outage for Import Oracle Fusion Data Extensions for Transactional Business Intelligence?On the documentation page discussing importing DFF fields using Import Oracle Fusion Data Extensions for Transactional Business Intelligence it mentions "Running the pro…Angela Montenaro 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)…
-
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 37 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
how to find is there any attachment with the anytime feedback?Summary: need to find whether a attachment is there or not with anytime feedback Content (please ensure you mask any confidential information): Version (include the vers… -
Is there a way line managers can view element entries?Summary: Is there any way line managers can view reports with element entries? I'd like to create an overtime report so they can monitor their reportees claims but it do…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 28 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 69 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9K views 122 comments 35 points Most recent by Virendra Reporting and Analytics for HCM -
Unable to add security permissions for HCM seeded report folderWe want to provide customized access to the seeded HCM report folders on the Reports and Analytics page, but we're unable to modify their security permissions directly. …fusionuser 10 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Hiding the settings icon in embedded BI dashboard via deep linkHi Team, to embed a BI dashboard within a custom icon without displaying the BI menu, we created a deep link to the dashboard (ref. How To Embed A BI Dashboard URL Witho…
-
Adding BI report dates prompt to dashboardSummary: Adding BI report dates prompt to dashboard Content (please ensure you mask any confidential information): Hi, I've a BI report which pull event data between two…Bhavna-Civeo 14 views 4 comments 0 points Most recent by Bhavna-Civeo Reporting and Analytics for HCM
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 41.3K views 183 comments 126 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 202 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult…Denise Izzi 17 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.1K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…Rama123-Oracle 15 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM