Reporting and Analytics
Discussion List
-
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 52 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 51 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 47 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 81 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 3 views 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 31 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 73 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 71 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 11 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
item inventory availability quantitySummary: how could build an report to retrieve the item availability quantity based on organization_id, sub_organization, item_inventory_id and lot number. Content (requ…Mohammad Hussein 111 views 2 comments 2 points Most recent by Iker Barragán Reporting & Analytics for Fusion Service
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …Jignesh_HAE 33 views 3 comments 1 point Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
How to find all the relationship between contact and contact/account?Summary: Hi, How To get a report about the Contact/Account Relationships details with other contact/Accounts? can we get any SQL or subject area that can be used to fetc…
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 371 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service
-
where Knowledge advanced is in active use - understand the actual usage volumeHi, I need to create a report to review the current use cases where Knowledge advanced is in active use - understand the actual usage volume Regards, Meera