Reports
Discussion List
-
Hi Experts, having a requirement to send debrief estimates to Service request contacts.Summary: I am unable to get joins between debriefs(depot repair ) , Service request and RMA orders .I tried joining RCL_DEBRIEF_HEADERS. parent_entity_id with RCL_PARTS_… -
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 53 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
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 11 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 44 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 289 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 34 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 101 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 …
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 11 views 6 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM
-
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 11 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 Started 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 734 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 111 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.6K 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 43 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