POMULMOD: Create Multiple Modifications Has Issues With Document Numbering For Concurrent And Multi-mods

(Doc ID 2243841.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When adding additional usages to support modification numbering for
mult-modifications/novations the functionality for concurrent modifications
no longer works. We are using the seeded modification numbering but have
custom Order numbering (so we have an additional usage for Document Numbering
Yes/No).

When we remove the additional usage to support multi-mod/novation
then the concurrent modification numbering works.

We need the functionality for both multi-mod and concurrent mods to work on
the same document numbering attribute group template.


ERRORS

----------

POMULMOD: Create Multiple Modifications

---except ---
Mod creation failed for documentId: 17110 .Rolling back to Savepoint
Updating po_multi_mod_docs table with Status and CP Request Id
Updating po_multi_mod_requests table with Completed Status and CP Request Id
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
po.plsql.PO_MULTI_MOD_PVT.CREATE_MODIFICATION.0: Entered create_modification
for po_header_id: 17099
po.plsql.PO_MULTI_MOD_PVT.CREATE_MODIFICATION.20: Create draft record for Mod
po.plsql.PO_MULTI_MOD_PVT.CREATE_DRAFT_FROM_TXN.10: Create row in PO_DRAFTS
for the new Mod
po.plsql.PO_MULTI_MOD_PVT.CREATE_DRAFT_FROM_TXN.30: Create row into
PO_HEADERS_DRAFT_ALL for the new Mod
po.plsql.PO_MULTI_MOD_PVT.CREATE_MODIFICATION.30: Default Mod fields and
merge fields from the Multi-Mod request
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.20: Copy Header UDA
Attributes from Base document to Mod
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.30: Copy Multi-Mod
Specific UDA Attributes to Mod
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.40: Default Document
Number for the Mod
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.40: An exception was
encountered in PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.40: ERROR : User-Defined
Exception
po.plsql.PO_MULTI_MOD_PVT.CREATE_MODIFICATION.30: ERROR : User-Defined
Exception
...
po.plsql.PO_MULTI_MOD_PVT.DEFAULT_AND_MERGE_MOD_DATA.40: An exception was
encountered in PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER

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