-
Printing Checks from Oracle Cloud SaaS to Local Internal Printers
From a Network Architecture standpoint, I have the following questions regarding Oracle Fusion check printing: Essentially, we are trying to eliminate the need to expose printers to the Internet. 1. What network connectivity options do you typically recommend for customers who need Oracle Fusion to print to on-premises…
-
In email notification Image or logo is not display
Hello Experts, We are experiencing an issue in Oracle Fusion HCM where the Oracle Community logo (or other embedded images) is not displaying in CmpWorkbenchFYIReport workflow email notifications. The email notification is triggered correctly, but the logo/image does not render at all in the recipient’s mailbox. Even after…
-
How to get ATP DB table in a SAAS BI report
I need to prepare a report with ATP DB, So I checked the availability. I also need to know how to get data from ATP DB into a SAAS report.
-
How to burst the BI Report result file to particular UCM account through BI Report bursting ?
Hi All, We are trying to place the BI Report result file to below mentioned UCM account using BI Report bursting but its not getting placed to the mentioned account. Bursting details are mentioned below for reference. UCM Account : fin/receivables/import Bursting Query : SELECT 'X' AS "KEY", 'XXXX_AR_INV_PRT_CSV' TEMPLATE,…
-
Oracle BI EE OTBI Query multi Select query
I have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logical SQL. The parameter :P_Period I would like to use as an optional multi-select parameter in the WHERE clause, where the user can either select 1 or more…
-
While triggering multi-valued parameter BIP report from my integration code, ^^ is btw values.
When i triggering a multi valued parameter - BIP report from my integration code, I am finding ^^ is appearing between multiple parameter values for that paramatere in the fusion reporting screen, (in report job history), although my data have no traces of ^^. The value looks some what like this - VALUE1^^VALUE2^^VALUE3…
-
Unexpected single default value selected within the list of values for a parameter
Oracle Business Intelligence 12.2.1.4.0 Hi, I’m coding a BI Publisher report using a Data Model. There is a parameter within the data model for employee number. Linked to this parameter is a list of values using a SQL script to find all eligible employee numbers. This is the setup for the Employee Number parameter (no…
-
BI Publisher Word Add-in
Hello, I have built a custom report in ARCS where we have displayed all unmatched transactions in ARCS with their aging bucket, number of transactions and the amount. We have columns for the Periods which holds the Period we run the report for (Period being one of the parameters) but in the SQL query, we have also included…
-
Check before changing values in a lookup table used in HCM
Good afternoon. In Oracle HCM we are planning to modify some values in the lookup table, ORA_HRT_CERT_STATUS. We know it holds status for Certifications/Licenses, with values like Active, Expired, etc. Before we start changing any values in this table we'd like to know if this table is leveraged anywhere else in HCM, other…
-
Rowmark visible on export output of BI Publisher Report with excel template
Hi, I created an excel template based bi publisher report using sql query. Expected Output Country Region State County Item Sales Germany North W1 C1 Laptop 20 Mouse 22 Coffee 100 C2 Laptop 33 Mouse 31 Coffee 311 W2 C3 Laptop 87 Mouse 88 South W3 C5 Laptop 11 Mouse 12 Coffee 12 W4 C6 Laptop 11 Mouse 12 Coffee 12 Spain…
-
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,
-
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 custom Trial Balance Report
Summary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications24B (11.13.24.04.0) Code Snippet (add any code…
-
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…
-
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
-
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!
-
please help with table/ BI SQL query to fetch Work Workday Patterns details
Hi All, Could you please help with table/ BI SQL query to fetch Work Workday Patterns details that we create under setup and maintaince > Workforce Information > Work Workday Patterns. Thanks, Visva
-
BIP report to get the approval status with history and attachments for Leave encashment, salary tras
Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for Leave encashment, salary transfer letter requests along with approval history and attachments if ay in the request attached. Thanks
-
BI Publishing to Object Storage OCI Policies
Hi Folks, I wonder ifany of you OCI gurus have found a solution to my issue. When I try to connect my BI publisher Delivery to Object storage using the documentation and recommendations for policies I still can't see compartments or buckets Doc:…
-
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…
-
BI Publisher Bursting by Multiple Datasets
Content Hi All, We have a very complex report requirement encompassing a total of 3 different datasets (this can be compressed to 2 as one is a 'Summary' dataset and we can summarize within the two detailed sets). Now, we have developed an XML Excel template that has 3 tabs; one for Summary and two for Detailed. Ideally,…
-
Need help in including the FLOW_ID in my BI Publisher report
In my BI Publisher data model I’m using a custom SQL query that returns payroll balances driven from the standard payroll action tables: PAY_PAYROLL_ACTIONS, PAY_PAYROLL_REL_ACTIONS, and PAY_PAY_RELATIONSHIPS_DN (filtered by payroll action type). This part of the query is working as expected. Now I need to bring in the…
-
Oracle Kubernetes - PDF printing on a Kubernetes Weblogic BI server
I install and maintain an Oracle Analytics Publisher that runs on Weblogic for the purposes of printing PDFs from APEX. It is nothing more than the PDF printer. The current effort is to move as much infrastructure to a RKE2 Kubernetes cluster. Are there Helm charts available for this type of install? Does anyone have…
-
Customization of PO Output for Communication
Summary Customization of PO Output for Communication Content Hi, Not able to attach a Customized Template in standard oracle Po Steps. 1. created New template code 2. Created New Data Template 3. Attached as setup in purchasing in Standard PO template 4. Change document style sheet to our new customized template 5. Create…
-
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…
-
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…
-
BI Publisher Template Builder not visible in Word
I am attempting to install the the BI Publisher Template Builder Add-in. And, as usual, having no luck making the Publisher option appear on the Word menu. Software versions on my PC: MS Office 64-bit Version 2209 Build 16.0.15629.20256. Java SE Development Kit version 8 update 311 (64 bit) 8.0.3110.11. Microsoft .NET…
-
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:…
-
OAS 2025 Upgrade Problem. BIP reports are missing Parameters when added to a dashboard page
When we open a BIP report from the catalog, we are able to see the parameters that are built into the report. But when we add it to a dashboard page the parameter is hidden. How can we fix this issue? an Example is shown below The first picture is the dashboard page and the second is when I open it from the catalog.
-
Check Printing : Is there a way to access the signature from a secure web location like SFTP?
Hi All , Is there a way to secure the check signature image on the RTF in Oracle cloud? Like for example access the signature from a secure web location like SFTP.
