Reporting and Analytics
Discussion List
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM -
How to get the assignment number from the time card entry page ?I have a requirement to get Assignment_Number from time card entry page and not on person level. please find screenshot for reference.AbhinavA 21 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.Shaarif_Hussain 1 view 2 comments 0 points Most recent by Loo Alex Reporting & Analytics for Fusion Service
-
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO…Rob Turner 11 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration -
Can Oracle Application Performance Monitoring (APM) track user events similar to Google Analytics?I'm exploring the capabilities of Oracle Application Performance Monitoring (APM) and I'm curious if it can track user events in a manner similar to Google Analytics. Sp…
-
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…Somasekhar Basetty -Oracle 11 views 1 comment 0 points Most recent by Rizwan.Ahmed009 Reporting & Analytics for Fusion Service
-
Is there a way to hide the views menu option from the My Approval Search page?We just want the users to see the quotes needing their approvals and limit their access on searching and filtering quotes from other regions and other sales users.
-
In Fusion HCM How can we check what security roles are assigned to user and who has assigned them?How can we check what security roles are assigned to user and who has assigned them?vikash4rv 51 views 4 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …Ashu Singh 57 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ritu123 43 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…Khalida Raffath 11 views 1 comment 0 points Most recent by Khalida Raffath Reporting and Analytics for SCM
-
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…Dinar 86 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
Roles/Previlage Usage-Remove unused Roles /Previlages from the UsersWe need the Report to extract the below Details to Remove unused Roles /Previlages. Example : 1.Role Usage : When is the Last date Role used by the User ( For example: I…JAGADEESH DS 32 views 6 comments 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.Alvin 21 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…Ritu123 11 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Analysis to monitor the average time of the CRM APIs response we consumeSummary: We would like to know how to create a report to monitor the average time of the CRM (Oracle Sales Fusion Cloud) APIs response we consume from all integrations. …Joan Rodriguez 21 views 2 comments 0 points Most recent by Umamaheswarareddy Ambati-Support-Oracle Sales
-
After migration of FR to reports is formatting issue where a row has expanded in height drasticallyAfter migration of FR to reports I have a formatting issue where a row has expanded in height drastically, but all row height parameters are correct. Any idea what could…
-
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …Vennela Valluri 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
how do you retrieve soc1 reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PFreeman 72 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
query to get address number via SourceSystem and SourceSystemReferenceValue (address).Summary: query to get address number via SourceSystem and SourceSystemReferenceValue (address). Looking for table_name to get the values of SourceSystem and SourceSystem…
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…StefanyD 78 views 2 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Fusion Service
-
How to get Audit Report of a Custom Object using Rest APISummary: To get Audit Report of a Custom Object using Rest API Content (please ensure you mask any confidential information): I want to get the Audit Report of a Custom …
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 11 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Using Filters for Items with Rank Functions in BIThe Rank function is used to get the order of the employee numbers and divide the groups by 10's. Can I use this group for filters and prompts? Please let me know how to… -
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…Anj M. 11 views 1 comment 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales
-
How to change the oracle AD account password without impacting the ESS JobsSummary: Hi , We have a requirement to reset the Oracle AD account using which most of the jobs are scheduled. So is there any option to change the password of the accou…cvidhya 31 views 8 comments 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Can we default multiple output formats while running standard reportSummary: Users want the report output to be generated by default in two formats - PDF and Excel for a standard report. These report formats need to be defaulted instead …User_3ZQZR 15 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration