BI Publisher
Discussion List
-
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 498 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 -
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 15 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 237 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 22 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 24 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 145 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
-
Observation checklist outcomeWe have incorporated observation checklist in Assessments, while extracting a report we are unable to find which table stores the outcome information. The observation ch…
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 21 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
add remittance message to remittance adviceSummary: I downloaded the XML payload and see Remittance Message in the payload, but is isn't available as a field when I try to add it in the field browser? Anyone succ…Alex Glose 42 views 7 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information …
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 71 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Trouble converting Double to Decimal/NumericSummary: Attempting to create a BI report which creates a file for sending via SFTP to a 3rd party. When creating the Data Model, I'm able to use OBIEE in the SQL query … -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 32 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following … -
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside…