BI Publisher
Discussion List
-
Reconciliation Report using Supporting Reference segmentsWe have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transa…Kalyani-Oracle 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Pivot using Mulitiple groupsSummary: I have a requirement to have supplier response and prices details based on the items. Suppliers, Response and its prices should be in Pivot format. We are unabl…
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 2 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…Srinikethan 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign…
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
How to include attachments from the main transaction page into a custom reportSummary: Hello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages…
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…Abby Chen522 61 views 11 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 43 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
where are segment member aliases stored in the oracle financials database?Summary: Where can I find the aliases for individual segment members in the oracle financials database tables? Content (please ensure you mask any confidential informati…josstenger 1 view 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…Salma Mohamed Salem 26 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…simonl 51 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 21 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…Rakesh Sreenivasa 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need to know the table and api for Fusion application notification setupWe want to know the tables and web service APIs of the below two locations of notification setup. As we are creating bip reports and integrations for the same. Navigatio…
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…Lavina Bansal 54 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 31 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an…
-
Include Dynamic dates in File Name for Scheduled Custom ReportSummary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date paramet…
-
How to join ZMM_NOTES to RA_CUSTOMER_TRX_ALLHello, I am trying to construct a sql query to pull notes related to AR Invoices, can anyone assist, I had thought the source_object_uid in ZMM_NOTES would join to the p…Robert of STAU 31 views 5 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…Aparna N-Oracle 11 views 3 comments 0 points Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
How to create language (billto-site language) dependent BIP invoice template?Summary: We try to find a way (Oracle supported or best practice) on how to use multi language templates depending on our customers bill-to-site language setup. Oracle F…Frank.Steinjan 31 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…Ninad Joshi 21 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP