BI Publisher
Discussion List
-
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 23 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 72 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
Trouble converting Double to Decimal/Numerichttps://us.v-cdn.net/6034893/uploads/9VSYBPB2KHPU/deduction-conf-layout-template.docx Summary: Attempting to create a BI report which creates a file for sending via SFTP… -
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…
-
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 21 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 151 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 111 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 291 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 251 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 -
Oracledatatable for supplier masterdata fieldsSummary: In an external application, we are creating checks on Supplier master data information combined with data from other sources. For 2 checks we need the data fiel…Daniel.Hut 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…Charan Kollipara 1.8K views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payslip Template ChangesHi all, I'm hoping someone can help me here. Our payslip is a customised version of the seeded one provided by Oracle that currently has every page in landscape. We'd li…MikeW 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…Keval_Shah 361 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Can Learning module integrated with third party Mobile APPWe have a requirement to integrate Oracle fusion learning module with third party mobile app with all the progress detail(360 View). IF Yes then what all API's are avail… -
Do we have any localization for SEPA payments in FinlandSummary: We are planning to implement SEPA payment for our Finland entity, but the standard SEPA formats provided by Oracle does not support Finnish bank requirements. I…Surya Skanska 11 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management -
Payment supervisor must not have access to Pending installments review page in PPR.Hi All, We have created a custom role for payment supervisor name as "XXXXX" in which our client has a requirement that payment supervisor must not have access to Pendin…Shilpa Pekade 21 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management -
How to enable Deep link on Payment Approval NotificationI need to add a deep link on Payment approval page, to show paid invoice details. What is the way to customize Payment approval Template to add the deep linkBindu Goyal 51 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management -
attach the PO and invoice documentThe Client requested to attach the PO and invoice document to the payment process requests approval notice. Is it applicable or not?Mohammad Hussein 1 view 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management