Reporting and Analytics
Discussion List
-
Req Approaval TaskWe need to extract data about ReqApproval task configuration for audit purposes. Since there is no schedule process for that, we need to manually prepare the query. We c…Rajinder Singh 19 views 4 comments 0 points Most recent by Rajinder Singh Fusion Applications Administration -
Tables for BI Consumer role, BI Administrator Role, BI consumer role in oracle fusion HCMSummary: Hi All, I need a table name or query for BI Consumer role, BI Administrator Role, BI Author role in oracle fusion HCM. Need to write a SQL query like, who have …Karthikeyan s-Oracle 81 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
PVO's not available for MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary Seems that there are no PVO's available for the GOP Tables MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORT which we need to have access to in PaaS…Sridhar G 54 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
How to View Goal Approval Status and Draft Goals in Backend TablesWe are currently troubleshooting an issue where we are unable to see goals that are in Draft or Pending Approval status in any of the standard backend tables related to …
-
Adjust the sorting of the graph label to show the start of the weekSummary: We need to adjust the sorting of the graph label to show the start of the week i.e. Monday instead of showing Week of the year. Eg. Is the Actual_Start_Date is …svasista 1 view 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Unable to find BICC PVOs for Tables OSS_ENTITLEMENT_PLANS and OSS_ENT_PLAN_ESTIMATESHi Everyone, Can someone please help me to get the exact BICC PVOs for the below tables: OSS_ENTITLEMENT_PLANS OSS_ENT_PLAN_ESTIMATES ThankyouRajneesh Kumar 21 views 1 comment 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 12 views 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Can I use FND_BPM_TASK_B table to fetch approver detail in leave transaction report?Summary: Does this table have all the relevant information updated in real time? Is it recommended to use it for approver details of absence entries? Please assist. Than…Vaishnavi Agrawal 12 views 6 comments 0 points Most recent by AnnaMorelli Fusion Applications Administration
-
Add Sign Key in BI Analytics for reportsHi Team, We have a requirement of adding Encryption and additionally sign the file using keys for a report output while placing the file in SFTP directory using Bursting…Sandipan Pal 12 views 1 comment 0 points Most recent by Sandipan Pal Fusion Applications Administration
-
Folder not found with BI Administrator Role in BIPSummary: I created a custom folder under the Shared/Custom location and granted access only to the BI Admin role. However, the folder is no longer visible—even to my own…
-
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 32 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 11 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 121 views 6 comments 0 points Most recent by Mihai Nedelea-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 62 views 6 comments 0 points Most recent by Kolikonda 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 32 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 28 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 3 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 22 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 22 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 11 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 32 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 21 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 31 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 61 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 100 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)