Reports
Discussion List
-
How to get all attribute in one nodeSummary: Hi Experts, I need your assistance. I'm currently working on XSL files to get values in the XML files. I want to show all the attributes separately in one node.… -
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report
-
OTBI reportOTBI reportVineet Srivastava Graviton 25 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
Image reflecting differently in RTF Template and BI Report OutputIn RTF Template I have made the background transparent But in the BI Report Output it is coming as
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
PRJ: Print Option is not working in Project Overview Page in Project Financial ManagementDear Team, Print option is not working in Project Financial Management, does any specific setup is required for the same? Regards Prashant
-
Task Manager - Adding task to view reports from Narrative Reporting?Summary: What is the best method to give a user direct access to a specific report from the Narrative Reporting library? Is using a Basic Task and then providing the URL…some_oracle_epm_guy 61 views 2 comments 0 points Most recent by GS Financial Consolidation and Close
-
PBCS - Migrated Financial Reports to Reports, but no artifacts are displayed in the target folderTested the migration of an existing Financial Report to Reports by using the Migrate Report icon (for a single report). I selected a target folder that was created in th…
-
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 54 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 57 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…Sudha Gopal 385 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 41 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 182 views 5 comments 0 points Most recent by Gail Langendorf-Oracle 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 11 views 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 31 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 829 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…
-
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 132 views 4 comments 0 points Most recent by AP0410 Reporting and Analytics for HCM