OptimEBS 6.1 Application Setup 이슈 (P2P)

현상 : OptimEBS 콘솔에서 Configure > Archive Environment > Application Setup에서 P2P(AP/PO) 설치시 발생

이유 : 콘트롤 테이블에 프로덕션 테이블에 없는 테이블이 포함되어 있다.

해결 : 콘트롤 테이블 컬럼 값 삭제

Problem(Abstract)

This document describes a known issue with Optim Data Growth Solution for Oracle E-Business Suite related to a setup failure in the Procure to Pay application.

Symptom

The application setup for the Procure to Pay fails and the E-Business Suite console log entry gives the following error message:

Could not create archive tables.  Error creating tables (see log)

- PO #= 27, 0, 0, 43

Cause

The application setup fails because the setup control table contains entries for tables that are not in your production system.

Resolving the problem

Use the following SQL statement to remove the entries from the control tables:

delete from A4SOAE_CTL_VALUES where arch_value in ('AP_MC_PAYMENT_DISTS_ALL', 'AP_MC_RECON_DISTS_ALL', 'AP_MC_TRIAL_BALANCE');

After the tables are removed, re-run the Procure to Pay application setup.

http://www-01.ibm.com/support/docview.wss?uid=swg21398858