My Oracle Support Banner

DME_PUB_XFORM_MAP.populateStaticPackages API Fails with 'ORA-01400: cannot insert NULL into ("CDR"."DME_STATIC_PKGS"."PACKAGE_NAME")' (Doc ID 2710533.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

Oracle Health Sciences Data Management Workbench - Version and later
Information in this document applies to any platform.


On Oracle Health Sciences Data Management Workbench (DMW) version,

After a PL/SQL static package was modified, the DME_PUB_XFORM_MAP.populateStaticPackages API has been invoked for changes to take effect (Doc ID 2288342.1).

This API is failing with the following error:


The issue can be reproduced with the following steps:
1. Update a static package located under "DMW_DOMAIN" > "DMW_UTILS" > "Global" > "GlobalFunctions" Work Area.
2. Install the PL/SQL program in Production Validation Status.
3. Invoke DME_PUB_XFORM_MAP.populateStaticPackages API.


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.