Category 81
Discussion List
-
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree… -
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…Divya Vaish 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
[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 28 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle 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 32 views 2 comments 0 points Most recent by Siddhesh_Nisal 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 41 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 11 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
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 41 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 11 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 31 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 22 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 77 views 3 comments 0 points Most recent by SarthakRohilla 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 22 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 12 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.8K 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 201 views 16 comments 0 points Most recent by THawkins_LGI 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 12 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 21 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…