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
-
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?… -
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe… -
How to get FCCS data to BIP?We have a requirement to get data from FCCS, to create a BIP report. Is there a way to add FCCS as a data source in BI?
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…
-
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv…
-
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…
-
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…
-
Creating a Batch in FRS (Oracle Cloud ERP)Summary Creating a Batch in FRS (Oracle Cloud ERP)Content Navigate to Work space for financial Reports I am trying to Schedule a Batch. I believe I need to create a batc… -
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…
-
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.
-
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 ? -Sridhar
-
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…
-
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… -
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…
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
Request for audit report for the changes done on BPM Worklist - FinGlJournalApprovalSummary: I am looking for a audit report for the changes done on BPM Worklist FinGlJournalApproval. We noticed some of the rules has been disabled by some user and we ne…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win… -
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
How to filter analysis date within current dateHi Experts, We're currently using "Receiving - Transaction Real Time" to create an analysis. and we want to filter on transaction date field that only display date on cu…
-
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…
-
Item number field is not reflected in the Procurement Requisitions Real Time subject areaI used the Procurement Requisitions Real Time subject area in OTBI to build a report. There is just one field in the underlying source data that is not reflected in the …
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…
-
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc… -
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …
-
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…
-
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…