BI Publisher
Discussion List
-
SQL to get the list of permission assigned to Dashboard SectionSummary: SQL to get the list of permission assigned to Dashboard Section Content (please ensure you mask any confidential information): Version (include the version you …ISHWTW 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Public Holiday Report in BI PublisherSummary: Anyone has a sample SQL Code for the Public Holiday Report using BIP? I am currently having trouble connecting the PER_CALENDAR_EVENTS_VL to Node IDs to get the…User_2025-02-04-07-19-57-588 73 views 3 comments 0 points Most recent by Robert A Reporting and Analytics for HCM -
SCORM ReportingContent Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. Many thanks MelissaUser_2025-02-06-11-18-47-896 34 views 13 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Query to find the Certificates from Talent Profile, linked with Learn Course AssignmentsHi All, I've located the query to retrieve the Qualification Certificate from the Talent Profile and also the Learn Course Assignments. However, I'm unable to establish …
-
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
Table name for Assign As column in learning pageHi Experts, Can someone please help me with the table name for 'Assign As' column. Thanks & Regards, DineshDinesh Jaini 13 views 1 comment 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
Be Able to Select Desired Currency Before Running the ReportHi, Is it possible to make the user able to select desired currency before running a report built in BI Publisher? Adding a prompt on currency would convert the amounts …Lucian Hidis 31 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
I need help setting up an account hierarchy to allow business users to view it in the cloud GLHello Support Community, I need help setting up "Account Hierarchy Management" to allow business users to view it in the cloud general ledger. Currently, they have acces…Prakash Vattapalli 31 views 3 comments 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
BIP notification sender nameSummary: Hello Experts, We have a requirement where we need to update the Sender name of the notifications being sent thru BIP, for example, Payslip notifications or not…AprilleLyn 11 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Certificate Title LOV is BlankSummary: Certificate Title LOV is Blank in the Configure Catalog Defaults page. We have certificate folder the custom folder. We have also provided the required privileg…
-
SQL Query to get the AP Invoice Validation DateHi, We have a requirement to determine the Invoice validation date . Please help us to get the query for the same. We tried using creation_date of xla_events by joining …Hitha Harikumar 1K views 5 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management -
call bip report from Absence page and pass person_id as parameterSummary: I need to call bip report from Absence page and pass person_id as parameter Content (please ensure you mask any confidential information): Version (include the …Farah Alajou 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 11 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
Deeplink to Inquire on Detail BalancesSummary: We want to link from a BI Publisher and OTBI Report directly on the Inquire on Detail Balances Page with filled out parameters. It should be the same like it is…Yves Chassein 91 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Report to get list of all ESS jobs scheduled in FusionSummary Looking for a resuable report or query which can fetch details of all scheduled ESS jobsContent Looking for a resuable report or query which can fetch details of…MandeepKGupta 3.1K views 16 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Not able to pull recipient data for Bursting in ESS TableSummary: The expected recipient info of bursting report via ESS job is not shown in the ESS request tables. Below are the tables that we are using to pull the data. fusi…
-
Unable to print from ERP cloud to on-premise Print serverSummary: We implemented in Integration between Oracle ERP Cloud and On-Premise print server as mentioned in Doc ID 1964157.1 and completed all steps mentioned in above d…G Balaji 181 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
tempContent (please ensure you mask any confidential information) Version (include the version you are using, if applicable): Code Snippet (add any code snippets that suppor…Satheesh Nesamani 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i …Preeti Khondre 51 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
which table stores area of Expertise and Area of Interest in Talent ProfilHello, I would like to know which table stores Area of Expertise and Area of Interest in Public Info in Talent Profile page. Attaching the screenshot for reference. Rega…
-
Filter on Performance Documents Deep LinkSummary: Filter on Performance Documents Deep Link Content (please ensure you mask any confidential information): I have this deep link: It opens this page: Does exist a… -
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 61 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…GajavalliKoteswararao 11 views 0 comments 0 points Started by GajavalliKoteswararao Reporting and Analytics for HCM
-
Is it possible to use FBDI for adding some sites to an exiting customer?We created a customer but we need to add many sites to him, so we are thinking about using FBDI, but is it possibile for an existing customer to use FBDI just for create…