BI Publisher
Discussion List
-
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati… -
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 51 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Need SQL for data model list of values for Time Card Time TypeSummary: I need to add a parameter to a BI Publisher Report that has the values from the Time Type field from the Time Card. I have the following SQL written for the lis… -
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep Chavda 233 views 0 comments 0 points Started by Rajdeep Chavda Reporting and Analytics for HCM
-
Geography Mappings in Oracle HCM CloudSummary: How is data from hz_geographies mapped to per_addresses for countries other than the US Content (required): I am working on a Peoplesoft to Oracle HCM Cloud imp…NathanParry 113 views 1 comment 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM
-
calculation card link with legal employerSummary: we are trying to fetch the below calculation card with specific legal employer Could you please let me know if any query is available or guide me on the linking…
-
OTBI Query not working with where clause in BI publisherSummary: OTBI Query not working with where clause in BI publisher We have query which works in BI Publisher with no where clause but when added with where clause the whe…
-
Cannot extract Moved to HR information from BI tables (Recruiting)Summary: Content (required): Hello experts, we need to track candidates under Moved to HR and Moved to HR date. Is there a BI table to extract this information? Thanks i…Valerio Curzi 21 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
OTBI plugin for officeSummary: BI Publisher tab disappeared from Word Content (required): I installed OracleAnalyticsPublisherDesktop-6.4.0-win64.exe, and it opened Word after the installatio…Maboagamo 82 views 17 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
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
-
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 173 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 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 124 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 236 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 932 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 114 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 61 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 36 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 122 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 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
-
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 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 42 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM