Publish DM -APCC Measures Workflow Failing on step "Archive Demantra Plan" ORA-00904: "T"."SDATE": invalid identifier

(Doc ID 2312715.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.6.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.1 version, MICC Transfer to TSC

Publish DM -APCC Measures workflow failing with error on step "Archive Demantra Plan". While enabling the apcc log, see if it failing with error.

All the APCC profile options have been set
The workflow and integration interface being used is seeded with no customization

ERROR
-----------------------
msc_demantra_pkg.archive.exception: ORA-00904: "T"."SDATE": invalid identifier
msc_phub_pkg.populate_details_fn: ORA-00904: "T"."SDATE": invalid identifier




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the workflow Publish DM -APCC Measures
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, data cannot be loaded

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