Category 129
Discussion List
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…Saikat1 23 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…abRoman83 11 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
oracle.xdo.XDOException: Template type 'etext' is not yet supported.Summary: DataException:[INSTANCE_JOB_ID=1343928] oracle.xdo.XDOException: Template type 'etext' is not yet supported. oracle.xdo.servlet.data.DataException: oracle.xdo.X…Toka Halawa-Oracle 161 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC…
-
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …KDR 171 views 6 comments 0 points Most recent by Neil Wanags Livingstone Reporting and Analytics for ERP
-
Need an help for SQL query.Hello experts, I need some quick help in for my Bi Report which is for Receivables Module - I have query in which it has three corelated subqueries. I want to use the ou…
-
How to output html stored in database as formattedI have a table column zmm_notes specifically where a column for the note text can be stored as formatted text, so the html tags to format are stored in the database. Wha…
-
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue?
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…Thomas De Leeuw 41 views 2 comments 1 point Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…AbdulBasith 31 views 3 comments 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Applying a date filter on a PVO extractSummary: As we have been using ERP, some of our PVO tables are getting quite large, while the data extracts normally have less than 1 million rows in them, the PECSV val…Dave Kekish 41 views 1 comment 1 point Most recent by Alexandru Burcea-Oracle Reporting and Analytics for ERP
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…SuniChacko 315 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
OTBI Agent generating report errorSummary: I built a new agent and it is set up to run as another user with full permissions. For some reason, every time it processes at its scheduled time, it appears to…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…Abhhishek42 438 views 7 comments 0 points Most recent by Ralph Aldrich Magno Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
From address change to display company domain in BPM workflow shows as "External mail" in OutlookHow to configure the BI publisher—> Administration—> Delivery configuration for Email delivery of all workflow emails from Company domain. Currently I have added the Fro…Priya_Ananda 31 views 1 comment 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
INV_ACCESSIBLE_ORGANIZATIONS_V View Not AccessibleThe INV_ACCESSIBLE_ORGANIZATIONS_V view that is used in our BI reports is previously accessible using other roles even without the Application Implementation Consultant …Czarina Morales 51 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …Czarina Morales 21 views 3 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
How to change the measures in the Chart based on the Dashboard promptSummary: Content (please ensure you mask any confidential information): We have a scenario involving three types of costs: A, B, and C, which have been added as measures…Kasthuri.S 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,…
-
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…Amanda H5KKO 670 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
PL/SQL Query to ADD Month to a Period NameSummary: I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.…Nitin Gupta_322 31 views 2 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 133 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 11 views 5 comments 1 point Most recent by Aishwarya1990 Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …