Category 129
Discussion List
-
Missing Access for a COA segment in a FRS report for a particular userSummary: Business user is missing access to Geography segment values (in parameter) in all the financial reports. Only able to see three values in the parameter. Content…Akash Verma 47 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 143 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Does BICC support Extensible Flexfields (EFF) ? How do we extract information from EFFs ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Business Intelligence Cloud Co…
-
Do we have report which gives user is present in which approval workflowsSummary: We are searching for report which we can run by user name and the report should gives us details in which workflow approval user is present. Eg: PO , Req, Invoi…Nidhi Chhajed 53 views 5 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Is it possible to extract a single audit report for all the audit enabled products and objects?Summary: Is it possible to extract a single audit report for all the audit-enabled products and objects using the audit policy capabilities of Oracle Fusion? Content (pl…Shreshtha Kesarwani 65 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Is there a way to hide a specific hierarchy from being available to users when they run FRS reports?Summary: Is there a way to hide a specific hierarchy from being available to users when they run FRS reports? Content (please ensure you mask any confidential informatio…
-
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 43 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Does OTBI Scheduler return report in non-English?Summary: When we run OTBI in UI, it returns a report with all the colums in Japanese as we set the language preference to Japanese. However, when OTBI scheduler runs, th…CHIZURU SHIGA 21 views 4 comments 0 points Most recent by CHIZURU SHIGA Reporting and Analytics for ERP
-
General Ledger - Balance Real Time OTBI Report IssueSummary: We have used below columns in the report, it is not giving the data with below combination. "Natural Account Segment"."Natural Account Segment Code" "Natural Ac…FirozahamedSK 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 43 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
unable to get all the column values in Excel output in BIP reportSummary: Hi, When I run the BIP report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few col…Satish123 63 views 10 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the…Lucky Sharma 340 views 10 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP -
23D Table ImpactedHello Team, Can anyone tell me the List of Table that is getting depreciated or new table being introduced in 23D release of Oracle Cloud ERP. Thanks, Sandeep Shaw
-
Unable to get excel outputSummary: Hi, When I run the report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few columns…Satish123 12 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Include a row when column null in out of the box analysisI would like to use an analysis in OTBI but include the data when a column has a null value. What happens now is when I add the column and that column is null, the resul… -
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 24 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Can Oracle ERP Cloud BIP pulling data from external database to build report?Summary: Can Oracle ERP Cloud BIP pulling data from external database to build report? Content (required): Version (include the version you are using, if applicable): Co…User_2025-02-10-23-40-15-146 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to extract data from an xmltype columnSummary: How to extract data from an xmltype column that is in the table ZX_CONDITIONS Content (please ensure you mask any confidential information): I am trying to put …
-
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…Siva Gollapalle 104 views 5 comments 0 points Most recent by Nikki K Reporting and Analytics for ERP
-
How to query committed cost of projects?Using Oracle ERP/ FSCM, there is a requirement to add data related to "Project Committed Cost" to our data warehouse. We mostly use the PVOs to import data in DW, What a…SHAHRAM SALAMI 11 views 1 comment 0 points Most recent by Gershatprg Reporting and Analytics for ERP
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 81 views 2 comments 1 point Most recent by CathyK Reporting and Analytics for ERP -
Requisition Approval E-Mail Report Template changes is not getting reflected in output fileI have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the last update…Deepa Kumari 33 views 3 comments 0 points Most recent by Deepa Kumari Reporting and Analytics for ERP
-
create a net column on an analysis by subtracting two columnsSummary: I am trying to create a net column on an analysis using by subtracting two columns that are included on it. The Analysis is using the GL and AP subject areas. T…Tashi Temple-Wood 41 views 6 comments 0 points Most recent by Tashi Temple-Wood Reporting and Analytics for ERP
-
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…Joe B 139 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 128 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)?User_2025-03-28-20-51-35-346 73 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
ERP Cloud - Export Table Using Saved QuerySummary: is there functionality in ERP Cloud similar to OTM Cloud Export Table using query? Content (required): OTM has ability to run custom SQL query and extract resul…Roman Havrylyak 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 254 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Why is the PVO for project team members not appearing anymore in Oracle 23... versions?Hi, We noticed that the following PVO, used to extract data for project team members: FscmTopModelAM.PjfProjectDefinitionAM.ProjectTeamMemberPVO , does not appear anymor…