BI Publisher
Discussion List
-
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 151 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 22 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 41 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 31 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… -
Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 24 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to show asset which has been suspended/resumed depreciation in OTBI report?Hi, I am trying to create new OTBI report to show the assets which they have been suspended/resumed depreciation. But I am not sure that which filed and areas should I s…
-
Need Underline Table Information for "Review Customer Account Details" Data from Fusion.Summary: Need the table details (or any code snippet if available) to get amount/transaction due for a particular customer. Path: Fusion --> Receivables --> Billing --> …Abhijit Sahu-Oracle 152 views 7 comments 0 points Most recent by User_K1U5X Receivables & Collections -
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 113 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 299 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
AR/AP Netting - Ability to display the e-mail body using a custom netting letter templateSummary: We use the AR/AP Netting feature. We sends the netting letters to trading partners by e-mail ("Generate Netting Letter" and "Send Letters by e-mail" options ena…Oliver Lemaire 252 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to update the Publish End Date in Offering using HDL File ?Summary: I am trying to update the publish end date as (2023/10/26) in Offering, and the HDL file got loaded successfully, But while checking from frontend navigation th… -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
Payroll Flow PatternSummary: Does anyone have a sql they have used to get a dump of all payroll flow patterns and the corresponding tasks and following task in a pod? Including Created By, …Jen Barthel 11 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
posistive pay CSV format with summary lineSummary: positive pay file in CSV format is generating only detail lines without summary. Used template from How to generate CSV format output for Positive pay file? (Do…Roman Havrylyak 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management