Reporting and Analytics
Discussion List
-
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 21 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 52 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 31 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 1 view 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 41 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 21 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 41 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 22 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 41 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 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
How to hide Custom ESS Jobs from the end userSummary: We need to build a solution where we can hide the custom ESS Jobs created for running the integration reports. These jobs should only be accessible to the user …Kunwar Prashan Srivastava 31 views 5 comments 0 points Most recent by Mihai Nedelea-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 12 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 23 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 152 views 0 comments 2 points Started by Yvonne Park-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 21 views 0 comments 0 points Started by JanardhanP Payroll and Global Payroll Interface (GPI)
-
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…
-
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 31 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 12 views 0 comments 0 points Started by Ranjith Dammala Financial Consolidation and Close
-
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 21 views 2 comments 0 points Most recent by Sonia Canumay Fusion Applications Administration -
Managing PGP Encryption for Reports on sFTP ServerHi, We previously set up a daily scheduled transfer of reports to the sFTP server, using PGP encryption. Our customer now requests additional reports to be sent to the s…
-
Oracle ERP Cloud Essbase cubes clarificationHi everyone, Could you please share a complete list of Essbase cubes that can be enabled in Oracle ERP Cloud? Additionally, I would greatly appreciate any documentation …Michele_Mele 12 views 3 comments 0 points Most recent by Andrada-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 21 views 0 comments 0 points Started by Pranav Shourie C Reporting and Analytics for ERP
-
Limited Oracle Allow List IP's For Outbound Connectivity For Fusion ApplicationsSummary: Limiting Oracle BI reports direct transfer IPs Safe list Content (please ensure you mask any confidential information): Base on this doc "Oracle Allow List IP's…Kimberly Nguyen 51 views 4 comments 0 points Most recent by Kimberly Nguyen BI Publisher Learning Center
-
Transfer report not update in the mobiltySummary: Hi team, We changed our transfer report from the custom Folder and we saw that it's updated in the Human Capital Management and it's work there good.(From what …Guy_Ora 11 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Need Percentage and Costing Effective start date ColumnsSummary: Currently im working on cost of department report. Need the Table name where percentage and costing effective start date will be stored. Content (please ensure …Supraja Sunnapu 11 views 1 comment 0 points Most recent by Supraja Sunnapu Payroll and Global Payroll Interface (GPI)
-
Need help with contract printing/contract management module in oracle cloudWe've one seeded Contract Printing report but there is no data model attached to it. We need to add one Supplier address on the contract template in such a way that it p…Devyanshi Ghanghas 61 views 7 comments 0 points Most recent by Shylaja Shetty-189359 Enterprise Contracts
-
Customer Contact- Person Audit TableSummary: Dear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts…