Category 129
Discussion List
-
Can provide READ ONLY option for report/ layout and data modelSummary: Can provide READ ONLY option for report/ layout and data model Can provide READ ONLY option for report/ layout and data model?Narendra Prasad Golla 32 views 2 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP -
SQL query tunningHi, I have developed a sql query to get the balance for a couple of months ( it may be up to 12 months) and it's taking more than 40 mins and ended up with timeout error…
-
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a…
-
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor…Roman Havrylyak 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i…
-
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…G8rNtn 2.8K views 13 comments 0 points Most recent by Robert G Wilkinson Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
Default user name in ESS job parameter LOVSummary: We have created custom ESS job to invoke OIC integration using datamodel type - http. We need to pass logged in user's user_name as query parameter to integrati…Sumit Sengupta 519 views 3 comments 0 points Most recent by J Gatdula Reporting and Analytics for ERP
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 32 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Receivables - Transactions Real Time OTBI is not showing data for sales repSummary: Within the Receivables - Transactions Real Time OTBI subject area, we need the sales rep's name to be populated. This column is available, but it shows blank in…
-
Is it possible to grant access to a subject area from Administration/Security/Manage Privileges?Summary: If I want to grant access to all employees to one certain subject area (that really has no harmful or sensitive data 😄), is it then possible to give them access…Anders W. Langholm 135 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Risk Management Access Point Report was running more than a day. Is this correct behavior. ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nareshbabu Mallela 1 view 1 comment 0 points Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if…
-
Receivables Sales VAT Register for Italy ended in error without outputSummary: Dear All, I ran Receivables Sales VAT Register for Italy and Purchase VAT Register for Italy but they ended in error Content (please ensure you mask any confide… -
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se…
-
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li…
-
OTBI how to assign roleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Somchat Wattanaponwadee-185289 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 71 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP
-
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…Sesha Sailini 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …Madhu A 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Prakash.Malmarugan 111 views 6 comments 0 points Most recent by Kenney Reporting and Analytics for ERP
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 57 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
OTBI Analysis Subject Area to Extract Employee Data for Customer CreationSummary: What subject area(s) can be used to extract a list of Employees created in HCM who have not yet been setup as Customers in Receivables? Content (please ensure y…Francine Gemora 23 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…Venkat_P-Oracle 104 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I couldn't find the user entities that included the work structure dataSummary: I used HCM extract to extract person assignment and work structure data, but I couldn't find the user entities that included the work structure data (position,l…Salma Mohamed Salem 44 views 1 comment 0 points Most recent by Simona Chircu - Support Oracle-Oracle Reporting and Analytics for ERP
-
OTBI Remove All Rows SummarySummary: Content (please ensure you mask any confidential information): When exporting an OTBI analysis in the format of xlsx, the last row is a merged and centered tota…
-
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when …