BI Publisher
Discussion List
-
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 -
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…
-
Email Sent Without PDF Attachment using Print Receivables TransactionsWe are using the “Print Receivables Transactions” functionality to send billing invoices to customers via email. The emails are being sent successfully, and normally the…
-
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…
-
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid…
-
BI Publisher Preview Options not enabledSummary: BI Publisher Preview Options are not enabled. Content (please ensure you mask any confidential information): We are trying to update our RTF template and the Pr… -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 46 views 3 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 55 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management
-
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 14 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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…
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 407 views 6 comments 0 points Most recent by Raunak Kumar Singh Reporting and Analytics for ERP -
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 14 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Getting Blank Data When Combining Multiple Subject Areas in ReportSummary: Hi everyone, I’m trying to create a report by combining fields from three or more subject areas. However, whenever I add columns from different subject areas in…Vaibhav Shingare 9 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…essdee 6 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
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 24 views 0 comments 0 points Started by AbdulBasith Subledger Accounting & Accounting Hub
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
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…
-
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…
-
BI Publisher prompt on date to refresh other parametersHello, I built a BI Publisher report with a prompt on 'as of date' which I want to reflect on other prompts so they refresh the available values. I read that it's not ye…Alice Gouzy 29 views 2 comments 1 point Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 33 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Procedures in AP_INVOICES_PKGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Consultant2025 7 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 10 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Print Receivables Transactions completes with errorSummary: When attempting to run the "Print Receivables Transactions" process for a single invoice, we are getting below error: The bill-to customer email address for tra…
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 2.5K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Set last year as default value on BIP parameterSummary: Content (please ensure you mask any confidential information): I have a BIP report with parameters. One of parameters is year. I know that last day of last year…Stefano_Mazzocca 13 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Specific user assigned with Payroll Administrator cannot view the Reports tab in UI Dashboard.Hi Experts, Does anyone have experienced that there is a specific user which was assigned by Payroll Administrator role but cannot view the Reports tab when clicking the…