-
ODI 12c Date Conversion with OBIApps OOTB Mappings
ODI Upgrade to 12c apply TO_CHAR(DATE) results in DD/MMM/YY instead of DD-MMM-YY TO_CHAR(SQ_KK_ACTIVITY_LOG.KK_TRAN_DT)||'~'|| Problem Description (ODI/OBIapps) on premise for peoplesoft --------------------------------------------------- When executing a Scenario in ODI 12.2.1.4 , the TO_CHAR(DATE). results in 'DD/MMM/YY'…
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered error
Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : Please help. Thanks
-
Data Lineage for BI Apps
-
Audit Report to fetch the details of the users who made the changes on ROle to reproting Permissions
Hi All, We have a requirement to fetch the details of the users who made the changes on ROle to reproting Permissions on BI Catalog Folders/Reports
-
opatch apply -ocmrf file format for silent patching
Hello All, I have searched in all the wrong places, now come begging here for help: when I apply a patch ( opatch apply ) I have to answer two questions with "Y", is there a resource file format ( for -ocmrf rf ) that can be shared or a script/bin to generate it. I looked in $ORACLE_HOME/ocm/bin, but that was empty. I need…
-
How to run the bulk agents in parallel.
Hi all, We have more than 300 agents scheduled to run at the same time. Is there any way to run them in parallel in the database instead of changing the time for each one individually? They are all running simultaneously in the database, and some are erroring out due to high volume. Any suggestions on how to handle this?…
-
Suggested method for handling deletes when Using BICC to extract PVOs
We are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics. Noticed that BICC Application Data Extracts only captures updated and new records, but doesn't capture deletes. Full table loads is not a sustainable solution as the data continues to grow. We figured that Active Primary…
-
How to Integrate ODI 12c with Essbase21c on OCI platform
Hello Experts, I would like to know if anyone Integrated ODI 12c with Essbase21c on OCI for data load. It would be great if you could share any documentation for this requirement. Thanks
-
Any recommended courses for BI Publisher Editor for Word?
Does anyone have recommendations for courses for using the MS Word plugin editor for BI Publisher. Specifically courses that help with the understanding of how to build formulae using XSL or SQL functions and from a layman's perspective with little or no experience in these topics. This page is available but its a bit…
-
No option to output format in excel 2007+ .xlsx
Hello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Microsoft as part of its Office suite over a period of time. XLS being the oldest and widely used file type is also known to be the Excel97-2003 file format. The XLSX…
-
Reg OBIA - oracle business Intelligence application - license
Dear Team Please let me know, is oracle still selling OBIA 11.1.1.10.3 PS4 license, as i heard from public it was stopped. we are having roadmap to setup latest OBIA 11.1.1.10.3 version and utilize for next 10 years by 2030. we may have plans to go Fusion ERP from on-prem EBS, so in that case OBIA 11.1.1.10.3 will be…
-
24B: BIP - What is the subject area or tables to get transaction approvers from Learning?
Please provide the subject area or an SQL tables to retrieve transaction approvers from the Learning module (24B). I have tried using this one, but it doesn't return any results. select wft.* from Fusion.hrc_txn_header txnh , Fusion.hrc_txn_data txnd , FA_FUSION_SOAINFRA.wftask wft , fusion.hrc_txn_error txne ,…
-
DB upgrade in OBIA 11.1.1.10.2
Hi, We now have OBIA 11.1.1.10.2 installed on RHL with target DB Oracle version 12.2 and OAC as frontend with RPD loaded. We are planning to upgrade the DB version to 19.23 . The db is installed on a dedicated VM , separate from the VM on which the other BI components are installed. Is there any activity to perform on the…
-
How to insert log messages into FSI_MESSAGE_LOG table for user-defined PLC/Data Transformations(DT)?
I have created a custom DT and ran it through TRANSFORM LOAD batch. Though the batch is successful, I can't see the batch log entries in fsi_message_log table. Please help me to generate DT log into this table.
-
OS upgrade for ODI 11.1.1.9 installed on RedHat Linux 7
We have ODI 11.1.1.9 installed on RedHat Linux 7. My company require to upgrade OS to RHL 8. Compatibility matrix odi-11gr1certmatrix-11-1-1-9-0-2541436.xls do not certify this configuration. Is there a most recent compatibility matrix that allow this configuration or anyone has tested this configuration? the other…
-
Error Codes: ACIOA5LN
Hi everyone, maybe someone could help me. When I am applying a CAST function (converting a number into character) for one column, then I got this Error message : Assertion failure: pLhs != 0 && pRhs != 0 at line 108 of inc/nq/webtable/promoter.h Error DetailsError Codes: ACIOA5LN Does someone knows why it does not work?
-
Need query for the notes created at AR transactions level
-
Drop ODI COPY$ tables after data load completion
Hi, In ODI, during the data load it creates COPY$ tables in Oracle DB. In some cases, we get lot of copy$ tables getting created in DB and those are occupying more DB space. We would like to know if any of the ODI built in feature is available to drop the COPY$ tables. Ex: COPY$768398_BAD, COPY$768399_LOG. Thank you!
-
How long does ERP data gets committed to Oracle database
Hi, This question is raised due to a production issue we had when extracting reports from the ff table: AP_HOLDS_ALL PO_DISTRIBUTIONS_ALL These are 2 out of 34 tables that we are extracting hourly. Since 24A, we've found missing records and whenever we re-extract we got to pick all the rows that we are expecting. We are…
-
Published Dashboard not displaying content
Please advise, I published a dashboard after completing with the development, after publishing other users cannot view the dashboard. They can only open but there is no content on the dashboard
-
Oracle Informatica PowerCenter and PowerConnect Adapters
Hi All, Can you confirm if the Oracle Informatica PowerCenter and PowerConnect Adapters license allows to migrate to Oracle Data integrator at no cost? Otherwise, what are the possible sales scenarios for this migration? Regards Habib
-
RPD Developement (two tables from different schemas)
Good day, Please kindly assist is it possible to create a single subject area from two tables that sit in two different schemas in the database. I created two separate connection pools to pull the tables. Schema names ADMPROD1 and PXRPT1
-
Client requires a repository with version 05.02.02.09 but the repository version found is05.02.02.11
Hi Team, We installed the OBIA 11.1.1.10.3 version with ODI 12.2.1.4.0 version in the Linux box and I have downloaded the ODI version 12.2.1.4.0 in the Windows machine RDP 2022. When I am trying to access the repositories with the ODI studio getting an error message, please provide the solution for connecting to the…
-
Any interface not executed in odi11g
Any interface not executed in odi11g am checked in service still working fine but loadplans still running status not executed. How to clear the cache in odi 11g And how to resolve the issue could you please give me information anything.
-
Not able to get the work item details for few transaction in the collection dashboard
We are unable to derive the work item details like strategy task name and status for many of the transactions present in the collection dashboard. Could you please let us know how to extract the details of strategy task details in the backend. Attaching the query that is currently being used to derive the same. Please let…
-
Timestamp Sorting in BIP App
Is it possible to sort all fours rows by Timestamp? I tried to sort by timestamp per group, however the FYI is not sorting accordingly.
-
How to restrict access to audit tables in fusion HCM
Hi All, We have a certain requirement to restrict access to audit tables like "CMP_SALARY_" in fusion HCM. People with only specified roles/permissions should be able to query this table. Is there anyway or workaround to restrict access like this? Thanks, Thimmaiah
-
Individual mapping is running fine but while running same in load plan getting failed
Individual mapping is running fine but while running same in load plan getting failed That columns just i am mapping source to target but same column names both tables. When I manually ran the mapping It's successful but when I run the loadplan failed. Could you please let me know how to resolve the issue. Thanks
-
ODI scheduler not working.
Hi Team, We are using the ODI 12.2.1.4 version in bi apps 11.1.1.10.3. when we try to schedule the load plan or any scenario, it is not getting executed as scheduled. We have cross-checked the agent and it's running successfully. we have also updated the agent after job scheduling. We have scheduled the jobs after business…
-
ESS job always in Running status and never updates. Failed to call back ESS server
Hi! I have an issue running ESS jobs for BIP reports. The status of job is always Running and never changes. At the same time I can see output file is successfully generated. Just status haven't been changed. From the BI side I can see this job in status ‘Unknown’ and has such message inside: Waiting Time: 0.2 seconds Data…
