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 display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is… -
Data Model not working properly.We are converting the standard report into Customize Report including data model, when we modify the data model it does not effect and don't make changes. We use the gro…
-
How to personalize Schedule process screen?i am trying to personalize Schedule process screen but none of the filed is editable.
-
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 make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…
-
How to generate ESS Job output in multiple formatsHi, We have a requirement to send the output to the customer. We are able to send the output in PDF format without any issue. However; customer is looking for both PDF &…
-
How to access your Usage Metrics Drill-Through ReportSummary: Hi, I received an email that says that your usage report can be downloaded from My Services. This info is not clear for me. Kindly assist to access this report.… -
Can we add a parameter in the standard payable invoice aging reportwhile doing the Standard report customization, Can we add a parameter in the standard payable invoice aging report? If yes please provide the step details. we tried it, …
-
Invoice Print Template default format change from pdf to wordInvoice Print Template is customized and the default format is set to 'Word(*.docx) however when clicked on the view image button over the transaction the invoice genera…
-
Using BIP uploading the files to UCM serverHi using this document i was trying to upload the files to content server. Job is sucessfull and i got the content ID but unable to seach back the files which got upload…
-
OTBI Subject Area Security IssueSummary: For the subject area Workforce Management - Person Real Time, we have a user "Mark Eliot" who can view employee's personal information (eg: address) even though…
-
Table containing Candidate personal information(Recruiting module)Hello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. Need to create BI report on t…
-
Security of custom reports to be only appear to specific rolesHello, we made custom reports with specific details which should only appeared to specific roles, For example Report A only appear to employees with roles HR Specialist …
-
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 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.
-
Can we create custom DB package in oracle fusionHi, I would like to recreate a seeded package (AR_ARXA7ACCT_XMLP_PKG) with minor changes. Is there any possibility to create a package in SAAS. If yes, please help help …
-
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…
-
BIP to burst the file to SFTP Server with 0 KB in case there is no data extractedSummary: We have requirement to burst BIP report output to SFTP server with 0 KB size in case there is no data extracted after data model query being executed. Content (…
-
Sql to find weekdays between two DB dates in fusionI want the query for Fusion to find weekdays between two dates skip the saturday and sunday and give the subtracted days dates may be have differnce of 1 day or 10 days … -
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…
-
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …
-
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…
-
Not able to print columns in the rtf templateHi, I am trying to customize one of the seeded reports to add additional columns. I have added additional columns in the data model by creating a new group and establish…
-
Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed. -
Looking for PVOsSummary: Looking for PVOs under biacm for the below tables msc_sr_assignments msc_customers msc_customer_sites_msc_v msc_items msc_sr_source_org msc_sr_receipt_org -
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…
-
How to identify bit mapping for change_bitmap in EGO_ITEM_EFF_B tableIn Fusion Database we have table EGO_ITEM_EFF_B, everytime we make changes to EFF attributes change_bit_map column stores the information that which column is changed in…
-
How to reduce execution timeHi, I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.…
-
BIP Report to Get Last 30 Days User Login DetailsSummary: The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last l…
-
Moved: Is It possible to get out put In JSON Format for BIP ReportsThis discussion has been moved.