My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.