BI Publisher
Discussion List
-
Application Source website details informationSummary: Content (required): Hello experts, from BI, is there a way to extract website details for the Application Source object (Recruiting module)? For example, if we …Valerio Curzi 31 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Does the Oracle code 3 of 9 barcode (B39R00.ttf) work?Summary: Content (required): I'm trying to utilize the built in oracle barcode fonts but I have taken screenshots of the barcode and scanned them on online scanners whic…KevinCochran 122 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM -
Error on running an OTBI report after 22B being appliedSummary: We are facing issues in running a OTBI report post 22B upgrade. Please see the attached error and let me know how to resolve this issue. Content (required): Ver…
-
BIP - Joining multiple data sets into one data set with SQLSummary: Am I able to LEFT join two separate data sets in BIP into one data set using SQL, rather then using the traditional field link functionality? Content (required)…Paul Morrissey 209 views 2 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
ORA-00911: invalid characterSummary: Hi Everyone! I am trying to retrieve a transaction. Below is the SQL Query SELECT a.TRANSACTION_ID,b.TRANSACTION_ID, DBMS_LOB.SUBSTR(a.data_cache,2000),DBMS_LOB…ShawShankk 745 views 14 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for HCM
-
How to connect oracle cloud HCM data from microsoft power bi reportSummary: How to connect oracle cloud HCM data from microsoft power bi report Content (required): How to connect oracle cloud HCM data from microsoft power bi report Vers…RIfdhy Zain 109 views 3 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM -
SQL function to convert number into descriptionSummary: Content (required): Hello experts, do you know if there is a way to convert an amount into description? For example, in addition to salary amount 40.000 we need…Valerio Curzi 62 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Link between Balance and Primary details Element NameSummary: Link between Balance and Primary details element name Content (required): In Balance Definitions UI we have Primary Details Element Name. In which table/OTBI Su…
-
Oracle HCM BI Tabel for manager compensation plan approval statusSummary: Content (required): Hello experts, could you suggest the BI tables allowing to track workforce compensation manager approval status? In other words, we should b…Valerio Curzi 33 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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…
-
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 118 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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 106 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 32 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
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 23 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 23 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 43 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
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 54 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 46 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…
-
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 33 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 725 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
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…
-
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Need BIP query for Sensitive Information in Job Application ORCSummary: Which is the source table for National Identifier and Date of Birth under Sensitive Information? Navigation: My CLient Group >> Hirings >> Search Req Number>> C…
-
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 51 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM