BI Publisher
Discussion List
-
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 231 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 574 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 235 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…Paul Morrissey 21 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Can we disable email notifications triggering with Outlook Integrations for ILT OfferingsSummary: Can we disable email notifications triggering for ILT Offerings with Outlook Integrations after running process "Sync Instructor-Led Training for Learning". Is … -
SQL Query - List Of Email-Notification DetailsContent We have a requirement to fetch all the Email-Notification Details (Recipient Email Address, Subject, Email Body Text., ) received by an employee. We have identif…Mano Haran-61126 1.7K views 4 comments 0 points Most recent by DevasishG Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 101 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs … -
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 21 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
I'm New to Extracts how can I Learn any reference .Summary: Hi Team, Hope all are doing well ! I'm new to Extracts but I want learn extracts , so any one help me how can i go to ? Thanks, Ajay Content (please ensure you … -
Does DEFAULT_EFFECTIVE_DATE column in GL_JE_HEADERS table includes adj dateWhen we run a report with accounting period from Jan 31 to December 31, 2024. Will the report includes adjusting entries posted on 13_Dec-2024 adj period? The accounting… -
is it possible to add mutiple image in RTF template for Oracle learning CertificateSummary: We have requirement to customize Oracle learning Certificate template and we need add multiple image in that RTF template. is possible add multiple images in RT… -
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a…AjayKumar Maddipati 21 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Philippines Statutory Report - Cash Disbursement JournalSummary: Philippines Statutory Report - Cash Disbursement Journal Content (please ensure you mask any confidential information): Hi, We are trying to get the details on …D Mandal 52 views 4 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global -
I am in search of a GL Transaction Detail query in SQLSummary: I am in search of a GL Transaction Detail query in SQL Content (please ensure you mask any confidential information): I need the SQL code so I can modify if nee…Mike.Myers.CDIPRODUCTS.COM 31 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Reporting on BPM SetupSummary BI Reporting on BPM SetupContent Hi Team, Hope everyone is doing great ! We have a requirement to create a report on BPM Approval setup . Is there a table that s… -
How to send output's for Import AutoInvoice(Execution Report) over email to usersSummary: we have a requirement to send output's for Import AutoInvoice(Execution Report) over email to users. Content (required): we have a requirement to send output's …User_FVJ8C 111 views 5 comments 1 point Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
Bursting BI Publisher HTML EmailHi Experts, I have created the Bursting Definition below for testing purposes. select har.REQUEST_ID as KEY, har.RUN_ID as TEMPLATE, 'en-US' as LOCALE, 'PDF' as OUTPUT_F…Paul Worsley 62 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is it possible to identify the user running a BIP report to use for dynamic content?Summary Shared-service users need to run letters generated for employees and the signature must be the user who is running the report. How can we identify the user?Conte… -
How to add a specific custom button to a page using Page Composer?Summary: How to add a specific custom button to a page using Page Composer? Content (please ensure you mask any confidential information): I have a custom button that li…Stefano_Mazzocca 554 views 1 comment 0 points Most recent by Vijay Shanmugam-Oracle HCM Redwood Personalization Helper Tool -
Need to fetch HOD comments in Performance managementSummary: I am trying to fetch HOD Comments in Performance task in Fusion HCM? And which table this comments will store? Generally, comments will store in HRA_EVAL_RATING…Venkatasivaiah 1 view 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records … -
AR Receipt accounting details query in oracle fusionSummary: does anyone have query for AR Receipt accounting details? Wanted query for getting Receipt number, account(gl code combination value), class, Credit amt, Debit …Sanmati Patil-Oracle 1.3K views 2 comments 0 points Most recent by Deepak Singal Receivables & Collections -
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…User_2025-02-11-12-30-38-982 1.5K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…Mike Borghoff 83 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Finding Issue date assignment rule on learning OutcomeHi everybody, i am trying to find the table where is stored the information available in a course learning outcome, in particular i mean the one that sets up the issue d…