My Oracle Support Banner

Supplemental Data Manager - Even After Deleting Ad-Hoc Forms Data Still Exists (Doc ID 2921851.1)

Last updated on FEBRUARY 03, 2023

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version N/A and later
Information in this document applies to any platform.


Delete Ad hoc data entries made via  Ad hoc forms from Supplemental Data Manager.


Performs below steps expecting that ad hoc data entries made will also be deleted, However data is not deleted as expected


1) Go to Data -> Supplemental Data Analysis -> Choose your POV for the Collection. 

Example:  "PO, 2021, Dec, Actual" - ("PO" is an example for your collection)

You can see there are some rows per your setup

Example: "PO# column has PO numbers."


2) Now go to Supplemental Data -> Go to Form Templates -> Choose Form Template-> Deploy form template -> Select the Data Selection period and Form template to deploy the template.

Example: Dec->FY21->Actual

Example: Form template as "FormTemplate1"

3) Choose Reset all workflows and Delete ad-hoc forms and click OK to deploy.

-> After successful deploy of this rule template, Expecting that the data is also deleted.

But still see the ad hoc entered values are under Data -> Supplemental Data Analysis for Period:Dec , Year:FY21, Scenario:Actual, Collection:ARO.

Also - there is data for another entities that are not even part of my existing ad - hoc forms. You can see that by going to  Tasks -> Supplemental Data Task -> for Collection "Default" and same POV Example:  Year: 2021, Period: Dec, Scenario: Actual, Template: FormTemplate1.
You can see the template has data for only certain entity but when you review the data by going to  Data->Supplemental Data Analysis for the same POV, you can see data exist for some other entities too.

How do we delete the data under Data->Supplemental Data Analysis for example POV: 2021, Dec, Actual, Collection: PO?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.