Reports
Discussion List
-
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 Started 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 32 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 …
-
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas…Dae 95 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Can we use Line Manager Dashboard to build HR Dashboard by removing securityWe want to build HR Dashboard, however most of the metrics are already available in Line Manager Dashboard. So can we re-use Line Manager Dashboard by removing security …RahulMore 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
schedule or live execution discriminatingHi I want to ask you if there's a way in BI to discriminate if the execution of the report is live or scheduled? i would like to variate the template layout based on the…
-
Is it possible to employ User Variables in NR Reports?The EPM Reports documentation refers to using both sub vars and user variables to assign members (chpt 10 - Defining Members). I can see sub vars as an option in the mem…
-
Options for downloading report as ExcelAre there any options for customizing what's in the Excel document when downloading as Excel. For example, if I wanted to name the sheets something other than {report na…
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there …Parag Hiremath 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 29 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 263 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.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…
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…Asha Barnes 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Show Account Owner Name in Narrative ReportHello, We would like to show the owner's name of an account combination on an Expense report in Narrative Reporting. For example - When we select these values on the POV…
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…Suriaraj.Krishnamurthy 1 view 3 comments 0 points Most recent by Suriaraj.Krishnamurthy Reporting and Analytics for ERP
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 541 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Project Contract List Dashboard with Null Project NumberSummary: Hi In the analytics, there is project contract list dashboard. When we run this dashboard, there is contract with null project number. When we check in the UI, …
-
Is it possible to enable audit and tracking of all user activity?Summary: Business requires all user activity regardless of module and transaction within the Fusion SAAS ERP to be tracked. Is there a way to achieve this functionality?…