BI Publisher
Discussion List
-
Lack of Documentation for ORA_ACTIVE Code in Learning Notifications (26A Update)Summary: Hi All, We’ve recently observed a change in Oracle Learning notifications as part of the 26A update. Specifically, the ORA_ACTIVE code has now been introduced w… -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 6.1K views 11 comments 0 points Most recent by Nazir Hossain Reporting and Analytics for HCM -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia… -
Swiss QR-Bill on customer invoicesSummary: Oracle EBS R12.1.3 We need to print Swiss QR code on invoices sending to customer as Swiss QR Bill requirements. I did not find any solution in Oracle for this.… -
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…Opkey PA 5 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…Rohit_Verma 13 views 1 comment 1 point Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Need Table details for Subledger Journal Batch Description in 25DSummary: Subledger journal batch description is showing in UI (review subledger journals page) as 'Payments'. We have checked xla_ae_headers, lines, events and transacti…AbdulBasith 45 views 3 comments 0 points Most recent by Sundara Meenakshi Subledger Accounting & Accounting Hub -
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u… -
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 8 comments 0 points Most recent by Chiranjeevi Boya Reporting and Analytics for HCM -
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…User_2025-02-07-07-19-13-925 153 views 5 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Custom template and Data model for Customer statement is not being picked in AR moduleSummary: We have used the seeded data model for Print statement and customised it with additional fields. This is placed in the custom folder (path similar to the seeded… -
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov… -
Standard Purchase Order Report sub template logicSummary: Hi Team, Theres a subtemplate being called in PO template rest of contents in rtf template has english content with fields no language specfic condition. but w… -
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 70 views 14 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page pag. Content (please ensure you mask any confidential inf… -
Query to get all the defined UOMSummary: Query to get the UOM that we've defined in our application. Content (please ensure you mask any confidential information): Hello, We need to have a query to get…Mamdouh Ahmed 17 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
How to Control HTML Table Width in RTF Template for CLOB Data from HRT_PROFILE_EXTRA_INFO_VLSummary: I am trying to fetch data into my RTF template from the Job Profile page, which includes the following fields: Job Details Job Responsibility Job Qualifications… -
ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.jaSummary: Hello Team, we have an sql report with multiple parameters and each parameter is a multi selelct pick list. we are trying following SQL for this and it is faili…Sudheer V SB 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 250 views 16 comments 0 points Most recent by Archana Prasad Reporting and Analytics for HCM -
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl… -
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…Pravesh Koonjal 8 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se… -
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS… -
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…Mallikarjun Sheshagani 15 views 1 comment 0 points Most recent by John Lyndon Amemita Reporting and Analytics for ERP -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i… -
Apply Format Currency in RTF within a calculation TagSummary: Hello, Is there a way to apply a format currency () for this tag in an RTF template: Thanks Content (please ensure you mask any confidential information): Vers…Guillaume SAVALL 96 views 1 comment 0 points Most recent by User_8M22K Reporting and Analytics for ERP