BI Publisher
Discussion List
-
Joining the Time Card Entry view hwm_tm_rpt_entry_v to wftask & wftaskhistory tablesSummary: I have a requirement to display the Rejected by,Rejected Comment & rejected date columns in my Time Card Status report. It is a BIP report. I am trying to join …Dharmendra Jha 366 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
How to show and hide BIP parameters dynamically based on the login UserSummary: How to show and hide BIP parameters dynamically based on the login User Content (required): We have different parameters and few parameters need to display base…Visu 629 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf… -
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 51 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 284 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Email bursting from HCM ExtractSummary: Email bursting from HCM Extract Content (required):We have customized the payroll costing report and trying to burst it based on the facility. We followed instr… -
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 2 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to move up one node in my xmlSummary: Getting data from one node up of xml Content (required): I have a template that gets the data from node . I need to also display columns from which is one leve…CKleu 11 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 336 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…HarishVummidi 81 views 5 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 41 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 32 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP -
DOR approval report gives cartesian product/wrong dataSummary: I am trying to fetch approver details of pending/approved document of records entries made by employee using attached query but it is always giving me the carte… -
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 172 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit… -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…Giuseppe Galluzzo 330 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Updating RTF for Element Register ReportSummary: There is an error on the Element Result Report that produces split lines for Person Number. I need to update the rtf to correct this. Content (required): When s… -
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 53 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM -
Work Schedule Report - Getting Hours On DateSummary: As per the screenshot attached. We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Ne… -
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c… -
Learning Activity Reconciliation Changes (Report is blank) Help requiredSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like… -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 445 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter?Summary: After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter- with "can select All" option? Oracle Fusion Application- BI Publish…UM~ 756 views 5 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…Mohamed Iqbal Jahangeer 279 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP -
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…Muthukrishnan-Oracle 91 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 383 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
Does the FND_TREE_LOG and FND_TREE_LOG_PARAMS table purge over time?Summary: Could you please confirm if Oracle purges data from FND_TREE_LOG and FND_TREE_LOG_PARAMS tables over time? If yes, then what is the frequency, and is there a se…Ankit_Bhadja 42 views 3 comments 0 points Most recent by MariCostache-Oracle Reporting and Analytics for ERP