Reporting and Analytics
Discussion List
-
How to execute the ESS job of a custom BIP selecting HP TROY printerSummary: We develop the custom BIP report of AP module for check in US company. As the requirement, when we execute the report's ESS job, we would like to print the chec… -
How to Schedule a BIP Report Using a ADMIN User ID in Oracle FusionHello Team , I have developed a BIP (BI Publisher) report and now need to schedule it in the production environment of Oracle Fusion Applications. However, I want to sch…Voladri Saikiran 42 views 2 comments 0 points Most recent by Voladri Saikiran Fusion Applications Administration -
Need to get the Test notification email address from BPM WorklistSummary: Need to get the Test notification email address. This is needed to avoid the issue that had recently happened i.e., 1000's of emails were triggered to real emai…NagasaiM135 18 views 5 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Tracking of ESS Job Failures in Oracle Fusion Cloud - Need Best PracticesHello Oracle Cloud Community, We are exploring options to implement email notifications for ESS job failures in Oracle Fusion Cloud to alert our support team. .Our ESS j…Narendra_Chowdary 266 views 6 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Sql to fetch payroll costing results accountWe are writing a BIP report to fetch Account details from the Costing Results. Is there any SQL that can get these details after the Payroll is run?JanardhanP 54 views 1 comment 0 points Most recent by VIKURAMA-Oracle Payroll and Global Payroll Interface (GPI) -
How we can find the extract name and BIP report path using the flow pattern and task nameSummary: Hi All, I need assistance in identifying the Extract Name and BI Publisher (BIP) Report Path based on a given Flow Pattern and Task Name in HCM. Could you pleas…Raushan Tiwari-Oracle 36 views 1 comment 0 points Most recent by MandeepGupta Fusion Applications Administration -
Error encountered when running custom BI Report in Reports and AnalyticsError Details: "):access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID.") Navigation: Tools > Reports and Analytics > Shared Folders >…Ora_MCastillo 26 views 3 comments 0 points Most recent by Ora_MCastillo Fusion Applications Administration -
Receiving inspection Account Type & SubtypeSummary: Hi team, I want to define the Receiving Inspection account to be able to run the create accounting for receipt accounting with no errors. Kindly need clarificat… -
Unable to get data for Bursting even if no Bursting Parameters passedI am using below query. Requirement is to send email notification when :Mode of Report='Email' and this is working fine. If the :Mode of Report='Print' , the report shou…SWAPNIL D PATIL-Oracle 28 views 0 comments 0 points Started by SWAPNIL D PATIL-Oracle Reporting and Analytics for HCM -
Manually assemble Job Offer approve/reject linksWe are using Oracle Recruiting Cloud, and have highly custom requirements for our Job Offer approval workflow - both to the BI template and to the notification process. …Liz Pellegrin 26 views 1 comment 0 points Most recent by Andrada-Oracle Recruiting, Opportunity Marketplace -
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO…Rob Turner 17 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration -
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 57 views 4 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration -
How to add a tab and insert our report analytics in it.As the Lot Details (Red Line) in above image. We need to add a new tab and once the user clicks on the tab, It should display a BI Report table. Path: Supply Chain Execu…Pranav Shourie C 29 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Reporting and Analytics for ERP -
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 36 views 6 comments 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
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 68 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
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 35 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 9 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Set User General Preferences or FND_TIMEZONE/FND_TERRITORY/FND_CURRENCY at Site LevelWanted to understand, what is the way to have a single timezone, territory and currency set for Oracle Fusion Cloud (Inc. ERP, HCM, SCM, CX etc. all modules) environment…Priyanka Girdhar 137 views 2 comments 0 points Most recent by Bianca Culea-Oracle Fusion Applications Administration -
Identifying PO is not populated for Tax Lines in OTBI reporting ( Payables - Transactions Realtime)We are not able to Populate Identifying PO for Tax Lines in OTBI reporting ( Payables - Transactions Realtime)Sabarish Reddy Ganda 25 views 1 comment 0 points Most recent by Andrada-Oracle Tax Reporting (Direct Tax) -
Cloned ESS Job not populating job parametersSummary: Cloned ESS Job not populating job parameters Content (please ensure you mask any confidential information): we cloned a seeded ESS job 'Journal Entry Reserve Le…KDR 98 views 9 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
How to cancel or terminate all scheduled ESS jobs or BIP reports in bulkSummary:How to cancel or terminate all scheduled ESS jobs or BIP reports in bulk Content : We are reimplementing the Oracle SAS Fusion Financials & Procurements Common M…Singh Rupak 138 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
When does data move from WFTASKHISTORY to FND_BPM_TASK_HISTORY_B table?Summary: We are no longer able to fetch approvers name in report using FA_FUSION_SOAINFRA.WFTASKHISTORY table. It looks like Approvers information get archived to FND_BP…Chandrashekhar_Cholli 125 views 2 comments 0 points Most recent by Chandrashekhar_Cholli Fusion Applications Administration -
OTBI Succession plan - can't find fieldHello, I am working on an OTBI analysis and I'm having struggle finding some date fields. The subject area I have chosen is Workforce Succession Management - Plan Candid…Sara Suleiman 15 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 18 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Environment Usage Assessmentへのインプットとなるデータ量を確認する方法Summary: Environment Usage Assessmentのワークシートに記載する情報を環境から取得する方法はありますか? Content (please ensure you mask any confidential information): Orac…xochiai.Tatsuya3 51 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
How to Customize the sub-template for AbsenceApprovalNotificationTemplate?I want to change a couple of words in the content of "AbsenceApprovalNotificationTemplate" workflow notification. As the required place was not found in the AbsenceAppro… -
Tips for ensuring an up-to-date Hosted Named User Usage Drill Through ReportWhat is the Hosted Named User Usage Drill Through Report? Oracle Fusion SaaS customers are provided with SaaS Service Usage Metrics Reports that shows them commercial us…Yvonne Park-Oracle 439 views 0 comments 2 points Started by Yvonne Park-Oracle Fusion Applications Administration -
In User Lasy Activity details report some system users are coming along with the real usersSummary: We have developed a custom report to get the user last activity details.The report is giving system users data along with Real users , we are unable to identify…Bhavna Sharma-Oracle 38 views 5 comments 0 points Most recent by Anil Rout-Oracle Fusion Applications Administration -
Oracle BICC not providing PVO's for IEX tables of AR ModuleHi Team, Currently we are consuming Fusion FSCM data via BICC console for loading data to our warehouse. We are able to load all data related to Customer, AR Invoices ,R…Ranjith Dammala 36 views 0 comments 0 points Started by Ranjith Dammala Reporting and Analytics for ERP -
News and Announcements reporting on click rates?Summary: News and Announcements feature ability to find out how many clicked and opened to view. Content (please ensure you mask any confidential information): Is there …Sonia Canumay 27 views 2 comments 0 points Most recent by Sonia Canumay Fusion Applications Administration