BI Publisher
Discussion List
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, RamuVadde Ramu 62 views 3 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…Lavakumar 11 views 1 comment 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …Sudarshan Uppara 154 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …YUTA TOGASHI-Oracle 41 views 3 comments 0 points Most recent by YUTA TOGASHI-Oracle Reporting and Analytics for ERP
-
BIP Data Model with an Excel Data sourceSummary: I have a BIP data model with an HCM SQL data set/source and an Excel data set/source, which pulls the required data successfully. However, when I refresh the ex…Paul Morrissey 71 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Security feature for AR invoice print options available in view image button of transactionsWe have enabled password protection on AR invoice. When we using download button to save the AR invoice security feature is working as expected, But some of user using s…Siva Gollapalle 55 views 7 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
SQL query need to be debugSummary: Hi all, The Query which I run is showing the field names and the data is not populating. please help me to debug the error. Content (required): Outer joins need…RamkumarKadhiravan 11 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Activities of an offering is not shown in backend tablesSummary: There are 2 offerings in a course that we have made and the activities of one of the offering is shown in the backend tables but the activities of the other off…
-
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 211 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
Is there any report that can be produced indicating when a user logs in using a password or SSO?Summary: Is there any report that can be produced indicating when a user logs in using a password or SSO in fusion? Content (required): Report/SQL Version (include the v…Fazal Subhan 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
UNable to query fusion_mds.mds_pathsSummary: UNable to query fusion_mds.mds_paths Content (required): Hi Team, There is insufficient privilege error received when we try to run query against table fusion_m…Parag Hiremath 41 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Publisher version controlSummary: Version control repository for BI Publisher Code Content (required): We would like to know how we can achieve version control for BI Publisher reports and metad…Ram Shankar 115 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 132 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
Add external content and modify some part of the original oneHi, We would like to add external content (e.g, from Linkedin Learning) and modify some part of the original one, for example, the description. Is it possible to do it? … -
Need to disable password security pop-up feature for one particular BU in AR InvoiceAs part of business request we have enable PDF security feature on AR invoice, but we have disable this feature to one particular but it still asking password pop-up for…Siva Gollapalle 11 views 2 comments 0 points Most recent by Siva Gollapalle Receivables & Collections
-
We are trying to obtain a report which captures audit for customer bank account changes.We are trying to obtain a report which captures audit for customer bank account changes. We are trying to develop a BI report which show all bank account changes that oc…HiteshChugh 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to prevent those writing BI Publisher Data Models from who have ERP access to use HCM tablesSummary: We are trying to prevent those writing BI Publisher Data Models from who have ERP access from being able to use HCM tables and vice versa. Need to implement the…
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
Beginning Balance of Accrual in Absence Plan WrongSummary: Hello, I have an extract that uses the UE ABS_EXT_PER_ACCRUAL_UE. We have people getting an adjustment of 22 in their absence plan every 16th of June. This is d… -
Some Prepayment Invoice amount showing doubleSummary: Content (required): Dear All We have an query which will fetch the Prepayment Invoice details , the query is working fine , but it is noticed that some of the i…Shameer Muhammed P M 14 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for ERP
-
Database Item for Payroll Element Name in Fast FormulaSummary: Content (required): Hello experts, do you know the database item for Payroll Element Name in Fast Formula? We need to create eligibility based on people having …Valerio Curzi 21 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
Current HTML Markup values are not working after 23B updateSummary: I've added BIP report to the UI using the HTML Markup. However, when I entered its HTML Markup values, the dashboard is not working as expected. Upon checking, … -
oracle.xdo12c.xpath.XPathException error on Payslip templateSummary: oracle.xdo12c.xpath.XPathException error on Payslip template Content (required): Hi Team, Greetings! We are getting below error for few records from Payslip tem…Parag Hiremath 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What table to use to get data for checking the Stage Table Capacity Used for HDLSummary: I would need to build a custom alert to check if the Stage Table Capacity Used for HDL has reached over 75% . Content (required): Version (include the version y…
-
Where to find Deal Size (Sales Lead) in Subject Area of OTBISummary: I'm trying to find the Deal Size field of Sales Lead object in any Subject Area in OTBI for a report but I can't find it. Content (required): I'm trying to find…User_2025-07-18-06-07-44-367 51 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how to change datamodelSummary: Compensation demonstrative datamodel location Content (required): wich folder datamodel for demonstrative change statement is located to be changed with another…
-
Need query Last Supplier Payment >2 yearsHello, I would like to run a query in Oracle Fusion SCM but I keep receiving an error code “ORA-00907: missing right parenthesis”. I’m not sure if it’s because of an err… -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 31 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management