BI Publisher
Discussion List
-
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…Riti Malhotra 41 views 3 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM -
When I search for a custom role code in the BIP report folder permissions, it throws an error.When I search for a custom role code in the BIP report folder permissions, it throws an error "No results are available for given search string". Any idea how to fix thi…
-
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 408 views 7 comments 0 points Most recent by Jye Yang Reporting and Analytics for HCM -
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l…Stefano_Mazzocca 24 views 4 comments 0 points Most recent by Stefano_Mazzocca 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 124 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha…
-
Query for HDL to purge DOR of terminated employees .I am looking for a report that generates HDL to purge /Archive DOR for terminated employees from certain date range .
-
Workforce Compensation BI Publisher Add Ins not functioning for Word or ExcelSummary: MSWord & MSExcel - BI Publisher Add Ins no longer functioning. Have uninstalled, reinstalled. Still not functioning. Content (please ensure you mask any confide…Lisa O'Kelley 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…Alex_Balanovsky 20 views 3 comments 0 points Most recent by Ankit Mahajan Reporting and Analytics for HCM
-
Bold letters are showing in PDF Output?Summary: We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, all the letters are…
-
Repeating Groups - Excel TemplateHello. Does anyone have any idea on how to make this kind of layout on Excel Templates using BI Publisher? How to make a repeating group like this? -
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma…Janardhana Kondaveeti 10 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM -
How to use Work schedule in Eligibility for Fast FormulaSummary: Hi Team, we have a requirement : We have a Absence Type- That should be eligible to only employees who are having work schedule A. How to make it possible in El…
-
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c… -
Journey Template reportSummary: Does anyone have a sample of a report that pulls all the configuration details related to a journey template? Content (please ensure you mask any confidential i…Shanna Oppenheim 5 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
In OTBI Multiple home email address to show in Single columnSummary: In OTBI, there is a requirement to display multiple home email addresses in a single column. In my case, two home email addresses need to appear in separate col…Shubham Kadam 29 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Is there a way to get attachment attached to questionnaire responseSummary: We need to fetch the attachment which is attached as response to a question. These questions are enabled under guided journeys. Please advise if we have any of …
-
oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: ErrorSummary: Hi, am getting below error in BIP level. oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: Error invoking round:java…Ranjith1166 26 views 4 comments 0 points Most recent by Abhinay Singh-Oracle Reporting and Analytics for HCM
-
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f…
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 1.9K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
BI Publisher Server host and Port NumberSummary How to get BI Publisher Server host and Port NumberContent Hello Everyone, I'm unable to login to BI Publisher RTF template using following url. Does anyone know…
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 140 views 5 comments 0 points Most recent by Liyaquath Ahmad Reporting and Analytics for HCM
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …