SA-28087

Summary

BIX extraction configured to write manifest data to a target database.  Extraction is failing to write the PR_EXTRACT_SUMMARY and PR_EXTRACT_DETAIL manifest tables in target database.
 

Error Messages

ORA-00942 table or view does not exists

Steps to Reproduce

1. In extract rule select the "Include Manifest" option and Output Format to be a database and specify the name of the database where you want the manifest to be written, for example yourTargetDB
2.  Run extract and see error in logs.

Root Cause

A defect or configuration issue in the operating environment.  The yourTargetDB default schema is not defined and as a result the current schema of the database user running the system is being used.

Resolution

Add a prconfig (or Dynamic System Setting) setting like this for your TargetDB replacing yourTargetSchema with the name of the default schema where your manifest files are found in the yourTargetDB database. 

<env name="database/databases/yourTargetDB/defaultSchema" value="yourTargetSchema" />