BI Publisher
Discussion List
-
Disable online Output view for BIP reportsSummary: Disable online output view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report op…SayanDutta 41 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team…
-
BI publisher custom notification needs to be consolidatedSummary: We have created BI publisher custom notification for expenses approval. When the person submits the reimbursement request, the mail will trigger for the manager…Jebarsan Thangam John Durai Raj 71 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Expenses
-
Ability to create a Analysis report in OTBI from Manage External fileSummary: Hi How can we implement a process where a third party stores/sends/puts a file in a designated place, and we pull data from that file to create an OTBI report? …
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 41 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP
-
Customize create accounting jobHi, We have more than 50 ledgers and would like to schedule a create accounting program for all the ledgers. Ledger is a mandatory field while submission of the program …
-
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 521 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 351 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to get Payment Id and Invoices related to a posted G/L batch?Summary: We need to get the payments and invoices related to a posted batch and prints it (the invoice) in a custom BIP Report Content (required): We're working on a cus…Claudio Errecart 122 views 0 comments 0 points Started by Claudio Errecart Reporting and Analytics for ERP
-
find an approver from the setup tablesHi, We don't have any report or workflow to check the potential approver once Invoice adjustment is submitted by the user in Receivables Module. so I am trying to develo…Madhu A 43 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Were Does The 'Generate Audit Report' Data Model reside in BI Publisher.Summary: Hi there, Were Does The 'Generate Audit Report' Data Model resides in BI Publisher ? Content (required): Does anyone know where the data model linked to the 'Ge…
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 143 views 2 comments 3 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 584 views 7 comments 1 point Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 140 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP
-
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …Pritam Das 214 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 107 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP
-
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 31 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Tracking bounced back emails Print Receivables TransactionsAR invoices need to be delivered through email to customer email ID. Is there any tracking mechanism to monitor the bounce back? So that, a valid email address can be ob…Dhruvjoshi23 42 views 3 comments 2 points Most recent by Lukas Oleksiak Reporting and Analytics for ERP
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…Naga Hari Krishna P-Oracle 41 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Two basic BI Report QuestionsSummary: Hi - I am using a custom data model which contains a mandatory parameter. I have defined the report output to default to Excel. I have 2 questions - please see …
-
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend…
-
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table…
-
In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowedSummary: Hi R&A forum: In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ? See Code snippet. Thank you, Content (required): In a Data Mod…
-
ESS job for IICS web serviceSummary: IICS related ESS job in Oracle fusion Content (required): I have a requirement where I created an ESS with Webservice DM and created an ESS job. When submitted,…
-
Can you please help me to join AOR to ORC tables.Summary: Can you please help me to join AOR to ORC tables. Actually we are fetching HRBP and HR Administrator names based Legal employer, Country, Location and Organizat…Manabolu Swetha 21 views 0 comments 0 points Started by Manabolu Swetha Reporting and Analytics for ERP
-
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…Sahil Makhiza 61 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
Send Report to Employee That Have a Certain RoleSummary: Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for …David Rabalais 81 views 5 comments 0 points Most recent by David Rabalais Reporting and Analytics for ERP
-
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…Helen Thomas 240 views 3 comments 0 points Most recent by Helen Thomas Reporting and Analytics for ERP