-
Barcode printed but not scanning after updating RTF design in JDE
Hello, I recently updated the design (borders and layout) of an existing RTF template. While the barcode prints clearly, it is no longer scannable. No changes were made to the barcode logic or font. Could this be related to the quiet zone or BI Publisher rendering? Any advice would be appreciated.
-
How To Format Numbers As Text So That The Report Output Displays Leading Zeros Without Leading Space
On : 5.6.3 version, Designing Layout Templates Have custom reports that need to be generated in either PDF or EXCEL format. In the XML rtf template, in order to preserve the leading ZEROs in the ACCOUNT_NUMBER when generating EXCEL format, define ACCOUNT_NUMBER as 'Regular text' and use Force LTR option. For example: The…
-
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".
-
Sample REST API url and payload to call BIP Report
Hi Team, We have requirement to call BIP report through integration in which we need REST API to call. I have standard REST API that is Run Report : /services/rest/v1/reports/{reportPath}/run url but help us to prepare sample API and How to pass the parameter.
-
Auto Numbering Adjustment in RTF Templates for Offer Letter
Customer have multiple paragraphs in a Offer Letter template which are numbered and some of them have conditions so if the condition is met the paragraph is displayed, if not it is hidden. The challenge we are facing is to re-number paragraphs if there are hidden paragraphs due to conditions not satisfied in-between. e.g…
-
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…
