BI Publisher
Discussion List
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 81 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains … -
Add parameters to BIP report URLHello, Is it possible to add parameters to a BIP report URL? My report BIP URL: https://***/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=****%2FF… -
How to capture employee working as a manager in Employee details oracle BIP reportSummary: What is the table and column to capture working as a manager column, to write a employee details BIP report. Content (please ensure you mask any confidential in… -
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 25 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM -
Learning BIP Report Table LogicSummary: Hello, The current BIP Report we have in our org is based on the Learning Assignments Table (WLF_ALL_ASSIGNMENTS_V). However, we had an issue that a person was … -
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 11 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it… -
Enabling BPFM Notification and Template customisation for Goal ManagementHi Team, 1)Can we include BPFM in Goal FYI notifications? 2) How to bring supervisory in Goal FYI notifications rules in "THEN" Condition and which rule is triggering no… -
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report? -
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit… -
Seeded RFT changes take a long time to get reflected in worklistSummary: Hi Team, I've updated the Seeded RFT and it takes a long time(1 day almost) to get reflected in worklist Let me know for any process name to make the response t…Sowmiya Velusamy 31 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Attaching employee image in BIP notificationSummary: I need to attach employee image files in BIP notification . Is this feasible ? if not what are the other alternative solutions? Content (required): Version (inc…Debarun Baidya 21 views 2 comments 0 points Most recent by Debarun Baidya Reporting and Analytics for HCM -
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 296 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to …Kamini Kaushik-Oracle 32 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…CodySisson 136 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
In Approval Notification Assignment number needs to be hidden as Part of workflowSummary: Hi Folks, In Approval Notification Assignment number needs to be hidden/removed as Part of workflow notification. Kindly help me with action plan to sort out th…Sowmiya Velusamy 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 23 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM -
DOR Workflow Notification CustomizationSummary: DOR Workflow Notification Customization Content (required): Hi All, We get a requirement like, whenever employee added their bank details in DOR, one approval n… -
How to fetch list of reports linked to a security role?Summary: Required list of all reports linked to a security role or list of all the reports with their permissions. Content (required): Subject areas or query through whi…Geet 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
A better way to convert HTML entities to special characters in a BI report.Summary: A better way to convert HTML entities to special characters in a BI report. Content (required): I'm looking for a way to convert HTML entities to special charac…S.Watanabe0110-Oracle 46 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Tables to get bursting output and delivery detailsSummary: Tables to get bursting output and delivery details Content (required): Hi All, Is it possible to get bursting delivery details? For example, which user the burs…Venkatesan 734 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
PGPSummary: Hello, all the times we need to configure PGP the system need to receive the file send us the PGP. Now we are facing a new situation where we need to send to th…Nicola Petri 12 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Unable to find Organization goals Check Box in HCM tables.Summary: Dear , I want to know in oracle fusion which table I can find "Share this goal with your organization" .I was searched all goals tables but not found in table T…challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM -
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! RavindraRavindr-Oracle 44 views 3 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM -
Need SQL query to get absence leave requests which are in denied status.Summary: Hi Team, Can we have a SQL query to get absence leave requests which are in denied status. Thanks, Madhuri.Madhuri Brammadevara 359 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM