BI Publisher
Discussion List
-
ESS job for IICS web serviceSummary: IICS related ESS job in Oracle fusion Content (required): I have a requirement where I created an ESS with Webservice DM and created an ESS job. When submitted,… -
Identifying employees missing goalsSummary: We are creating an OTBI analysis to identify employees missing goals in the year 2022. As soon as we add goal plan information we are noticing that there is dro…
-
Can you please help me to join AOR to ORC tables.Summary: Can you please help me to join AOR to ORC tables. Actually we are fetching HRBP and HR Administrator names based Legal employer, Country, Location and Organizat…User_2025-03-07-21-19-21-057 21 views 0 comments 0 points Started by User_2025-03-07-21-19-21-057 Reporting and Analytics for ERP
-
How to use latest version of Excel template for BIP ReportSummary: How to use latest version of Excel template for BIP Report Content (required): Currently we are using Excel 97-2003 Workbook (.XLS) as Excel Template Extension …Sujeeth Chinta 121 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…Sahil_Makhiza 62 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Finding Reporting Fields - Compensation ModuleContent Hi all - my reporting team is working on finding some fields within our Compensation Module and are unsure how to best located them. For example, we are provided…Prudence K 102 views 9 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I have a requirement to add column to show Count of number of levels of direct and indirect reportsSummary: I have a requirement to add column to show Count of number of levels of direct and indirect reports I am not sure what logic to build. Please help. Content (req…Parul Sah 31 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
Expense payments being rejected by the bank because of incorrect addressWe have employees who need to be paid expenses into bank accounts which are not in the same country as their HR home address. The system allows employees to enter multip…
-
Does anyone have information about the Oracle stored procedure pay_balance_utility?Summary: Content (required): pay_balance_utility is mentioned in an Oracle doc but then the support team claims not to have access to any information about it. Version (…Scott Paulin 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
CMP_PERS.CUSTOM_SEGMENT7 Oracle HCM table nameSummary: Content (required): Hello experts, in which Oracle HCM table can I find the attribute CMP_PERS.CUSTOM_SEGMENT7? Thanks in advance for your time! Kind Regards, V…Valerio Curzi 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 41 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Send Report to Employee That Have a Certain RoleSummary: Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for …David Rabalais 93 views 5 comments 0 points Most recent by David Rabalais Reporting and Analytics for ERP -
Error message when downloading BI ReportSummary: Content (required): Hello experts, when downloading a BI custom report with some users I get the following error message: ORA-01847: day of month must be betwee…Valerio Curzi 51 views 9 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Oracle BI EE option missed in Data source while creating report?Summary: Oracle BI EE option missed in Data source while creating report? Content (required): Oracle BI EE option missed in Data source while creating report? Version (i…
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Examples of Termination reportsSummary: Content (required): Hello experts, please, could you share some examples of Worker Termination reports? Thanks in advance for your time! Kind Regards, Valerio V…Valerio Curzi 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for getting list of all Customized objectsIS there a report which can list out all the objects on which either Page Customization or Customization via Designer Studio was done?
-
Need table to get position headcount from Manage position pageSummary: Need table to get position headcount from Manage position page Content (required): Need table to get position headcount from Manage position page Version (inclu…
-
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…Helen Thomas 371 views 3 comments 0 points Most recent by Helen Thomas Reporting and Analytics for ERP
-
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…Rajib_Samanta 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to adjust a query to return only work email address and add Person NumberSummary: Hi, I'm looking for some help to adjust the below query to only return work email address (W1) and if possible add in Person Number Content (required): select E…Sharon Ferguson 766 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to encrypt the bip report response with SOAP web serviceSummary: Hi Experts Currently the response from the SOAP web service returns the BIP report data in base64 encoded format but I want to encrypt the response in some othe…
-
How to send large attachments in BIP email deliverySummary: How to send large attachments in BIP email delivery Content (required): Email delivery failed in BIP for large report output. Below is the error, 'emailOutbox r…Ananya Sadhukhan 174 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Layout name in the report output file nameSummary: When report is exported to Excel, the report name is concatenated with the layout name, to arrive at the report file name. Content (required): What are my optio…