BI Publisher
Discussion List
-
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 22 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 13 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 -
Extract Specialisation, Spec Section, Course, Offering, Offering Section, Activity in 1 row?Summary: Is there a way to extract the Specialisation, Specialisation Section, Course, Offering, Offering Section and Activity in one row? Content (required): Is there a… -
SQL for Current approver of AP InvoiceSummary: We have requirement to find the current approver of AP Invoice if the invoice is under approval . We are using below query to find the current approver select A…Oracletechnofunctional 1.6K views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 812 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to call an OIC integration from BIP reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 577 views 16 comments 2 points Most recent by DahliaG Reporting and Analytics for ERP -
How to show parameter in exacel template in fusion bi reportSummary How to show parameter in exacel template in fusion bi reportContent In BI report datamodel, I have taken parameters and build report also. Now in bi excel templa…Soumya Goswami-Oracle 64 views 6 comments 0 points Most recent by ShitalRamteke Reporting and Analytics for HCM -
Can BI Publisher be used to send XMLs in UBL 2.0 format? If yes, please elaborateSummary: At my client all financial transactions in Receivables are subject to archiving at a 3rd party. The client wants to be able to leverage the Generate Bill flag o…
-
UBL 2.0 format trhough BI PublisherSummary: We need to send file to 3rd party vendor in UBL 2.0 format of all invoices (also not printed ones). Can this be achieved through BI Publisher? Content (required…SirilG 81 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to create Budget vs Actual and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
How do you increase the performance on a seeded report without losing functionality?Summary: The client complains of a seeded report running for 3 to 4 hours, e.g. Fixed Asset Register report and I would like to know suggestions on performance tuning or…
-
How do you add segments to seeded report in BI Publisher?Summary: I would like to customize a cost summary report in fixed assets by adding two segments (company and location). Content (required): Version (include the version …
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…Deepika Jain DJ 98 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM