Category 81
Discussion List
-
Facing Error when exporting to excel using the formatted optionSummary: When I export reports from OTBI into excel using the formatted option I receive errors stating 'We found a problem with some content in 'File Name'. This then o…Dannielle Dellucci 11 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Annual Leave Following Maternity LeaveSummary: Pick up if an absence spell directly follows a different type of absence, Content (required): In OTBI is there anyway to detect if an an absence spell directly …David McLellan 11 views 0 comments 1 point Started by David McLellan Reporting and Analytics for HCM
-
How to create Cross subject area analysis - real time (Checklist and Worker Assignment) - ErrorSummary: Error creating cross subject area analysis - Error View Display Error Odbc driver returned an error (SQLExecDirectW). Content (required): Error when joining sub…Luciavw 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Work Schedules OTBI - employee missing from analysis if no work scheduleSummary: Work Schedules - if employee does not have a work schedule they are missing from the analysis Content (required): We create OTBI analysis using Worker Assignmen…Michelle Hughes 91 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you please share with me Workflow/BPM tables in Fusion? Are there workflow/BPM tables for Cash AContent Can you please share with me Workflow/BPM tables for Cash Advances in Fusion? Following I found in Procurement 1.POR_AMX_RULES2.POR_AMX_PARTICIPANTS3.POR_AMX_DIM…
-
Work Relationship Last Update Date vs Current DateSummary: Hello - we are trying to create a Termination report that will be scheduled to run daily with the condition that the termination date equals Current Date OR the…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…Mohit Sinha-Oracle 61 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
Sequence Command for BI PUblisher eTextSummary: Sequence Command for BI PUblisher eText Content (required): Hi Folks, I'm using eText template to do payments, I need a unique id for each payment but for each …Eliel Douglas 42 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
How to create a view only Lease accounting Role ?Summary: How to create a view only Role for Lease Accounting that also provides a user access to run the following reports: i) generate lease liability analysis report i…
-
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…Ashutosh12 21 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can you set POVs to a Default selection in PBCS reporting?Summary: Content (required): I know each individual user can have their own personal user preferences that can default these dimensions to what they set, but I am lookin…
-
Service error when trying to generate XML output of a report which has three gridsSummary: Content (required): When trying to generate XML output of a report which has three grids and XML is not transformed, as shown below, and it downloads a file wit…
-
Can MR reports from Narrative reporting be launched via FCCSSummary: Is it possible to run a Management Report such as a trial balance that was developed in EPRCS from within FCCS? Content (required): We are shifting to MR report…Michael C Stefanavage 51 views 2 comments 0 points Most recent by Michael C Stefanavage Financial Consolidation and Close -
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 161 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 843 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 764 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How many columns we can have in data modelSummary: Maximum number of columns we can have in data model Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Nidhi Chhajed 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 541 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report for Performance DocumentSummary: Hi Folks, I would like to access a report that will display any 'transferred' performance documents within the Performance System. We would also like to filter …Sowmiya Velusamy 42 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 64 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM