Oracle Data Integrator Array Fetch Size and Batch Update Information

Important Links

Oracle Support
Batch Update and Array Fetch Values Impact on the Performance of ODI Processes (Doc ID 424482.1)

Oracle Data Integrator 11g and 12c Repository details

Refer to oracle support:-

Oracle Data Integrator 11g and 12c Repository Description (Doc ID 1903225.1)

List of Useful Oracle Support Docs

Discoverer

1. Discoverer 11g Querying Against An E-Business Suite 12 Multi-Org VPD Protected View With ORG_ID Returns No Data (Doc ID 732826.1)
2. How To Run SQL From A Discoverer Applications Mode Workbook In SQL*PLUS (SQLPLUS) To Troubleshoot Performance And Worksheet Results (Doc ID 279736.1)
3. How to query in SQL for org-specific data in a MOAC environment (Doc ID 415860.1)
4. How To Retrieve Rows From Table Or Synonym For An ORG_ID In E-Business Suite 12 (Doc ID 787677.1)

OBIEE

1. OBIEE 11G: Integrating Oracle Business Intelligence Applications (OBEE) With Oracle E-Business Suite (Doc ID 1343143.1)
2. Can You Migrate An E-Business Suite 12 Discoverer End User Layer ( EUL ) to OBIEE? ( Doc ID 1066087.1 ) 
3. 2.6.1 Oracle BI Applications Authorization for Oracle EBS
   http://docs.oracle.com/cd/E20490_01/bia.7963/e19042/security.htm#CJAHFDJJ 
4. Applying Data Access Security to Repository Objects
   http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/dataaccess.htm#CHDJGHAH 
5. https://docs.oracle.com/cd/E23943_01/bi.1111/e10543/privileges.htm#BIESC6053 

ODI





Database

Oracle Data Integrator Best Practices: Using Reverse-Engineering on the Cloud and on Premises

http://www.ateam-oracle.com/oracle-data-integrator-best-practices-using-reverse-engineering-on-the-cloud-and-on-premises/

Procedure to reset a oracle sequence

-------------------------------------------------------------------------------

CREATE OR REPLACE PROCEDURE reset_seq(

    p_seq_name IN VARCHAR2 )

IS

  l_val NUMBER;

BEGIN

  EXECUTE immediate 'select ' || p_seq_name || '.nextval from dual' INTO l_val;

  EXECUTE immediate 'alter sequence ' || p_seq_name || ' increment by -' || l_val || ' minvalue 0';

  EXECUTE immediate 'select ' || p_seq_name || '.nextval from dual' INTO l_val;

  EXECUTE immediate 'alter sequence ' || p_seq_name || ' increment by 1 minvalue 0';

END;

/

---------------------------------------------------------------------

DECLARE

  P_SEQ_NAME VARCHAR2(200);

BEGIN

  P_SEQ_NAME := 'W_DUMMY_D_SEQ';

  RESET_SEQ(

    P_SEQ_NAME => P_SEQ_NAME

  );

--rollback; 

END;\

Link:- 

http://stackoverflow.com/questions/51470/how-do-i-reset-a-sequence-in-oracle

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1119633817597

Oracle.odi.core.security.BadCredentialsException: ODI-10199: Incorrect ODI username or password

Below links should help to solve the issue.

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1590071.1

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1913660.1