-
Need help with Cost Accounting Distributions Code
Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation account code needs to be fetched - 01.01.00.000.000.2311.2104.000.00.000.000 I am nowhere able to find the query for the same, somebody please help? Thanks!
-
Need BIP report SQL query to get GL Balances by Posting Date in oracle Fusion
Need BIP report SQL query to get GL Balances by Posting Date
-
How to send multiple files from "split by" in one email by "deliver by" ?
Bursting a report we want to send every invoice, dunning, etc as a separate PDF/Excel, but in one email per customer . I thought this could be done by configuring the "Split by Invoice#" and the "deliver by Customer#" - but there are always sent separate mails for every Invoice-PDF, so if there are 5 Invoice# the customer…
-
Whenever I try and reference a where clause key flexfield it inserts null into my sql script
Hello, Version: Oracle Analytics Public 12.2.6.4.0 I have a simple query that like the following: SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS WHERE STRNUM > 100 I also have a menu parameter filled with all the distinct towns in the table called TOWN_SELECT. I am trying to give the user the option to select a town using…
-
Conditional Region within repeating group?
So, I'm trying to create a conditional region inside of a repeating group. There are xsl attributes as part of the if code. However, I get an error saying "element xsl is not supported yet". Is it possible to have a conditional region within a repeating group in BI Publisher for Desktop for Word?
-
How to call dbms_crypto package from Oracle BI publisher
We have a requirement to call dbms_crypto.encrypt package from BI publisher to encrypt sensitive data at the column level. So i have 2 questions: When we select Data Source as ApplicationDB_HCM which schema/user is it using? (eg apps, fusion etc.) If we raise SR on Oracle to grant execute on dbms_crypto to that user will…
-
BI Publisher - Suppress Repeating Values in RTF template?
In BI Publisher, I have a table inserted and would like to suppress repeating value for a column. How would I go about doing this?
-
Using BIPublisher RTF template how to create protected word outputs ?
I am using BI Publisher RTF templates to generate WORD output reports. The requirement is to have the Word output report "protected" so that Users cannot change the values, but alongside also have a few fields which will be editable. How to achieve this?
-
How do I view the HTML output of a Oracle BI Publisher report with 700 thousand rows?
Hi everyone, I'm currently using BI Publisher embedded in Oracle Analytics Server 2024. I have a report that uses 2 parameters: P_BRANCHES and P_DATE For P_BRANCHES = 'ALL' (all the branches), the report will return all the values for the column BRANCH_NAME and the remaining columns, which is 700 thousand rows plus in…
-
Dunning Letter File naming within the zip file.
Currently, using Bursting, I am able to place the “Dunning Letter” output zipped PDF files with naming convention ("Dunning_'Dunning_id'.zip") directly into the SFTP location. However, as per the requirement, the output name for the individual pdf inside the zip file should have naming convention as "combination of the…
-
BIP report's header to be that column's Property > Label when output format is .csv
Hi Experts, I would like to reach out to you for my question below: The BIP report is having Subject Area (Supplier - Supplier Real Time) as the data source. And I am simply using a Data Table to extract the supplier data. When the output is Excel file, the columns' header are presenting correctly, aligned with what I see…
-
How to convert number to text for non-English language
We have a requirement to show the Total Amount of Purchase Order into words in rtf. We were able to display it in English, but the requirement is to display in a non-English language (in this case it's Vietnamese). How do we achieve that?
-
In Cash Management, we have manual reconciliation. In the Reconciled tab, there isaTransactionSource
In Cash Management, we have manual reconciliation. In the Reconciled tab, there is a Transaction Source column. From which table can we get this data?
-
Arabic diacritic is being dropped during PDF generation
Dear supprot font / Arabic diacritics rendering issue when exporting report RTF → PDF in Oracle Analytics 6.4. دً (Dal + tanween) in RTF working fine, becoming just د in the PDF That means the tanween diacritic is being dropped during PDF generation same fonts are mapping in RTF and PDF.
-
Is there a way to allow SCM user to have access of creating data model using SCM tables?
Is there a way to allow SCM user to have access of creating data model using SCM tables but restricts access of HCM tables?
-
How to create RFQ from approved PR
I’m a beginner in fusion and a I want to know how to create RFQ from approved PR, please I need the steps in order also to create PO if you available pdf documents or links it would greatly appreciated
-
Who Columns not getting updated with the timestamp for table IBY_EXT_PARTY_PMT_MTHDS
For some of the records who columns are not getting updated with the timestamp in the table IBY_EXT_PARTY_PMT_MTHDS. We are relying on these Who columns to verify the incremental data. Can you please let us know the reason for these WHO columns not getting updated with the timestamp
-
Extract scheduled Report
Hi Experts , Can someone help me with scheduled extract report? Looking for actual start date and end date of the scheduled job. Referred the below link which has next scheduled start date. Regards, Nivya
-
I trying to install BI Publisher I'm getting an error that states "Set Word2007 flg failed".
I trying to install BI Publisher 64 bit , I'm getting an error that states "Set Word2007 flg failed".
-
Customizing the Bursting Query for a Seeded Report
Hello, is it possible to customize the bursting query for a seeded report? Instead of the original key used in the bursting, I want to use the Customer Account as the key. Would it be possible even if the report relies on the parameters entered on the ESSJOB? The seeded report I am talking about it Generate Statement…
-
Is it possible to customize a seeded ESSJOB?
Hi. Does anyone have any idea if it is possible to customize the Create Customer Statement ESSJOB to include three more parameters? Client wanted to include a parameter for Customer Class, Collector, and Generate Balance in Zero which would allow them to run the essjob for customers that has zero balance for statements. Is…
-
How to connect BI Publisher using REST services
Hello everyone, I'm developing a project where I need to consume a couple of reports from BI Publisher using OIC. The idea was to consume them via URL. I see there are certain connection services for this, but I'm getting a 500 error. The report URL is: https://domain/xmlpserver/Custom/PruebaBI.xdo. I'm trying to consume…
-
How to Add PO Number column in Oracle fusion Account analysis report -Standard
Hi, We have business requirments to add the Po number and its related information in the account analysis report so please guide how to achieve this to add this information in the account analysis data model. Regards
-
How can I get the original column header in the CSV output of a BI report without underscore
By default, the CSV output from BI Publisher modifies the column headers by replacing spaces with underscores and converting them to uppercase. I would like the CSV output to retain the original column header formatting exactly as defined in the Data Model (e.g., "Employee Name" instead of "EMPLOYEE_NAME").
-
How to run bip report from oracle analytics cloud ?
How to run bip report from oracle analytics cloud ?
-
Barcode not working
Hi all, I am currently working on a BIP template for a client where a barcode is needed, the oracle seeded template has the barcode works perfectly fine but the client wants their own version with their logo. When i download the oracle seeded template, the barcode appears as symbols and the font is code 128, when i change…
-
Failed to install OracleAnalyticsPublisherDesktop-8.2.0-win32.exe
Hi, I'm trying to install OracleAnalyticsPublisherDesktop-8.2.0-win32.exe but getting an error code -3 Execute-Process -Path "$dirFiles\OracleAnalyticsPublisherDesktop-8.2.0-win32.exe" -Parameters '/S /V/qn' -WindowStyle 'Hidden' Can you please advise how to solve this? Regards,
-
Setting Filename when creating email bursting in Publisher
While setting up email bursting in oac publisher, is there a way to control the name of the attachment file? I would like to have a fixed filename concatenated with date. For example: name of the file that user receives as email attachment: YOURFILE_YYYYMMDD.xls
-
Unable to Install Oracle Analytics Publisher
I’m trying to install the Oracle Analytics Publisher add-in from the official download page: https://www.oracle.com/middleware/technologies/analytics-publisher/downloads.html However, the installation fails due to compatibility issues with the latest Microsoft Office version (Microsoft 365). Our IT department confirmed…
-
Why does the Publisher Word Add-in not appear ?
After successfully executing the newest Analytics Publisher Add-In Installation-File (OracleAnalyticsPublisherDesktop-8.2.0-win64.exe) the BI-Publisher-Word-Add-In isn't visible, even though it is listed as enabled under Options/Add-Ins. Setup is executed with administrator rights on an Windows 11-Computer. Word-Version:…