-
How to join price list tables with price strategy and customer site details
i have below tables from price list and price strategy qp_price_list_items_int ,qp_price_list_charges ,qp_tier_lines ,qp_pricing_strategies_tl I want above tables to be joined with below customer site and account tables hz_cust_acct_sites_all ,hz_cust_site_uses_all Let me know if there is any joining condition between…
-
OAP 7.6 with Ukrainian localization is inoperable
In the process of evaluating OAS 2024 with Stack Patch Bundle 7.6.0.0.241009 we noticed that Analytic Publisher is inoperable with Ukrainian localization. Browser's console for the xmlpserver/servlet/home page shows this errors: Uncaught SyntaxError: Unexpected identifier 'язкових' (at jstrans.jsp:229:58) Uncaught…
-
OAP 7.6 Execel output with several tabs
Hi Community, I need to generate an excel output from my application database with several tabs, each tab containing a different kind of report. Is that doable with OAP 7.6 version and how. If there is a link on the documentation, this would be definitely useful, cannot find it easily. Thanks for support and guidelines. Jf
-
Oracle Analytical Publisher desktop installation fails with 'Install DIR get failed'
We are trying to uninstall a previous version of Oracle Analytical Publisher Desktop and install a new version for 64bit. The installation is failing with 'Install DIR get failed'. We do not have Admin rights on our computer. So our desktop support group logs into our laptop with Admin role and is trying to install this.
-
Date Display as "Date Format" but not "Text Format" in Excel output
Hello there, The report has assigned the "requested date" as "DD/MM/YY" format while it is showing as "Text" in excel output. Is there a way to change it as Date format in Excel ? Thanks, Jason
-
Oracle Analytics Publisher Desktop installation fail
Hi Team, I am trying to install I'm trying to install Oracle Analytics Publisher desktop om windows 64. Initially it failed during first installation. I checked in programs and features through control panel but nothing was visible. I cleared it from program files , start menu but still getting same error . I followed all…
-
Page Break function not working for excel(MHTML) output format
Hi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We have developed the multi-tab report using the RTF template. In the RTF template, we used the page break option to split the data into multiple tabs (data…
-
Add a signature stored as an image to a report
Hello, The user wants to store an Image in a DFF, then call the image in the report. The image is the signature of different employees. Based on the employee different signatures will be called. Is there a specific way to do this in BI Publisher?
-
Tools > Reports and Analytics default search parameters for users
Hello, I have 2 questions on the Tools > Reports and Analytics search page: Is there a way to default a specific folder per user ( or per entire organization )? Let's say I would like to default the folder "Shared Folders > Custom > ZZZ" on the initial page instead of "All folders"; is that possible? Is it possible to…
-
Is there a way to download data in one go in excel in FDI
When attempting to export the data to Excel, I noticed that we can only download the Active Visual, not the entire dashboard. Is there a way to download the whole dashboard in one go, instead of selecting each visual individually?
-
Unwanted Linefeed characters getting returned in eText output
I am having an issue where there is both Line Feed and Carriage Return characters (CR LF) between each row of data as shown on the Right side of the below screenshot, when I am only expecting carriage returns to be returned as shown on the left side (until after the end of the ZBL lines where it should be CR LF together).…
-
Adding Image in a BIP Report
Hi All, We have a requirement to pull an image in a BI Report. Is this achievable? We are using a table (HRT_PROFILES_B) with a CLOB type field wherein the base64 format is being stored Mosts of the documentations / posts I'm seeing is for BLOB Image types from PER_IMAGES table Appreciate any inputs
-
Account Analysis Report - How to add new columns in Report
There is one requirement to make custom report by using Account Analysis report which is a standard report in which we have to add new columns in the report like PO Number, Asset Number, Chart of Accounts, Reason Code, and Credit Memo. They are using standard package XLA_ACCT_ANALYSIS_RPT_PKG in the report. Is it possible…
-
BI Publisher - English Text Alignment Issue in Arabic Session
Hello, I am working on a BI Publisher report that contains both English and Arabic text. The issue I am facing is that English text appears misaligned when the session language is set to Arabic (AR). EN Version : AR Version: In the Arabic session, the English text is incorrectly right-aligned instead of being left-aligned,…
-
Is it possible to get the output logs (when, who) of a BIP report?
The customer's requirement is to get the output logs of a customized BIP report. They want information such as when and by whom the report was issued. Is there any way to achieve it?
-
RTF Header using section break not showing as expected (Word / Template Builder)
Hi, I have recognized the following different output behavior between Word print output and the Word Addin BIP Template Builder. What I tried to achieve is simple: Getting a different Header on the first page then on the other pages. Therefore I followed some instructions to achieve this in Word with the help of 1) a…
-
How to fetch employee signature added as image into RTF template using data model.
we are trying to fetch salesperson image from person table which was added as employee images attachments. there is no fields in SQl data model to fetch the employee attachments. how to fetch the employee objects attachments in tables/SQL Queries. We are working in oracle sales cloud module.
-
how to calculate the percentage of total
we are trying to calculate the percentage of total for a calculated field '$' logic for calculating '$' - $1 -$2 We need to create another field where we calculate the percentage basis the total Can some help suggest how we can achive it. Thanks!
-
Preview of BI Publisher RTF Template with local subtemplate not working and giving error
Hello, I'm wondering what I did wrong (or maybe there are restrictions in the Template Builder for Word). I tried to test and preview a rtf template which imports a subtemplate ALL LOCAL on my PC: For easyness I created a main template containing the following: <?import:file:C:///WORK/bip_templates/test.rtf?>…
-
Is there a way to hide data table column header in Oracle Business Intelligence Publisher?
Hello there, Oracle Business Intelligence Publisher allows adding data table and it brings table column header automatically while it has got the feature to hide "Total Cell" . If there is a way to hide "Table column header" as the same way to hide "Total cell", it will enable to add multiple data tables in one template…
-
AP accounting not visible for 1 BU in invoice workbench
Hi all, We are implementing AP for one country. We are not able to see accounting in AP workbench. Also base amount is coming as 0 in back end for AP_INVOICES_ALL. We have ledger currency as USD and we are creating invoice in LBP. However when we are creating invoice in USD, the accounting is coming.
-
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email bursting
I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be possible: https://answers.microsoft.com/en-us/msoffice/forum/all/clickable-phone-numbers-in-word-documents/3ed057a0-789a-47c3-bdbc-f6592e848c4e But when I try…
-
Not getting the Manager Person Number
Hello All, When I am running a BI Report to get the manager person number, but I am not getting the manager person number. Not sure why. If suggest something, if someone know anything.
-
How to make header under sub heade with count wise in oracle Analytic Server using url of oracle bi
-
Wrong hyperlink in excel extraction from BI
We are obtaingin from the invoice the URL attached, but we have an error in the extraction where the excel hyperlink allways point to the first line despite has another value. Is there a way to show the correct hyperlink in BI?
-
Getting error : ORA-01719: outer join operator (+) not allowed in operand of OR or IN
We encountered an error with the following query: AND ((items.inventory_item_id is not null AND items.inventory_item_id = sod.inventory_item_id(+)) OR items.inventory_item_id is null) As Oracle Database 19.25 now adheres to the ANSI standard, which prohibits the use of partial outer joins with the ORand IN operators, we…
-
Which Order Management table should be used for Sales Order Approval Workflow?
To determine the processing time for Sales Orders (SOs), we need to retrieve the approval dates from various teams. It’s important to note that there are cases where SOs are returned for editing. In such cases, even if the SO is in the middle of the approval process, it is sent back to the Revenue team for re-approval.…
-
Reports Job Not working after migration
Hi All, Plan Upgrade Version: 7.6 Previous Version: 5.5 Product: Oracle Analytic Server BI Publisher Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server Recently i review and follow the document to perform migration and upgrade. Target to use back the production data as a…
-
Actuals Vs Budget BIP Report
Hi - Does anyone have actuals vs budget BIP report based on COA segments ?
-
Where can we find payment method field in Order Management
Please let us know the table which stores payment method details for Order Management