BI Publisher
Discussion List
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 1 view 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Data Roles and Security Profiles - Unable to find 'STATUS' column for BI reportsHello, I’m currently working on a report related to Data Roles, and I was wondering if anyone here has worked on something similar or knows which table/column stores the…
-
Help with this error when trying to create offer "There was a problem creating the job offer..."What is the solution to fix this error when trying to create new offer? Have already tried reloading the template.Sara EW 134 views 1 comment 0 points Most recent by Erika B-Oracle Recruiting, Opportunity Marketplace
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 1K views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 2K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Goal Approval workflow notification issue with CLOB type data which have > or < symbol ?Summary: Goal approval workflow notification is having success criteria field where field is having below combination of text : 7800 and when notification triggered and …Ankur Jain--Oracle 1 view 0 comments 0 points Started by Ankur Jain--Oracle Reporting and Analytics for HCM
-
Add a document outside fusion which can be sent to customers using Print Receivables Transactions.Summary: We have a requirement where an additional document is required to be sent to customers along with the AR Invoice. This document is outside Oracle Fusion. Need t…Shefali Lakhani 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Public IP Address?Summary: Hello, our data team is interested in using SFTP to have the ability to automate reports from Oracle to our dashboard and have real-time updates. However, our I…B_Meiling 54 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
query to fetch educational details.query to fetch educational details.
-
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon…Sahil Kathuria 11 views 0 comments 0 points Started by Sahil Kathuria Reporting and Analytics for HCM -
How to provide the correct Return Value from the List of Value query in the BIP Data ModelSummary: I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters r…Boying 55 views 11 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Unable to fetch GL Budget Balances from GL_BALANCES table even though the documentation states itNeed to develop an Oracle BIP report to include the three types of GL Balances (Actual, Budget, Encumbrance). Although Actual Balances are available in GL_BALANCES table…
-
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
query to get page customization data through sandboxSummary: Required SQL table name where page customization information stored throgh Sandbox Content (please ensure you mask any confidential information): Hi Team, Can a…
-
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 42 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Can we Print incomplete AR Transactions in Print Receivables Transactions ESS JobCan we Print incomplete AR Transactions in Print Receivables Transactions ESS JobSidh 2 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to run the Create Customer Statements job for a date rangeOur Business Users want to be able to run the AR 'Create Customer Statements' job for a specific date range so as to filter out old transaction history. They also want t… -
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 161 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM
-
We need to find the BICC POV for the GL tables belowWe need to find the BICC POV for the tables below. • GL_COA_MAPPINGS • GL_ACCESS_SET_NORM_ASSIGN • GL_YEAR_END_BAL_GT • GL_YEAR_END_INC_STMT_GT • GL_ACCOUNT_GROUP_DETAILSDeepti Malvadkar 12 views 4 comments 0 points Most recent by Deepti Malvadkar General Ledger & Intercompany
-
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
How to hide custom Report from BIP page and ESS job from Scheduled Process ?Hi Team, I have a requirement to hide Custom Report and Respective ESS job (BI catalog page and Scheduled process) From User's view. Tool → Scheduled Process →ESS job. T…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…Ooha Pranathi Akkala 304 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Can attachment query within bursting be updated to get attachments from OM or SMC modulesSummary: We have a business case where attachments from Order or subscription need to be sent along with invoice copies. While this is achievable by manually going and a…