-
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 can I add parameters to a seeded BI Publisher data model
We have a validated seeded data model (Journal Entry Reserve Ledger) for fixed assets that we want to add a Line of Business, Location, and Department parameter (Segment 1, 2 and 3) so managers can run the report for their respective departments. We continue to receive an error after adding the parameter and opened an SR…
-
BI Publisher interactive report row limit
Hello, I have a question about the row limit of an Interactive BI Publisher report. Currently, I get as an output 200 rows, which matches the limit of the Data Model and I would like to know if there is an official limit for this type of output. By checking the community, I came across the thread…
-
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?
-
How to setup LDAP configuration in BIpublisher
Hi All, I need help in config the LDAP and assigning the roles to the users and catalog. We have created XMLP_ADMIN group in LDAP and assigned XXX user to this group. While login to BI publisher with the XXX user unable to see the admin privileges. Regards, SM
-
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.…
-
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
-
Facing Challenge in Comparing 2 parallel groups in RTF having multiple records
I'm facing a challenge within an RTF template. I need to compare two groups of data. These groups are parallel, share a common parent, and may contain duplicate records. My goal is to identify and exclude records from the first group that also exist within the second group.
-
RTF split to different PDF is not working
Summary RTF split to different PDF is not working Content Hello, I have a custom RTF template and an XML data file. The XML contains 3 records for employees each with a child tag for reference code. I would like to have the output split for each of the reference code( e.g. 3 separate PDFs ). Unfortunately , the example of…
-
Unable to install BI publisher plug in in my windows
Receiving errors Word 2007 flg get failed and 64 bit failed while i am trying to install BI publisher 64 bit in my windows system. Any help would be appreciated.
-
How to Restrict Infolets for Business Unit(BU) created under Analytics in Oracle Fusion.
How to restrict the Infolet for Business Units is there any EL expression for this? I trued to restrict it's Visibility for Role using EL Expression and it's working i.e #{securityContext.userInRole['ROLE_CODE1,ROLE_CODE2']} Same way how we can restrict it for particular Business Unit? Here is the image of infolet: Please…
-
Error while trying to login to report server using BI publisher tool
I am trying to login into test instance
-
SSH key format - do we need to update?
Hi - we needed to convert our SSH private key to the new format in order to load into one of our dev environments. Do we need to update our production key (it's still aes256-cbc format - we uploaded it in 2019) it still works in prod. thank you.
-
Hi, how can I ensure the space infront of the word " certificate" remains when the pdf is rendered?
<?FOR-EACH@inlines:row_RU_FOUNDATN_WRK?><?IF@inlines:fld_DESCR254A!=''?>and <?fld_DESCR254A?> certificate<?END IF?><?END FOR-EACH?>
-
RTF file Configuration for Eliminating Null Value Column
I am creating an RTF file using Word table with 3 fixed columns and another 4 columns that I do want to show the non null columns If a column is totally null values i don't want to show, is that feasible ?
-
Aloha Analytics Community
My apologies as I come here to ask you this. Perhaps it will she some light to some of our company experience with Oracle. We are a WACS customer and so far no Oracle person I spoke to has been able to tell me where in the Cloud (Identity - Domains) I can find the User permissions for BI PUBLISHER. Do any of you know this?
-
How can we add the filter parameters 'from and to date' in etext formate
Hello, We are attempting to add filter parameters, specifically for the "from" and "to" dates, to a BIP report created using an eText template. However, we are currently unable to incorporate these filter parameters into the eText layout. Could you kindly assist us with this? Thank you.
-
Cannot handle Null cells in calculated columns from layout editor in BIP
We are creating a report using two data set - one is SQL based and another is loaded from excel. Using layout editor we are trying to create a calculated column subtracting where col2 is from excel data set and col1 from sql data set, where in a cell in col2 the value is null and there is corresponding value in col1 but in…
-
BI Publisher management of multiple simultaneous exports
I have to send several times a day about 50 exports at the same time. I have a question and a problem. Is it possible to program schedules by script? It's hard to do them manually and especially the changes. Each time, the 50 exports open and close an SFTP connection to send the report. Sometimes, a few exports get wrong…
-
Bi Publisher - add x days to a date element in rtf template -FA24D
What is the function to add one day to an RTF Template? Below function is not working for me in FA 24D <?xdoxslt:ora_format_date_offset(YOUR_DATE_FIELD, 1, '+')?>
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL Table
Hi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle document (Doc ID 2377015.1), but the issue is that one party is having multiple customer accounts. unable to identify the exact ship to customer. Please…
-
How to edit the sales order Report data model
I want to add new columns in the sales order print dala model. But I found out that the data model is not in sql but in XML format. When I downloaded the file it is in .xmdz file extension, which not opening in readable or editiable mode. Please help me in finding a way to add new columns in the data model of sales order…
-
Query to find the tax Reporting code using the tax rate from zx_lines?
The tax Reporting Code is in the table - ZX_REPORTING_CODES_B I need help on how to join this table with zx_lines, or join tax rate with tax reporting code?
-
Encoding type of BI Publisher
Hi, My report has been encoded in UTF-8 BOM, and the customer wants UTF-8 not BOM. Is there option to change the encoding method? how can I do it? Thanks all!
-
BI Publisher 12 > update an XLS template, only the RTF format is offered
Hello, I have been working with BIP12 recently, I want to update an Excel model, but only the RTF format is offered. When I create a new model, the Excel format is suggested. Do you know where the problem could come from ? Thank's
-
Need details or white paper for the function per_availability_details.get_schedule_duration
We need details on the parameters used in the function per_availability_details.get_schedule_duration. Any document or white paper or any clue regarding the details of the parameters is appreciated.
-
How to use if statement for comparing dates in BIP template
Summary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statement Data Model to show me the apply_date of the payment. Now I wish to show payments only where the apply_date is before the statement_date. I have put in…
