BI Publisher
Discussion List
-
Extract gives an error in work relationship for terminated employeesSummary: We are using this extract from a couple of months ago. It works for all other employees. Now the client requirement to add terminated employees is in the extrac… -
Send Dunning Letters log says contact information is missing for customer, we require SQL queries.Summary: Send Dunning Letters log says contact information is missing for customer; we require SQL queries to create custom report to add these error detail of the custo…
-
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 31 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
How to create an OTBI report to pull information on learning assignment deleted date?Summary: How to create an OTBI report ( or what are the subject areas ) that helps to pull information regarding learning assignment deleted date? As part of 24 C New fe…
-
Tables to fetch activity evaluation detailsHi Team, I am trying to fetch activity evaluation details in BIP report , please let me know which table I should be looking into. Navigation: Learning > Courses > Offer…
-
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 72 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
SQL Query to retrieve employee evaluation in performance documentSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query retrieving the employee overall rating in performance d…Valerio Curzi 917 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 2 views 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Unique Learner Record - Learning Records Real TimeSummary: I am needing to produce results that provide a unique set of learner records for each training title in the analysis. I need the formula to produce the record t… -
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…Badripalli Archana-Oracle 3.3K views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL Behind the package JEFR_JELINES_RPT_PKGWe are trying to write the custom SQL for creating a custom report, in order to fetch the details in BIP report. In order to achieve the same, could someone please assis…Mohd Saqib 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 104 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 261 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 61 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
SQL to retrieve all learner records with community and course taken detailsHi, How to generate a report with all learner learning records along with their course taken details and the associated Category Community and Topic Community? I am unab…
-
How to Fetch Data from SCORM Assessments in Oracle Fusion HCMHi, I am working on a report in Oracle Fusion HCM where I need to fetch data related to SCORM assessments. Specifically, I want to retrieve information such as patterns … -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 41 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Need query to get asset details as mentioned in the summarySummary: Hi, There is an asset which is placed in service in Jan-24.Suppose there is an amount adjustment done in Aug-24 to the asset and in oct-24 life in months adjust…Madhan NM 291 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…Alessandra T. 1 view 1 comment 0 points Most recent by Elaine Berrick Reporting and Analytics for HCM -
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 53 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need an SQL Query to get the questions in learning module evaluation section shown in image?Navigation in user login:- Me→ Learning→ select any completed course→in default section select evaluation and click on review attempt We can see the questions in above n…
-
Dynamic Payroll Relationship group not working as a parameterSummary: We have a requirement to add Payroll Relationship group as a parameter to a custom BI report. While running with this parameter, the report runs fine with stati…
-
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 298 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
Can any one share sql query to fetch employee contacts details(contact person_id,date of birth)Summary: I have a requirement to fetch employee conatct details(Children),contact person Id, date of birth and their marital status, can anyone help me? Content (please …Lakshmi Devi Bathala 1.2K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
2717700.1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Prasad Singamaneni-Oracle 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get the bank account assigned to a party siteSummary: We need to list all bank accounts being used by sa party site. Bank accounts that we can see when we navigate to Manage Suppliers page Content (required): We ar…
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 501 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM