To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Matrix Report with Pre-Defined Excel FormulasSummary: Once the report is downloaded if user modifies any value in a column then the dependent columns should recalculate the values based on the new value and excel f… -
Oracle Fusion Cloud ERP passwordless authenticationHi Team, Has anyone able to implement passwordless authentication for Oracle Fusion Cloud ERP using PingOne Identity platform?
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma… -
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…
-
Help finding FND_ATTACHED_DOCUMENT table in ApBicc PVO in FDI?I need some help to find out if a PVO exists that is accessible in FDI that contains the FND_ATTACHED_DOCUMENTS table - namely I'm after a column called "URL Attachments…
-
Moved: How to find number of days for a month in FRSThis discussion has been moved. -
To print the attachment conditionally in rtf based on PBREAKHi, I have one POC to be implemented where in the feasibility is to check if its possible to insert a page break in the batch slip report if the operation level attachme…
-
Moved: How can we use multiple account hierarchies for a single segment in a FRS report?This discussion has been moved.
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …
-
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…
-
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST …
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
About the table having Segment HyerarchyI want to use information about Segment Hyerarchy in GL with BIP but I am not sure which table I should refer to. If you know, please let me know.
-
Moved: Project Budgeting is done at resource level or task levelThis discussion has been moved. -
Moved: I am looking for a database table from oracle fusion for resourc override screen from work e…This discussion has been moved.
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…
-
BIACM data models not returning any valueSummary: We are building a data warehouse and needs to utilize the default models provided by Oracle via BIACM to extract values needed for this project. When started wi…
-
Where to get the file size of Work Order AttachmentI have created this query to pull the attachments for Work Order, I need to get the file size for each attachment. Is the object_size the right column to use to know the…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf template
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINE
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…
-
Add Supplier Name in Account Analysis ReportSummary: Would it be possible to add a Vendor Name column under the Account Analysis Report for all source related to Payables and Receipt Accounting? We have a custom r…
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…