BIAPPS

General Articles

  1. What Is Oracle BI Applications?
  2. Oracle BI Apps – Troubleshooting – DAC and Informatica Logs – Part 1
  3. Oracle BI Apps – Troubleshooting – DAC and Informatica Logs – Part 2

Issues Encountered

  1. S1000: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01917: user or role ‘SSE_ROLE’ does not exist
  2. Issues while connecting the DAC to the Informatica Integration Service
  3. Informatica: WRITER_1_*_1> WRT_8229 Database errors occurred: ORA-03114: not connected to ORACLE
  4. ETL – ORA-01438: value larger than specified precision allowed for this column BALANCE_ACCT_AMT of W_GL_BALANCE_FS table
  5. Performance Issue: Task PLP_APXACTSGROUPACCOUNT_A1_LOAD Takes a Long Time to Complete