BI Publisher
Discussion List
-
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…KDR 21 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM -
BI Report job success but email not deliveredHi, We have come across an issue with one of our bursting reports wherein the Report job is showing as Success, but the email is not being delivered. Can someone help wi…Praneeth K 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 35 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Reports return SQL error since applying security profileHi there, Since doing a restructuring of the business, we applied a person security profile to one of the HR roles so that they could only search for and work with peopl…Matt Corserv 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Extract Layout Templates in ReportSummary: Hi, Is there a way to extract the details of Layout Templates in a Report? The client wants to extract all layout details of their reports as Excel for their re…Ralph Aldrich Magno 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …S.Watanabe0110-Oracle 11 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How to track the number of requested feedback via BI PublisherSummary: How to track the number of requested feedback via BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to generate a re…Barile Alberto 33 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Select data which are displayed on the All-In-One EvaluationSummary: As per customer's request, I'd like to make a BI report that selects the data displayed on the All-In-One Evaluation. Content (please ensure you mask any confid…S.Watanabe0110-Oracle 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 83 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versaSummary: Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versa Content (please ensure you mask any confidential information): Currently the reporti…Akhil M 61 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Limitation on XDO Tags in BI Publisher Excel TemplatesSummary: The number of XDO tags within our BI Publisher Excel template has exceeded 1000. We are unable to generate additional tags, which is hindering our template desi…Tauseef-Oracle 56 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI - Reverse geocode time events via sqlSummary: Hello, Is there an sql package available for cloud customer regarding reverse geocoding?. Content (please ensure you mask any confidential information): We are …Paul Buna 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …Sinem Kara 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
need build a logic to pull only the approved time cards for that particular month.Hi We need to build a report to get the approved time cards for Payroll processing i can only find hwm_tm_rec which captures the data. How can i consider only approved t…
-
BIP Report Status DashboardSummary: BIP Report Status Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple flows wh…Parag Hiremath 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Security to Compensation ModuleContent Hi all - we have created a report that pulls compensation module details through BIP. We are using secure views, but when I sign in as the line manager to view t…Prudence K 28 views 8 comments 0 points Most recent by Claudia Schiff Reporting and Analytics for HCM -
AR Trial Balance ReportCustomer wants a details report for AR Trial balance report. We tried but we are facing issue in opening balances. does any one have the same report. please share in thi…
-
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for…Parag Hiremath 21 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…Swati U 471 views 7 comments 0 points Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need a subquery that returns whether the manager filled out an assessment of the employees' goalsI need a subquery that returns whether the manager filled out an assessment of the employees' goals - from which tables can this be retrieved? In Oracle HCM Explanation …Alex_Balanovsky 11 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 44 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How many reports are there in systemSummary: can we create a report with the followed fields Report Name, Folder or path where, creator, who has access/visibility to it Content (please ensure you mask any …
-
Content Status - Correct common lookup typeSummary: Hi, Content Status - For fetching the exact content status names, we see there are two lookup types available. Neither of them have the complete set of data tha…
-
How to fetch all sites linked to a particular customer using querySummary: How to fetch all sites linked to a particular customer using query Content (please ensure you mask any confidential information): Version (include the version y…Neelesh Varma 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …Dara Nagasai 31 views 0 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 11 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 2.3K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
Content Type - Web LinkSummary: What is the correct mapping for content weblink for a web based content type. We are mapping the Web link from table - WLF_LI_CONTENT_F and field - STARTING_URL…