BI Publisher
Discussion List
-
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 172 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 1.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 Most recent 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 13 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 75 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 Most recent 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 84 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 26 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 49 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 173 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 21 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 341 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… -
Not able to create a PO adding Header level DFF and line level DFF in that single payloadAble to create a PO in a single payload having headers, lines, schedules and distributions. However not able to create a PO adding Header level DFF and line level DFF in…
-
Why the ESS job log or output file is not visible in UCM?Hi Team, I have a BIP report based - ESS Job I was able to view the log and output from scheduled process. I was able to get the UCMID, and Title of the log and output f…Sridhar Gupta Yerram-Oracle 56 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Expenses