BI Publisher
Discussion List
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 206 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…SivaRamaKrishna-Oracle 31 views 3 comments 0 points Most recent by SivaRamaKrishna-Oracle Reporting and Analytics for ERP -
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We…
-
How to enable the File Data Sources in Oracle BI PublisherSummary: How to enable the File Data Sources in Oracle BI Publisher? The guide shows how to do it but we are getting the error (Fusion Middleware Administrator's Guide f…Raymond Alvizo 21 views 2 comments 0 points Most recent by Raymond Alvizo Reporting and Analytics for ERP
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?Summary: Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. …Abdulwahab-KFH 1.1K views 2 comments 0 points Most recent by Abdulwahab-KFH Reporting and Analytics for ERP
-
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 73 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 40 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 691 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 512 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 121 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 41 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…
-
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 158 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 262 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 132 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP -
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
-
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…User_2025-03-07-21-19-21-057 22 views 0 comments 0 points Started by User_2025-03-07-21-19-21-057 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 …