BI Publisher
Discussion List
-
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to… -
Delete Folder with permission set to Open in BI CatalogSummary: Able to Delete BI Catalog Folder Content (required): With admin user we created the following folder structure Shared Folders>Custom>Custom_1>DM_Reports>.... No…Sahil Makhiza 41 views 3 comments 0 points Most recent by Raghavan p-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…VarunG 453 views 7 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 180 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
How to make Blob Image circular in bi publisherSummary: We have a requirement to display image in circular in the output. Content (required): Version (include the version you are using, if applicable): 23A Code Snipp…
-
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 32 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 216 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 850 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 113 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 31 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 130 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 103 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
-
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
-
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 52 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…
-
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 32 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 741 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM