BI Publisher
Discussion List
-
Spain SAF-T chart of accounts mapping requirements. ?Summary: Spain SAF-T chart of accounts mapping requirements. ? Content (required): Hello Will you please let me know the mapping and report requierements ? If you can sh…martingabriel Kinovisques 41 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to migrate BPM workflow notification customization to another instance?Summary: How to migrate BPM workflow notification customization to another instance? Content (required): Hi All, I have customized the BPM termination approval email not…Venkatesan 56 views 5 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…ks1075 1K views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
Query to extract the last effective start date record for payroll elementSummary: Content (required): Hello experts, Please, could you share the SQL query to extract the effective start date loaded for a specific element in the employee compe…Valerio Curzi 583 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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 364 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 621 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 52 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 285 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 1 view 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 21 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 332 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 42 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 31 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 171 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 324 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 51 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…