BI Publisher
Discussion List
-
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …chandrakanth makam-Oracle 31 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for HCM -
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Linking courses using an Analysis CriteriaWe are a new Oracle customer and so new to creating Analysis criteria and we want to use this functionality to create an audience for some compliance refresher training …
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 183 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Completion Certificate report not populatingSummary: After creating the report in BI Publisher and proceeding to "Configure Catalog Defaults" and enabling "certificate" for both Course and Specialization, the repo… -
Golden tax outbound processSummary: Once generate the file, what are the steps to transmit the file to Aisino system ? Content (please ensure you mask any confidential information): Version (inclu…Krupa.B 11 views 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way …Luke.Findex 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Learning Management Real Time RemovalSummary: Will it be removed or not anymore? Content (required): There were news way back 21A about the removal of the Learning Management Real Time Subject Area. Is it s…
-
Does oracle provided any learners reporting dashboardSummary:Does oracle provided any learners reporting dashboard ? Do we have any standard dashboard on oracle learners reporting? Content (please ensure you mask any confi…
-
Which table stores the output data of the Print Receivables Transactions Email Delivery: InvoicesHi Everyone, Can anyone point me the table which stores the output of the Print Receivables Transactions ESS job especially the child ESS job - Print Receivables Transac…A Vigneshwar 476 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 122 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 171 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa…Valerio Curzi 11 views 3 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 234 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
How to fetch Control Account number at position 223 in Corporate Card remittance format template?Summary: We need to fetch the Control account number at the position 223 of the template used to send the remittance advice to the AMEX corporate card company after paym…
-
Hi all, does anyone know how to calculate the prior fiscal year to date using bi publisher data modeSummary: Content (please ensure you mask any confidential information): I am aware the I can use FRS, but I am being pushed to use BI publisher. My question is, do you g… -
Delete wrong offerings using HCM Data Loader (HDL)Summary: Is it possible to delete wrong offerings in a course using HCM Data Loader (HDL). If so, please provide the sample metadata file for performing the above. Thank…
-
How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?Summary: How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ? Content (please ensure you mask any confidential information): How to set {$SYSDATE()$} into… -
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query to fetch assessment/evaluation details submitted by a learner after completing the self pacedSummary Query to fetch assessment/evaluation details submitted by a learner after completing the self paced courseContent Hi All, Need an urgent help. Is there any means…
-
Query that link Legal Employer to Reporting EstablishmentSummary: Hello! Good morning/afternoon/evening Customer Connect! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyon…Matheus Roberto 21 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Customize the output of Export Golden Tax Transactions for China ESS JobSummary: We are implementing Golden Tax for China. As part of that requirement we would like to customize the output of the ESS Job "Export Golden Tax Transactions for C… -
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 112 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM