BI Publisher
Discussion List
-
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s… -
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…Manoharan 15 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ?Summary: How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ? Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud… -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 32 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM -
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 52 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…User_2025-02-03-21-28-21-735 53 views 3 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for HCM -
Need to display Employee Image in the BIP report outputSummary Requirement to display Employee Image along with employee details in the BIP report outputContent Hi All, We have a requirement to display Employee Image and wit… -
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 56 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM -
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with … -
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl… -
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 21 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM -
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m… -
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 31 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 41 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Oracle BI analysis - Relative deep links in interaction actionsSummary: Relative deep links in interaction actions Content (required): We are trying to add relative deep links to a big number of performance counter tiles. How can we… -
BI Publisher RTF template with Excel output merging rowsSummary: I have a HCM Extract which outputs as Excel via an RTF template. However on the output it is merging 3 rows for each row of data (see below screenshot). Does an… -
Custom SQL reports don't return data in another language anymoreSummary: Four users with the same security roles and Area of responsibility ran a report. 2 English-speaking users saw data, while the 2 French-speaking users no longer … -
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require… -
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont…User_2025-01-25-00-37-41-739 68 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 22 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM -
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 108 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro… -
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi… -
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 281 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM