BI Publisher
Discussion List
-
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 160 views 5 comments 0 points Most recent by Nermin Khaled-Oracle Reporting and Analytics for ERP -
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver…Krishna Manmohan 10 views 1 comment 0 points Most recent by Krishna Manmohan Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 191 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP -
FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud FusionHi all, I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are usi…Arthur Teodoro 16 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…
-
Scheduling BIP report is failingI have a BIP report which has bursting enabled. The underlying data model has 2 datasets- 1 is of type HTTP (XML feed) and 2nd is of type SQL query. HTTP dataset calls a…Neha Aishwarya 28 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
link to data set parameterSummary: Working with BI Publisher I have 5 different data sets. There is the header query and then there are children queries which are all linked, one of which has a t…
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…Anne Cilia 47 views 3 comments 0 points Most recent by Gopikrishna-Oracle Reporting and Analytics for ERP
-
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct…
-
OTBI Report 8.4 RCE Anexo 11 – No Invoices DisplayedI am experiencing an issue with the OTBI report “8.4 RCE Anexo 11 – Replaces Proposal” under Oracle Fusion Cloud Financials. When I run the report for the September acco…Milagros MR 41 views 5 comments 2 points Most recent by Prateek Agasti Reporting and Analytics for ERP -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and…Nermin Khaled-Oracle 21 views 0 comments 0 points Started by Nermin Khaled-Oracle Reporting and Analytics for ERP
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea…
-
Is there any way to integrate BI Publisher bursting with Fusion’s notification frameworkSummary: We currently use BI Publisher bursting to send report outputs via email to users. This works fine, but we also want the same notification to appear in Oracle Fu…
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 119 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
BI Publisher – Unable to Set Default Parameter to Week Start (Sunday) and Week End Date (Saturday)We are trying to configure a BI Publisher report parameter in Oracle Fusion Cloud to automatically default to the start and end of the week Week Start = Sunday Week End …Deepika Maddirala 20 views 2 comments 0 points Most recent by Deepika Maddirala Reporting and Analytics for ERP
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…
-
How to connect General Ledger Tables to AR Cash Receipts Tables?I'm trying to build a report that includes GL data and AR Cash Receipts data. I've figured out how to connect the GL_JE_BATCHES table to the XLA_DISTRIBUTION_LINKS table…Steven Woods 53 views 4 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
Manage Production Calendar Exceptions Calendar TablesI am trying to find the table that saves the registries for shifts exceptions on maintenance production calendars in Oracle Fusion in order to use it for reporting in OT…
-
End User gets the option of EDIT for custom OTBI reportSummary: Hi Team, We created and OTBI report using General Ledger -Journals real time subject area, In the permissions window we have given full access only to BI admini…Naga Hari Krishna P-Oracle 26 views 7 comments 0 points Most recent by Naga Hari Krishna P-Oracle Reporting and Analytics for ERP
-
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
Recommended OTBI and BI Publisher Reports for Financial ReconciliationI’m exploring OTBI and BI Publisher in Oracle ERP Cloud and would like to build useful reports for reconciliation between Payables, Receivables, and GL. Could someone re…
-
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1.3K views 5 comments 0 points Most recent by gkulkarni Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 95 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…