Category 81
Discussion List
-
How to join cmp_stock_details & hrc_integration_key_mapSummary: We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_ma…Niharika 14 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…Jbow 54 views 1 comment 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM
-
How to export OTBI Dashboard Section Permission?Summary: I am looking for an option to export the permissions granted at each section level. Is this possible? I attached the screenshots. I appreciate your help. thanks…SantoshKumarBhairi 11 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Change in the environment from production to test in links to reportsHi, We want to change links to BI PUBLISHER reports within the dashboard. When we do P2T we need to go through all the links and change them from the production environm…Alex_Balanovsky 32 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Customize option is not visible.Summary: Content (please ensure you mask any confidential information): Cannot view customize option on talent fyi notification record. is there something i'm missing? V…Pranjal Mohla 173 views 2 comments 0 points Most recent by Pranjal Mohla Reporting and Analytics for HCM -
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
Oracle BI Tables to retrieve manager hierarchy level and Plan Access LevelSummary: Content (please ensure you mask any confidential information): Hello experts, which Oracle BI tables allow me to retrieve manager hierarchy level and plan acces…Valerio Curzi 32 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In past we get all questions from prescreen questions report but now two questions missing ?Summary: HI Team, In past we get all questions from prescreen questions report but now two questions missing ? any refrence and help me on . Please find issued SQL file.…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Representing the data in graphs using custom formulas and logics in OTBI Dashboard.Summary: Representing the data in graphs using custom formulas and logics in OTBI Dashboard. We have a requirement to create a graphs in OTBI using the Absence Balances,…Bhukya Vamsi Naik 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 680 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Database items for Minimum and Maximum Input valuesSummary: Content (required): Hello experts, which database items allows me to extract the attached information (minimum and maximum input value). Thanks a lot in advance…Valerio Curzi 22 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How do you retrieve Payroll Relationship Close date into report in OTBI?Summary: Content (required): Looking to include close date off the payroll relationship field into an OTBI analysis report, I have looked at a few subject areas but this…
-
Is there a way to show only data for a user that is running a dashboard?Summary: I have created a dashboard for several reports. It shows the user that last updated a record. Is it possible for the user that runs the dashboard to show only r… -
Need to export Cost Center info using FiveTran. Does anyone know which object this exists on?Summary: I think it should be in an object called assignmentDFF (that is where it is found using Rest API), but I don't see a corresponding table. Content (please ensure…Derek Horrall 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need Workforce Learning - Learning Management Real Time BIP tables with Attributes/DFF valuesSummary: Unable to find BIP tables with Attributes/DFF values in Learning module. Content (please ensure you mask any confidential information): Seeking help in finding …VenkataSubbareddy 61 views 6 comments 0 points Most recent by VenkataSubbareddy Reporting and Analytics for HCM
-
Can we dynamically change paramters value in each execution run of scheduled BI report.Summary: We want to change the report paramter value in each execution run of scheduled BI report. Content (please ensure you mask any confidential information): Version…Sourabh_Patial 34 views 4 comments 0 points Most recent by Sourabh_Patial Reporting and Analytics for HCM
-
OTBI Report Source System Item Real TimeSummary: When i join Item Number and one of my EFF attribute in Product table i am getting one extra row in EFF table which is all blank. Do you know what might be the i…Ankit Shah 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that…
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 70 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To check if the requisition has Suspended state completion eventsHi, We had an issue in FAW, where for some requisition the suspended completion duration is missing. While debugging this issue, we are trying replicate the same in FA, …
-
Help with Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject AreaSummary: I'm looking for help with a Case Statement using Payroll - Payroll Run Results Real Time OTBI Subject Area. Content (please ensure you mask any confidential inf…
-
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 42 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 22 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 75 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM -
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …Salma Mohamed Salem 22 views 1 comment 0 points Most recent by Alexandru C. -Oracle Reporting and Analytics for HCM
-
Retrieve payroll elements amount increasesSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve the payroll element amount increases? For salary basis,…Valerio Curzi 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 376 views 3 comments 0 points Most recent by Jye Yang Reporting and Analytics for HCM -
Create an OTBI analysis based on Personal Details Quick actionSummary: We have created a new DFF field in Biographical info tab in the Personal Details Quick action page. Content (please ensure you mask any confidential information…Ayesha Iroshani 31 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…