Category 385
Discussion List
-
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 918 views 12 comments 1 point Most recent by Ranveer.Tiwari-Oracle Applications Security
-
Need to trigger Custom ESS job rather than standard ESS job for sending Dunning LettersIn the Collections menu, under the customer profile, there is an option called "Strategies." Within this, there is a "Tasks" section with options like "Soft Reminder" an…
-
Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification…Katharina_Seidenfuß 13 views 0 comments 0 points Started by Katharina_Seidenfuß Reporting and Analytics for HCM -
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ…Patrick Chrabieh 32 views 0 comments 0 points Started by Patrick Chrabieh Reporting and Analytics for HCM -
Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 41 views 2 comments 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service
-
How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which…
-
Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …Ksimmy200 21 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service -
How can we join CST_INV_TRANSACTIONS table to GL tables in Oracle Fusion?I am having difficulty in getting GL information from the cst_inv_transactions table, is there any way to join these?
-
Equivalent Oracle Cloud table columns for the EBS HZ entitiesSummary: Could you please help us to provide the equivalent Oracle Cloud table columns for the below EBS HZ entities? EBS Table Name - Column Name HZ_PARTIES - CUSTOMER_…Nagendrababu Kanuru 42 views 2 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
List of data Masked/Obfuscated during P2T refreshWe need the entire list of data masked/obfuscated in Oracle Financials cloud during P2T refresh to share with customer to identify the masked/obfuscated data in the shar…AbdulBasith 41 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Applications Security
-
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …Tuhinaa Nanda 43 views 3 comments 0 points Most recent by Will Paddock -Support-Oracle Reporting and Analytics for HCM
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get the Error Details of the Import Auto Invoice Execution Report through queryI am trying to create the join to abstract the Data from the tables used in the Auto Invoice Execution Report but not able to extract. Currently Using same Tables used i…Mohit.Chandna 127 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
roles or privileges to enable a user to create Data Model via the Fusion OTBI web servicesSummary: I'm new to Oracle Fusion Cloud. We have a Service Account that we intend to use to create a Data Model in the Fusion reporting module (called OTBI that's bundle…Dinesh T 459 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Report to fetch employees that have not setup goalsHi, Does anyone have below- Report to fetch employees that have not setup goals (100% weight enforcement) for the goal plan applicable for current review period.Shyam Rajbhar 11 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Query to get Roles hierarchySummary: A query to get role hierarchy by role ode Content (please ensure you mask any confidential information): Want a query where i can pass the role code, and get al…Osama_Mo 105 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
FDI impact on SaaS Performance?Summary: FDI has been set up to do additional reporting. We´re worried about how it can impact on SaaS performance. Content (please ensure you mask any confidential info…DIEGO CT 51 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting and Analytics for HCM
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…Sharmava 31 views 2 comments 0 points Most recent by Sumit_Rautela Reporting & Analytics for Fusion Service
-
Oracle BIP Report Job ends in error: ORA-56733: logical I/O limit exceededWe have a customized report that when is scheduled ends in error: ORA-56733: logical I/O limit exceeded. What's weird is that when we run the report via the catalog with…User_APIIU 76 views 3 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Printing the pdf Attachment in Oracle fusion BIP report output.Hello All , I have a pdf file added in the attachment at Sales order line item level. I would like to extract the attached pdf contents from the server and print it alon…Nupur Thakur 288 views 2 comments 2 points Most recent by Sandeep S. Chauhan-Oracle Order Management
-
How to prevent users from editing and deleting Custom ReportsSummary: We have seen many instances of users deleting custom reports from the Custom Folders, inadvertently. We then had to restore those reports from backups from lowe… -
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…Rakesh Bahadur Thapa 41 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 46 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
Need to schedule the ESS Job set in fusion to run on 1st business day of the month.We have a scenario where we need to run the ess job set on 1st business day of each month . is there any way apart from user schedule where we need to manually update th…
-
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 58 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service