BI Publisher
Discussion List
-
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 8 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 19 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 32 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.
-
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 11 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…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…ManishaPatil 28 views 5 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…Sridhar Gupta Yerram-Oracle 13 views 2 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
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…
-
Is it possible to restrict the users to create the AR invoice with a particular source ?Summary: Hi Team, Is it possible to restrict the users to create the AR invoice with a particular source which has type as Manual. Content (required): Is it possible to …Ayyappa-Oracle 54 views 3 comments 0 points Most recent by Himanshu Mahajan Receivables & Collections