BI Publisher
Discussion List
-
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 100 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 281 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP -
Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… -
Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 167 views 8 comments 0 points Most recent by Satyam Roy Reporting and Analytics for ERP
-
Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 36 views 4 comments 1 point Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
-
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 11 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
scheduled proccessess in Fusion: need to fetch data for 2023 yearSummary: I have a request to provide a list of all processes which were executed in the Fusion system in 2023y Cotent (please ensure you mask any confidential informatio…Ann Djiyanova 22 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP -
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
ERP Secured ViewsSummary List of secured views to secure ERP data in BIP reportsContent Could you please let me know how can we secure data in datamodel for Financials data? We couldn't …User_2025-01-25-01-31-47-378 109 views 3 comments 1 point Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP -
Fin and SCM list views oracle BIPHI Team We need the Secure list views in Oracle ERP SCM and FIN modules as we need to use them in developing the custom BIP's. Regards PraveenPraveen Kumar P 11 views 2 comments 0 points Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP
-
Role/Privelege for Explain Plan from SQL Query on data modelOne of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports. "Error Msg = ORA-01039: in…Vijay Ramani VJ 90 views 4 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for ERP -
Purpose of BICC Incremental Prune time in MinutesSummary Look for real world advice, or best practice use of setting BICC Prune timeContent Hi, We are just starting to use BICC to extract incremental data from Fusion F…User_NQABC 623 views 3 comments 1 point Most recent by Varun Jain-Oracle Reporting and Analytics for ERP
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
Line Number and RA Document Line Number has different values in rcv_shipment_linesSummary: Line Number and RA Document Line Number has different values in rcv_shipment_lines Content (please ensure you mask any confidential information): Hello, We are …
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 11 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Calling Sub template -IssueSummary: calling Subtemplate from main template is working fine for one user and is giving error from another user. Content (required): We have created a custom job to r…
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 238 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
how to link to tables AP_INVOICES_ALL and POZ_SUPPLIER_REGISTRATIONS ?????Summary: i try to create bi publisher report ( report aging supplier ) i want to select supplier name and supplier number how i can ? Content (please ensure you mask any…User_L42D8 42 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
Unable to access attachments uploaded in workflow notification via hyperlinkAttachements uploaded in "Account Coding Workflow Notification" are getting saved as a content in BLOB column of a table rather than storing it as file in UCM. Hence it …
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 171 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
how to store the manual input parameter values for multiple session in BIP report.Summary: User wants to run the BIP report with same input parameter values again and again and our report has around 20 manual input parameters. So is there any workarou…Gaurav Paliwal 15 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
can we audit Allowed Email Recipient DomainsSummary: Auditing Allowed Email Recipient Domains Content (please ensure you mask any confidential information): A change has been made in one of our test systems to the…
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …Latha00 692 views 5 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 96 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
BI publisher nested group issueI have an rtf template in BI Publisher where I want to show all rows of data within a repeating group. My problem is, I need to do this outside of the end of the group, …
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 124 views 6 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 22 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM