-
Is there any release of BI for Oracle Linux 8 having ARM64 Architecture?
i was thinking of installing BI on Oracle Linux 8 having ARM64 Architecture Can Someone share the link?
-
OTBI Workshop / Training
My organization is migrating to Oracle ERP. We are going to use OTBI for reports and graphs generation. Any recommendation for OTBI workshop or training?
-
Unable to bring up DAC after changing the DAC database password
We have changed the DAC user password in database. After that we are not able to bring up the DAC services. Below is the error log. Please help on how to resolve the issue Log: 4 INFO Tue Nov 16 06:40:15 EST 2021 Application booting up... 6 INFO Tue Nov 16 06:40:16 EST 2021 Creating repository pool 7 SEVERE Tue Nov 16…
-
Extract flex field descrition with BICC or API
Hello,how I could extract the description of the segments of the GL account with the BICC or with APIs?Thanks
-
Procurement OTBI Reports - Upgrading from EBS to Fusion
Is there a list of Seeded EBS reports that lists out each report and which Fusion seeded report that is replacing it? Specifically: Encumbrance Detail Report (XML) Mass Update of Purchasing Documents Mass Update of Requisitions Open Purchase Orders Report (by Cost Center) (XML) Open Purchase Orders Report(by Buyer) (XML)…
-
Oracle Analytic Desktop hangs with ODBC connection while reading tables from Vertica DB.
Oracle Analytic Desktop hangs with ODBC connection while reading tables from Vertica DB. Below are the steps: 1) Create System DSN with Vertica DB. 2) Create connection in Oracle Analytics Desktop with the DSN using ODBC. 3) Preview the table's data. Do this repeatedly for 5-6 tables. Oracle Analytics will hang and on…
-
Poor performance when bursting is used to distribute output via email. Why?
We have a simple ESS report to select AP invoices and email the details to suppliers as confrimation invoice is received. The query on its own runs in a matter of seconds but when bursting is turned on the process can take upto 20 minutes irrespective of whether we are processing 2 invoices or 200. Has anybody expereinced…
-
How to setup Procurement category Hierarchy? How to import Items into Fusion
Could you tell me if there is a FBDI template that can push the items into fusion? Also the step by step procedure to import the items and form a hierarchy
-
First Day of Previous Month and Last Day of Previous Month - BI Publisher
Hello, I am using BI Publisher (12.2) Data Model and in the parameters, I am to get the first day of previous month and last day of previous month. can anybody suggest how to do that? appreciate your help. Thank you,
-
bia 11.1.1.10.2 standard loadplan siebel - missing siebel tables (s_etl_prd_rel..)
After installation we generated and ran the standard load plan siebel_8_1_1... from biacm. The Load Plan failed because the table s_etl_prd_rel was missing. After some investigation we found in an comparable setup, we found out, that some s_etl tables were not defined in the siebel schema of the siebel db itself but in a…
-
OBN Trading Partner missing Username and Password
Have a Trading Partner that can't login to OBN due to the associate who did the setup for Username Name and Password is no longer with company and info wasn't transferred. Is there a way to change username and password. They have tried everything they know to do.
-
Moved: How can I create the possibilty to choose oci as a connetion type in the Oracle Analytics Cl…
This discussion has been moved.
-
Oracle BI Publisher does not locate CSV file path
I have a CSV file located on my C drive: I have set up a connection from my Oracle BI Publisher reporting tool to this local csv file: Then when trying to create a data model from the connection, using the CSV option, I get an error message saying that the file is not found: I really don't know what I am doing wrong here.…
-
How to display amounts in Excel Accounting format?
Hi, Oracle EBS 12.1.3 Using BI Publisher, how do I display the amounts in Accounting format in Excel? I am able to display the amounts in the currency format using <?format-number:ITEM_TOTAL;'$9G999D99'?> However the business wants it be displayed as below (Accounting format in Excel) where zeroes are displayed as dash.…
-
Can we create one Hierarchy with Multiple Dimension
Can we create one Hierarchy with Multiple Dimension in OBIEE 12c EX:
-
Concatenate with a CASE WHEN STATEMENT - Oracle Business Intelligence - OBI
Is it possible to create a CASE WHEN statement and concatenate results? For example: CASE WHEN "A" IS NULL THEN 'Orphan -'|| "A" ELSE "A" END
-
Oracle Administration Tool for Linux (Oracle Analytics Server)?
Hey there, I am searching for the Administration Tool for Oracle Linux 7 to modify the metadata from the Oracle Analytics Server. I searched through the whole internet to locate an Oracle Administration Tool for Linux but I cant find it. Is there a proper alternative to use for Linux? Thanks 🙂
-
Moved: FDMEE pass POVPeriod to Essbase script - multi periods issue
This discussion has been moved.
-
ODI client asks wallet password, even if nothing has been set. In Oracle BI Apps setup.
Hi All, Recently I have installed Oracle BI Apps 11.1.1.10.2 on Linux OS by following below link. https://docs.oracle.com/applications/biapps102/install/GUID-0EAF50FB-0A44-4E88-B3B1-09A5F3E806D2.htm#BIAIN24468 My Installation is 100 % successful without any error. I am also able to access Weblogic Console,EM, Analytics,…
-
Informatica PowerCenter
Hello, can someone give more information regarding the link between Oracle Informatica PowerCenter and PowerConnect Adapters and Informatica PoweCenter, if there is any? Much appreciated. Thank you.
-
Dynamic Hyperlinking within a BI Publisher RTF Template
I am creating an RTF template which contains the master report and detailed report. The Master report (page 1 ) contains the list of all order numbers. The Detailed report (succeeding pages) should contain 1 order number per page. The requirement is that when the order number is clicked from the Master report, it will be…
-
Malformed INSERT with Table to File mapping
Hello All, Could you help me with my DB Table to Flat File mapping in ODI studio. This is just a simple mapping for testing/development/purposes. I've created the necessary models, both components are visible in the Editor, the mapping validation passes. However, when executing, I receive the following error: ODI-1217:…
-
Oracle Analytics Desktop - Blank Screen Issue - Windows 10 Enterprise
Hello Team, I was able to download and install the Oracle Data Visualization Desktop (Oracle Analytics Desktop) (6.1.0) with admin privileges from https://www.oracle.com/solutions/business-analytics/analytics-desktop/oracle-analytics-desktop.html. OS - Windows 10 Enterprise - 64bit But when I am trying to start it, it just…
-
SEVERE: MESSAGE:::<Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 's
Does anyone know or has any solution while assembling a Subject area or building an execution plan getting following error? Sep 24, 2020 2:15:55 PM com.siebel.etl.engine.core.ETLUtils logException SEVERE: MESSAGE:::<Line 600, Column 6>: XML-20121: (Fatal Error) End tag does not match start tag 'sqlStatement'.EXCEPTION…
-
dynamic content of footer base on field
Hi everyone, I run xml on bi puplisher on word. I create a footer section by custome code in my body code" <?template: footer_content?> A <?end template?> and on footer section I call: <?call: footer_content?> <?end call?> A is where I want to change dynamic value of filed of student_number.But i don't know how to code…
-
Connect BI Publisher to Cloud Autonomous Databases
Hi, Can you please advise how to connect BI Publisher from Microsoft word to Cloud Autonomous Databases. Regards, Murad
-
Fail Generate Load Plan
Hi All, While generating Load Plan in BIACM, the generation fails saying: "java.lang.NullPointerException at oracle.apps.bi.lp.gen.LPG_ODIRep.buildLSCacheforOdiRep(Unknown Source) at oracle.apps.bi.lp.gen.LPG_ODIRep.<init>(Unknown Source) at oracle.apps.bi.lp.gen.LPG_Generator.generateLP(Unknown Source) at…
-
ETL process fails to run with error
Hello, I am dealing with an issue involving DAC. Since the start of 2021 users are seeing their Siebel Answers reports not showing updated data. I researched and found a solution to this issue on docs.oracle.com that basically involved removing the refresh date from W_DAY_D table and setting the $$END_DATE parameter on a…
-
oracle.xdo.servlet.data.DataException: java.io.FileNotFoundException: /u01/appadmin/temp/xdo/ssi/tmp
When running scheduled BIP report few reports fail with below error. We have a clustered environment [2021-06-15T21:54:12.683-07:00] [bi_server2] [WARNING] [] [oracle.xdo] [tid: 345] [userId: weblogic] [ecid: 8237d503-ca04-4036-82e1-b4d2b7b159be-0000000a,0:165:13] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name:…
-
LDAPSecurityHandler][STATEMENT] CSF is not enabled.call internal decrypt logic
Hi, In order to save BIP reports using the SFTP delivery channel, we get the following errors below: [060721_114031554][oracle.xdo.servlet.security.LDAPSecurityHandler][STATEMENT] CSF is not enabled.call internal decrypt logic [060721_114031555][][STATEMENT] java.lang.NumberFormatException: For input string: "LI" at…
