To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d… -
Cannot open .xls output for a BI report with Excel Template when scheduling itHello, I have a report which uses an Excel Template and when executed it generates a .xls file. If I schedule this report then this .xls file is corrupted ie. user is no…
-
How to get user login history or user wise application usage of Oracle fusion applicationsHow to get user login history or user wise application usage of Oracle fusion applications
-
In which Fusion DB tables SaaS usage details are stored?We are trying to build an custom report similar to SaaS Service Usage Metrics Report for our Fusion instance. The report will need to display region wise/country wise li…
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.
-
How to select an employee's work email in OTBI and the worker will appear also if he doesnt have it?How to select an employee's work email in OTBI and in case he does not have such an email, it will display the employee without an email?
-
Can we get employee ID of salesperson in reportsHow can we get employee ID of salesperson in reports, From Opportunity, when we pull employee ID, its giving the employee ID of the Opportunity owner, but can we get emp…
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternity
-
Additional Information for Leave PlansDear All, Unable to find table/column value of "Additional Information" field regards absence accrual details Kindly let us know/share the table or column details which …
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to print space between currency symbol and priceHi, I have added the below formula in the rtf template to display the price along with the price currency code. Formula: Output $50 UNIT_PRICE & INVOICE_CURRENCY_CODE d…
-
How to integrate the analytics between Oracle Digital Assistant's skill and Oracle FusionSummary: So we have beautiful data in Oracle Digital Assistant and Oracle Fusion Service. We want to put them in the same dashboard. Content (please ensure you mask any … -
Bursting report in procedure call data setSummary: Content (please ensure you mask any confidential information): I have a requirement to insert/update the lookup code and print and deliver the PDF through email… -
How to add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…
-
Can we hold the Oracle SFTP for the scheduled BI report jobsWe have few integrations directly using Oracle SFTP to send the file to various vendors. Wanted to check is there a way to hold the Oracle SFTP delivery alone for the sc…
-
Norwegian number format displaying as text in BI publisher excel outputHi, I have a report which displays Amount, Rate and QTY columns (In Norwegian number format i.e., Decimal separator as ',' and thousands separator as '.') as part of the…
-
E-stamp & signature for Standard Reportshello, I need a solution to put E-stamp and Signature on standard and customized reports , for example Payslip report
-
GL Drill Down to Work OrderNeed a query to drill down from GL to Work Order. We need details of PO, Work Order Number, Quantity, Amount when starting from Journals. We are using Source = 'Cost Acc…
-
where to find the comments (Transaction Console Page) in backend?Please help me to find the tables for above snapshot
-
OTBI Report - Effective Start Date UnionI am creating an OTBI report to extract Union member, Union of the employees and the date from which the employee joined the union. I am using the following subject area…
-
DFF values not appearing in OTBIHow do you get a DFF LOV results values to appear in OTBI reports and analytics? Seems as though I am able to return every value and DFF results value field into the rep…
-
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or… -
Barchart in EPM Reports cannot be displayed properlyWe have a FR Report "Barchart_Report" which contains a Barchart and a Grid. This FR report can be generated with data in html & pdf. After migrate this FR Report to Repo…
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le… -
how to ftp a csv file with column headings without underscoreHow to send a FTP text file with heading First Name(two separate words) instead of First_Name.
-
Table containing Candidate personal informationHello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. We have a requirement to crea…
-
SQL to get both po with requisition and without requisition in a single queryHi All , I need a query to get SQL to get both PO with requisition and without requisition in a single query and the columns I am trying to fetch are below mentioned que…
-
BI Report for Receipt Accounting BU, Commodit Code as input parameter an get PR,PO,Receipt detailsHi Experts, Can someone please help in below requirement. I am looking for sample query and relevant table information where I need to pass date range,BU,LE and Commodit…
-
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…