BI Publisher
Discussion List
-
Do we have any option to download CSV File - rather than getting displayed in browser output ?Hi team, Do we have any option to download CSV File - rather than getting displayed in browser output ? Our data output file size is more than 100 MB , we want to downlo…Sridhar Gupta Yerram-Oracle 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Requirement to customize the Payables Selected Installments Selection data model to add new columnSummary: We have a requirement to customize the Payables Selected Installments Selection report data model to add new column, but the customize option is not available f…Shailender Ahuja-Oracle 61 views 6 comments 0 points Most recent by Kunal Vatyani Payables, Payments & Cash Management -
Retrieve all positive and negative balance associated with a customer.Hi Team, We have a requirement to generate a list of all customers whose accounts have either a positive or negative balance. Could you please provide a detailed explana…Harshini Amancha 21 views 0 comments 0 points Most recent by Harshini Amancha Receivables & Collections -
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 14 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can we find Customer Details from VAT ID in Oracle ERPSummary: How can we find Customer Details from VAT ID in Oracle ERP Content (please ensure you mask any confidential information): Version (include the version you are u…Rajnish Kumar Dallas 1 view 0 comments 0 points Most recent by Rajnish Kumar Dallas Receivables & Collections -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
I need to find who created or updated a BIP or an OTBI report and whenSummary: We need to find details like who created a BIP report or a Dashboard or an OTBI report and when. Content (please ensure you mask any confidential information): … -
how to invoke ESS Job Set from webservicesSummary: Trying to use SOAP WSDL and submitESSJobRequest Service. I am able to submit ESS Job but While submitting Job Set I am not able to.Please throw some lights arou…Aditi Agrawal2650 195 views 2 comments 0 points Most recent by AnanyaR-Oracle General Ledger & Intercompany -
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…Mainur-Oracle 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.Prince Choudhary 171 views 12 comments 0 points Most recent by Nimesha Yatigammana Reporting and Analytics for ERP -
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font …Harish Vummidi 2 views 0 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? … -
Excel template - with CSV Output -- Do we have an option to hide parameters ?Hi team, Excel template - with CSV Output -- Do we have an option to hide parameters ? -SridharSridhar Gupta Yerram-Oracle 21 views 3 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP -
Excel template- Why the column header is not copied into other sheet- for rec# > 65KHi team, When the output has more than 65K records - Excel output is getting generated with multiple sheets, but only the first sheet has column name, remaining sheets d…Sridhar Gupta Yerram-Oracle 1 view 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP -
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 51 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM -
query to get asset number under transaction information at subledger levelThanks in Advance ! -
Inventory Transaction Detail BIP Report-30 Columns-Item with Serial Control Enabled-65K LimitationSummary: Hi Everyone, We have a requirement from business to build BIP report for the Inventory transactions which they track manually at present. There are around 30 co… -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 121 views 0 comments 0 points Most recent by Carlo Reyes-59977 Reporting and Analytics for HCM -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 591 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da… -
What is the link between batch name and ESS job Import Journals ?Hello, We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch. We obtain the … -
Cannot generate "Open Purchase Order Analysis Report"When I tried to run the standard "Open Purchase Order Analysis Report," I noticed that it doesn’t have a layout and the data model appears to be empty. I’d like to under… -
SQL for ENABLED code combinations that have a disabled segment included.Summary: SQL for ENABLED code combinations that have a disabled segment included. Content (please ensure you mask any confidential information): SQL for ENABLED code com… -
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man… -
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…UrvashiJ 607 views 1 comment 0 points Most recent by Basavaraj Navalagi Reporting and Analytics for HCM -
In the BIP report I require Virtual Classroom Type from Learn ModuleSummary: Content (required): I need to fetch " Virtual Classroom Type " and respective Virtual Classroom/Classrooms.Which table field is to be mapped to get the below re… -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 233 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM