Reports
Discussion List
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 442 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP -
Track IP AddressContent Hi All, Is there any way to track IP Address of the user who has made changes and accessing fusion system? Thanks, Visu
-
we have issue in OTBI report CANDIDATE REJECTION REASONS but we miss the latest records in scheduleSummary: Hi Team, we have OTBI report thta is CANDIDATE REJECTION REASONS report for particular country when we schedule the report it's fecthing(Candidate Job Applicati…AjayKumar Maddipati 62 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How can we get the IP Address of a candidate after they have completed a Journey Checklist Task?Summary: Content (required): I need to get the IP Address for a person who has completed a checklist task. I understand that there is IP Address stored in IRC_CHECKLIST_…User_2025-07-18-13-29-11-469 72 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
EEO - Recruiting ReportSummary: Hello, I am hoping our community can share an HCM BI Publisher report that lists all applicant data for requisitions that had a hire within the past year. It mu…
-
Unable to restrict results with workschedule filters when it is blank or non primarySummary: Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employe…Sowdha Murugan 31 views 7 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Supporting Details Option Not Displaying On ReportsSummary: Upon setting the "Supporting Details Option" to display after the Parent member for my report, I am unable to see the supporting details when viewing my report …
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
FRS grid takes a long time to openSummary: Content (required): Hi We have a financial report around 2000 rows with Account, and 2 sparse dimensions on row, and scenario ,version, plan element, period and…
-
Helen Tilling 11 views 5 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 31 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Show all Lines in Report ExportSummary: I have a large OTBI report that I need to export, and I need it to show all lines. Usually I just change the Data Viewing under Table Properties to Content Pagi…
-
Audit Report using BIP and shadow tables for Assignment ChangesSummary: Looking for a custom BIP report query for Audit purpose using shadow tables. Content (required): We enabled the Audit for multiple products using the task 'Mana…
-
Facing issue in performance goal dashboard reportsSummary: Facing issue in performance goal dashboard reports Content (required): Hi All, We are facing the issue in performance goal dashboard report. Even employee has e…Venkatesan 22 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
In OTBI report when I schedule the report through agent to me or others all records not coming?Summary: HI Team, We have head count details report with nearly 41000 records and we are used only one subject area(worker assignement real time ) with 25 cloumns so iss…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F…
-
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Oracle Fusion SaaS Cloud Application ManagementSummary: Looking for pre-built dashboards to monitor your entire SaaS Application like Content (required): Hi Team, We are looking for pre-built dashboards to monitor yo…Spats 41 views 2 comments 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for ERP
-
Are there audit reports on EPM in classic version?Summary: Hi everyone! Some knows if on EPM classic enviroments there are reports with the following detail: Employee ID Username Full name user Last Access Date and time…
-
OTBI Agent Sender Name ChangeHello Experts, Need your help & suggestions for the below issue that we are facing recently. We changed the OTBI Agent Sender Name by raising an SR to Oracle Support. It…Bhaskar Konar 53 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need OTBI report showing all active employees AND whether or not they are enrolled in MedicalSummary: I have been asked to develop a report that shows all active employees (Assignment Status Type = Active) and include a column showing the medical plan name they …JHaden3 333 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Need help with CASE formulaSummary: I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is
-
Not able to add the BI report in View Analytic pageSummary: Content (required): Hi All, We have created a BI report and we want to add this report in the talent review meeting in View Analyst option, but when we are tryi…Faizan Rashid 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Is there any query/table/report that shows the list of published sandboxes and the changes madeSummary: Required to get the list of published sandboxes in the application and the changes done as part of the sandbox Content (required): Required to get the list of p…Nisha_Hegde 419 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h…User_2025-01-28-20-43-56-568 206 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 365 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM