Reports
Discussion List
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
was trying to fetch the date format as 01-Jan-2025 in bip getting an errorHey i have a requirement in the bip where the date format is 01-Jan-2025 and in the SQL of bip i have used the format like TO_CHAR(ele.EFFECTIVE_END_DATE,'DD-Mon-YYYY') …Kande Likhitha 45 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Changes only HCM Extract for Payroll payments extract always extracts full fileSummary: We currently have a full file extract which sends the Check payment details to bank and now the requirement is to change it as changes only file . I have taken …
-
Showing BLANK pages in EPBCS Reports (Management Reports) even with SuppressionSummary: In the main report of my Budget Letter Book, it is showing or printing (PDF) BLANK pages because of No Data or suppression on the Grid. It is displaying the Hea…
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…GopalS 341 views 1 comment 0 points Most recent by Catalina Soare-Oracle BI Publisher Learning Center
-
Using the results of an OTBI analysis to pass value to a second analysisSummary: I built an offer dashboard for our Talent Acquisition team to determine what we should offer internal candidates. The goal is to help them understand an appropr…Monique 31 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Table Names/ SQL Query to fetch the data for Other compensation from Manage OfferHello All, Someone please help on how to know the table for other compensation which can be found from MyClientGroups> Quick Actions> Manage Job Offer Please see below S…Joliver Caangay 122 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Query for Project Budget InformationSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …
-
How to add new columns in a Pivot table developed using BI Publisher extension.The requirement is to add calculation columns like Average and Variance in a BIP RTF template which has a pivot table. The calculation columns need to added after the pi…
-
USD_Reporting in different scalesSummary: Content (please ensure you mask any confidential information): Hello, We have the following question: The application we are implementing is a multicurrency wit…CarolinaRodriguez 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 1 view 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
BI Publisher - Obtain YTD / accumulated payroll balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…Visvanath-Oracle 11 views 0 comments 0 points Most recent by Visvanath-Oracle BI Publisher Learning Center
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 751 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
How does the per_person_names_f_ audit table get populated?Summary: I am creating a report to audit name changes in our system. This is so we can see where corrections happened, deletions etc. I have been using the per_person_na…
-
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 82 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle Reporting and Analytics for HCM -
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…
-
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…Camilla Crescenzi 114 views 4 comments 0 points Most recent by AP0410 Reporting and Analytics for HCM
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.7K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Possibility of uploading customized fonts in Management Reporting for FCCSSummary: We need to add customized fonts in the management reporting. The fonts available in the management reporting won't suffice our purpose and we need to add extra …Subramanian Karunamoorthi 21 views 3 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close -
How to get the FCCS Status dimension in SmartVew or Financial ReportingI am looking to build Data Status in Financial Report or Adhoc SmartView grid. Unfortunately, I am not able to fetch the status dimension. Is there any way we can build …Avinash Roy 44 views 5 comments 0 points Most recent by Avinash Roy Financial Consolidation and Close
-
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…Audrea Miller 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
FR To MR converted reports are not working with MemberAlias("Grid1", "Entity", A1) is not workingHello Everyone, As we are nearing to June and FR reports will be deprecated, today I have migrated fully functional FCCS FR reports to MR reports and all the reports whi…Srinivas_Madderla 21 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
FTE in Compensation Subject Area is not correctSummary FTE value is showing 5 instead of 1Content Hi All, I need your help. I am getting two different values for FTE in OTBI. One comes from Compensation Subject Area …Alvaro Couto 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas…JHaden3 71 views 5 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…Damien Curtis 92 views 5 comments 0 points Most recent by ChaitanyaBarge Reporting and Analytics for ERP