BI Publisher
Discussion List
-
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 53 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to run the report USOnlinePayslip from BI PublisherHi All, I need to run the report USOnlinePayslip from BI Publisher. I am not able to get the output whatever parameters I pass. I need to get the xml data of the output …SowmyaSk18 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri_Sarma 17.9K views 22 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Chart functionality in Word's BIP add-inSummary: I want to display data from different time periods on a radar graph, but I don't know the necessary setting Content (please ensure you mask any confidential inf…Keita Furuya 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 34 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to Embed an HTML Page in XSL for Report Generation?Hello everyone, I'm seeking guidance on how to embed an HTML page within an XSL file to include it in a report. I have attached the HTML for context to facilitate unders…Nando 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 41 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Is it possible to use CASE to replace 4712/12/31 with CURRENT_DATEContent (please ensure you mask any confidential information): I'm using the Compensation - Salary History Details Real Time to return the "Salary Details"."To Date" fie… -
How to restrict Data Source in BI > Data Model > Data SourceSummary: Can we restrict the List Of Values from BI > Data Model > Data Source Content (please ensure you mask any confidential information): Customer is soon going to b…Dhananjaya Bhatta 113 views 3 comments 0 points Most recent by Dhananjaya Bhatta Reporting and Analytics for HCM -
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
All Scheduled Absences Report Not Pulling an EmployeeSummary: There is a custom BI publisher report that our HR department runs every pay period to view absences for that pay period. For some reason, in the last pay period…
-
How to rectify No Access to BI Consumer RoleSummary: Hello Experts, In an attempt to remove catalogue access for Managers I have accidentally marked the custom folder in OTBI with BI Consumer Role 'No Access'. Is … -
OTBI Custom Dashboard look and feelHi Team, My customer has shared a requirement to customize a OTBI dashboard and wanted to view like attached image. Is there any option to make such graphical view? Plea…Mohan Murali P-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there an audit/ query that we can use to pull the list of reports that uses a particular columnSummary: Hello SMEs, We are trying to get a list of reports that are currently pointing or exporting a specific column. Content (please ensure you mask any confidential …AprilleLyn 107 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
A report that contain report name and the dm connect to itSummary: Content (please ensure you mask any confidential information): Hi all, My client wants to build a report that shows the report name and the DM connect to it. I …
-
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…Mohan Murali P-Oracle 51 views 1 comment 0 points Most recent by Mohan Murali P-Oracle Reporting and Analytics for HCM
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Need a report for Global transfer records with location old and new locationHello, I have requirement for report to show global transfer records with old and new location and also active inactive all employees with their salary if anyone have pl…Mirza_Adeel 21 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 51 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This …Erica Williams 61 views 11 comments 1 point Most recent by Erica Williams Reporting and Analytics for HCM
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 1 view 0 comments 0 points Started by Giuseppe Iacono Reporting and Analytics for HCM -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
How to translate BIP Report Parameter TitleSummary: We have a requirement to translate the report parameter label. We couldn't get any link from Community or MOS to check the translation. We would require your su…
-
External Provider learningSummary: External Provider learning Content (please ensure you mask any confidential information): Hello experts, we would like to create a BIP report with the details o… -
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to query for encumbrance amount on an Open status Purchase OrderSummary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) usi…