BI Publisher
Discussion List
-
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 101 views 3 comments 0 points Most recent by Ranveer.Tiwari-Oracle Reporting and Analytics for ERP -
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 744 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Required REST API to get Predefined Validations undern Manage Payment MethodsSummary: Hi Team, We need REST API to get Predefined Validations and their parameters undern Manage Payment Methods setup and attached screenshot for reference. Content …
-
Link between ZX_RULES_B and ZX_STATUS_B in oracle fusion TaxSummary: Got a requirement to link these two tables to generate report for Tax Rate and Rule Content (please ensure you mask any confidential information): Version (incl…
-
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar…
-
Dunning Letter email - missing body text messageHi, We are implementing advance collection and setup all items for dunning letter email. We are able to get the email with PDF as attachment but email body message is bl…
-
Custmization on AR Transaction Image ,error occurred File name must end with .xdoz / .xdmz / .xssz /Hi Team , when I changing the query, system asking for Lexical parameter . For this issue , I found below documentHow To Work With the Lexical Parameter Value When Custo…Sandeep.kumar2454 21 views 4 comments 0 points Most recent by Sandeep.kumar2454 Reporting and Analytics for ERP
-
sSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…5372189952873 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Does anyone have the Payables invoice register report as oracle SQL QUERY.I want to create a BI report that is the same as the payable invoice register (the one seeded in Schedule process ) , due to filtering option (i can't filter by invoice …Omran Zeaiter 31 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Clarification on Manual Payment Workflow in Learning ModuleHi Team, I have a question regarding the learning module. I created a course and added manual payment. I then applied an override at the Offering level using "Edit Offer…
-
How to XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion PaymentsSummary: Content (required): We need to modify the report layout and need the XML data for testing purposes. How can we obtain the XML extract for Send Separate Remittan…DPM 1.1K views 6 comments 0 points Most recent by Prassanna_Srinivasan Payables, Payments & Cash Management
-
How to add multiple Digital Signature based on Legal Entity for Print Receivables Transactions job.Summary: There is a requirement to attach the Digital Signature to AR invoice dynamically based on Legal Entity (digital signature varies for each LE). For this requirem…
-
Dunning Letters - Send to Printer - How to?Summary: Hi all, How/Where do you configure the printer setup for the Dunning Letter distribution using bursting? Content (please ensure you mask any confidential inform…
-
How to populate data in AP_IDR_RECOGNITION_DYD table used for IDR ReportSummary: We have a requirement for some changes in the "Invoice Documents Recognition Rate Report", when we tried to customize the report but AP_IDR_RECOGNITION_DYD tabl…Srividya VVR 374 views 2 comments 0 points Most recent by Lisa Poore Payables, Payments & Cash Management
-
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 494 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
How to adjust the wording on Check using pdf formatSummary: Using the BIP , everytime we want to printout the checks on pdf format the wording that is printed out on the check is misaligned from the check , how can we ad…User_F5ON9 22 views 5 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Print Receivables Transactions not sending print job to printerSummary: Print Receivables Transactions process creates output but it is not being printed. Content (please ensure you mask any confidential information): When we run th…RSongco 42 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Create Customer StatementHi All, while calling Create Customer Statements ESS job same We Have requirement to pass 'cycle' and 'generate bill parameters' into Statement Generation Data Model. /s…Veeragopathi 12 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is there a way to get the Next approver name of a credit memo originated by a dispute in ARWe can see only the First Approver in the table - FA_FUSION_SOAINFRA.WFTASK. Is there a way to get the Next approver name of a credit memo originated by a dispute in AR.…Venkateswari 11 views 1 comment 1 point Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Can we develop a BI report for sending AR invoices via email to customers?Summary: Can we develop a BI report for sending AR invoices via email to customers? Since we need to send invoices to our customers after running a custom BI report. Or …
-
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…Barile Alberto 74 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…Shahid Qureshi 31 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 11 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
SaaS BIP reports in waiting for long timeWe have kicked off BIP Report in SaaS/Oracle Financials Cloud and its in waiting mode for 2 hours 40 mins before it started executing.Pradeep Challa 51 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP