BI Publisher
Discussion List
-
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 624 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to display the output of a BIP Report in multiple excel sheetsSummary: How to display the output of a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we created a BIP Report, w…Barile Alberto 304 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Output file name along with current dateContent Hi, Can someone help me how to add date in the output file name of BI report while downloading directly from BI catalog? ex: Employee Detailed Report_yyyymmdd.xl…Nivya Mathire 545 views 8 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Oracle cloud HCM sql queries to fetch details of employees who left the organization(ex-employee)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Srujana Reddy 47 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'…
-
I need sql query to get employee timezone like employee working timezoneI need sql query to get employee timezone like employee working timezoneLakshmiVanarasi 14 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What is the table name of evaluation comment during "Share and Release" phase?Summary: What is the table name of evaluation comment during "Share and Release" phase? Content (please ensure you mask any confidential information): During performance…Stefano_Mazzocca 23 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
How to run Generate Prenote File report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report Generate Prenote File report of payroll module of HCM. But I don't know how to run this report. Thanks Content (…VAIBHAV L 33 views 6 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How to filter the employees basing on their Grade in a BIP ReportSummary: How to filter the employees basing on their Grade in a BIP Report Content (please ensure you mask any confidential information): Hi, we created a BI Report. Amo…Barile Alberto 13 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
BI table to retrieve Approval Status field in Workforce Compensation moduleSummary: Content (please ensure you mask any confidential information): Hello expert, do you know in which Compensation BI table is stored the highlighted value? Thanks …Valerio Curzi 11 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Connection time out while scheduling BIP reports post 24C upgradeHi All, We are getting Connection timeout issue while scheduling BIP reports. This is something we are experiencing post 24C upgrade. Does this has anything to do with N…Satyabrata Nanda 65 views 2 comments 3 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
PER_POSITION_BUDGETS is showing no data. Need Position Budget FTE for custom report.Summary: We need to add Position Budget FTE in a custom report but PER_POSITION_BUDGETS has no data. Do I need to add any role for this table to do we get this informati…Punnya Vijayan 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 44 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 131 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …Vishnupriya 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 54 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Manage Enterprise HCM InformationSummary: Hello everyone, I have a report about Manage Enterprise HCM information. Can anyone advise on how to pull the corresponding columns? You can find them by naviga…Chris Carloff 42 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
immediate updates of information to a PDF outputSummary: I have a question about how to get immediate updates of information to a PDF output of a BIP report. Content (please ensure you mask any confidential informatio…Keita Furuya 2 views 1 comment 0 points Most recent by Mitsuhiro Akiba Reporting and Analytics for HCM
-
excel file data set - volume/row limitSummary: Is there a volume/row limit when uploading an excel file data set in BIP?Mark Jayson Tamaray 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t…Matheus Roberto 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…Harish S 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manage Administrator Profile Values - Is there a Report for this?Summary Get list of all Enabled Profile Values - Manage Administrator Profile ValuesContent Hi All Could any of you have a Report for the Administrator Profile Values? W…Mansur Khalil 186 views 8 comments 1 point Most recent by Natwar Singh Rajawat Reporting and Analytics for HCM -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…A.R Kumar 920 views 8 comments 0 points Most recent by Pranat Damani Reporting and Analytics for HCM
-
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…Dasari Dileep 45 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se…Valerio Curzi 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…Valerio Curzi 292 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to display the filters in a BI Report, in multiple rowsSummary: How to display the filters in a BI Report, in multiple rows Content (please ensure you mask any confidential information): Hi, we built a BI Report, entering se…Barile Alberto 12 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 13 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM