Reports
Discussion List
-
user wants a report to show account mapping for income statement reportIs there a report I can run [for a specific report] that will show the account/dept [dimension members] mapped to each line item? Client auditors are requesting this. -
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 102 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Removing closed entities from the entity hierarchy without impacting historical data.Summary: We would like to remove the Entities from the respective hierarchy of the Entity Dimension from the period in which the entity got discontinued but the same ent…
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 81 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular…
-
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req…Sunil Pradhan 171 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…PrerakKhandelwal 31 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP
-
possibility to use URL for logos in ReportSummary: Content (please ensure you mask any confidential information): In report I see that a logo can only be an image which is uploaded to report. Is there a way to u… -
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIPCloud Solutions Architect 21 views 0 comments 0 points Most recent by Cloud Solutions Architect BI Publisher Learning Center
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…John Aitken 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
EPM Report to pull data from two different cubes having different membersSummary: We have two different cubes, PLAN cube and OEP_FS cube, one handles allocation process by capturing allocation assumption (number) for specific account as shown… -
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …