MSDDEMCCONV - Collect Currency Conversions Errors ORA-00903 After Data Cleanup Script from Bug 6455083 (Doc ID 465835.1)

Last updated on OCTOBER 22, 2012

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Nov-2010***


Symptoms

On 7.1.1 in Test:
User ran a data cleanup script from Bug.6455083 (71) DOWNLOAD OF UOM CONVERSION ERROR ORA-01747
INVALID USER.TABLE.COLUMN . After that, Currency Collection failed. Before data cleanup, the
currency collection completed successfully. MSDDEMCCONV module - Collect Currency Conversions -
errors with the following:

**Starts**24-OCT-2007 09:14:04
**Ends**24-OCT-2007 09:14:05
ORA-00903: invalid table name


STEPS
The issue can be reproduced at will with the following steps:
1. Perform the data fix script from bug 6455083
2. Run Collect Currency Conversions concurrent request and it fails

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms