-
Editing a BI Job which is scheduled to run daily(destination is email) but unable to find the job
Hello, In our production instance, we have scheduled a BI Publisher report that runs daily and sends out email to a bunch of users. Earlier i used to see the job information which is running daily. Now, we want to add a new user to this list, to I go into the "Report Jobs" screen, try to find my job but does not show up…
-
Sickness Absence End Date not updated in ANC_PER_ABS_TYPE_ENTRIES table
We initially have had an existing approved Sickness Absence for an employee with duration - Start Date - 01/06/2025 End Date - 28/06/2025 Then we have modified the End Date and updated the End Date to - "Open Ended" absence. Now the End Date has been updated in ANC_PER_ABS_ENTRIES table, but it's not getting updated…
-
RE : Purchase Requisition PDF Layout – New Attributes Not Showing in Fusion Print Outpu
Hi everyone, In Oracle Fusion, I have updated the BI Publisher data model for the Purchase Requisition (PR) report by adding new attributes. I have also modified the RTF layout in BI Publisher (via MS Word) to include these attributes. When I run the report directly from BI Publisher, the new fields appear as expected.…
-
RTF Repeating Groups and naming Excel worksheet Tabs
Hello, I followed the resource link https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#BIPRD3325 My problem now: I am now getting the separate tabs with labels but they are not populating data (even though there should be). Only the first excel tab is capturing all the…
-
Hiding the Zero Amount transactions from Create Customer Statements Seeded Report
Organization Name BURNCO Rock Products Ltd Description Hi , As of now "Generate Statement Report" seeded report is displaying the zero balance transaction(Amount Due).But is there a way to hide the transaction who has zero balance.? scenario -- IF we have Invoice(Invoice#: DIN-99) and it has zero balance . -- We have…
-
generate tabs in xpt template split by dimension
Is there a way to split output into separate tabs based on a specific dimension, dynamically? My specific example is that one of the report columns contained is a dimension called "Business Unit". I want to have a separate tab created for each business unit that may arise in the output. Generating tabs dynamically is…
-
Grand total by unique employee id within group
Hi Gurus This is my xml layout. My group is by <?for-each-group:row;./A.DEPTID?>. Now the employee id although unique can come up in multiple rows. Lets say as for example this employee 10021 comes up 10 times…. so maybe for row number 2 and row number 5 and row number 8, etc… etd… I need to sum up the H.AG_HOURS_AVAILABLE…
-
Month Comparison Is Not Returning Correct Data
For our statement of account I need to compare months to decide which data to show. In the example below, I only want data to show if the months are equal. Here is the code I am using: <?Date___local_ID669?> <?for-each:A_R_Statement_Detail_S9?> <?xdofx:if to_char(Invoice_DueDate_ID67,'MM') =…
-
Adobe acrobat pdf output issue after downloading pdf from report history
I am able to see the pdf outputs in Adobe Acrobat when I executed the report from report analytics screen by using view report option after exporting into pdf output. However the same report I have executed with Schedule option and then downloaded the report pdf output from Report history, when I opened pdf output in adobe…
-
Report Layouts on APEX 24.2 don´t show images
Hello Everybody. I made a Report Queries, made a RTF in Word/Bi Publish and put a image in header and footer and made an upload. When I execute application and run report, the image doesn,t appear and show me some special caracteres. Are the someone who had the same problems or somebody can help me, please.
-
Help with XML BI Publisher Templates in Oracle
Hi, I'm trying to update my offer letter templates in Oracle. These are done through BI Publisher in Word. I'm looking for a syntax that will print one paragraph if Location_Name = one of the 4 different locations, and if Location_Name is NOT = one of the 4 locations, then print a different paragraph. This is what I had…
-
Is is possible to invoke OIC (APP driven orchestration) from BIP report?
Hi, We have a requirement to invoke an OIC (APP driven orchestration) from an ESS job via BIP. Please let me know if this is possible and anyone has achieved it. Doc ID 2642375.1 says that Oracle doesn't support RESTful data sources. I have tried this by following steps mentioned in this blog…
-
Username and display showing incorrect when logging into BI Publiser with SSO
We have a Read Only SQL Authenticator Provider configured in WebLogic and in Oracle Analytics (BI) we are using the HTTP Cookie method to get a token that represents an authenticated user. We reference the token in the provider specific queries and SSO into Oracle Analytics works. However, the User ID and Display Name…
-
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?>…
-
Any query for BIP with General ledger + budget + PO detail
-
Number field not displaying correctly on RTF
I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that is not displaying correctly. It seems to be reading the decimal as a carriage return. What's strange, is that when the report is bursted in our Test environment,…
-
Need to group duplicate headers into single header on RTF template
This is for Commercial Invoice report and the XML is something like this: <G_HEADER> some info: X1 <G_UOM> Pounds <G_LINES> some info </G_LINES> </G_UOM> </G_HEADER> <G_HEADER> some info: X1 <G_UOM> Each <G_LINES> some info </G_LINES> </G_UOM> </G_HEADER> The header info is exactly the same but populating in 2 separate…
-
How to setup security on a Custom BIP folder?
We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permissions?
-
Editing RTF Template Error
Hello, I have an RTF Template that I am attempting to modify which is used with a BIP report. I need to modify the grouping of some of the fields in the template so that date fields are appearing directly side by side. I downloaded Oracle Analytics Publisher, but whenever I attempt to upload sample XML output from a report…
-
BI Publisher sum values
Summary BI Publisher sum values Content Hi all, I am trying to create into a .rtf Template a total row with the sum of the values below : <DATA_DS> <G_1> <LINE_NO>1</LINE_NO> <AMT_POS>324</AMT_POS> <AMT_SEC>1170884</AMT_SEC> </G_1> <G_1> <LINE_NO>2</LINE_NO> <AMT_POS>294725829</AMT_POS> <AMT_SEC>8233780</AMT_SEC> </G_1>…
-
How to get list of printers defined in BI Publisher using SQL
How to get list of printers defined in BI Publisher using SQL. Like here is the list *removed attachment for security reasons I would like to query this table and get list of configured printers.
-
Amounts to be displayed based on entered currency this should be in sql query no seeeded code.
-
Assistance Needed: "Failed - IO Error" When Customizing Standard Report in Oracle Fusion
I’m encountering a “Failed - IO Error” when attempting to customize a standard report in Oracle Fusion. After exploring the community forums, I found that this issue is often related to permissions. However, I’ve already verified that I have all the necessary roles and permissions mentioned in the discussions, but the…
-
Missing data in Bursting BIP report
I have 2 data models which are independent of eachother 1st data model has details 2nd data model has summary that shows a count of records in bursting, my 1st data model table shows data as expected but my 2nd data model table shows column headers with no data. However, when i run the report from back end it shows both…
-
BIP Report produces output when bursting is not selected, when bursting selected no output
We have an odd issue with a report with bursting that suddenly has stopped working. The report output is produced when the report is scheduled without the bursting option. When the bursting option is selected, there is no output - however, clicking the XML link shows report data. The xml confirms that the 'key' is present…
-
Using a locale variable in OAP template
Hi all, Is it possible to define a locale as a variable in a RTF template loaded in OAP ? I have 1 invoice template that can have different formatting based on the customer locale. Do we need to define 2 separate templates or could it be the same template accepting different locales to format the fields accordingly ? For…
-
How can we track actual delivery status of an email sent to user by email bursting
Hi All, We are bursting emails to users with customized version of seeded reports via BIP email bursting. There is a business ask to validate actual email delivery status of email being delivered to user inbox or not. We can see email sent status in bursting details in Job history page. But it goes to success even in cases…
-
XML-RTF Guidance for 9box Talent Grid
Hi there. I built a custom / dynamic 9 box, with different fields/toggles, etc. The values/employee names in the 9box get long, so I'd like to say, "if there are more than 10 employees in this box, place the first 10 employees in column a, and the rest in column b. here's an example of just one of the 9 boxes, with just…
-
BI Publisher report encryption
Hi, we are using OAS 7.0, OBIA 7.9.6.4, EBS 12.2.1 with Oracle19c database on Linux. We have a BI Publisher report that runs on a query based on EBS tables (real time) which has sensitive data. We have made the report content that is distributed as email attachment, password protected but the users are asking for the…
-
Data not being picked by XML generated by the Data Model
Hi, Suppose , I have a column called attachment name in my data model along with other columns . But remaining columns have data , but attachment name column there's no data for the first five rows and then there is data in 6th row and 7th row . It's not consecutive. It might be present for those invoices where the…
