Getting 'ORA-06502: PL/SQL: numeric or value error in Package create_subline_line Procedure OKS_IMPORT_SUBLINE_PUB' Error
(Doc ID 2901289.1)
Last updated on OCTOBER 06, 2022
Applies to:Oracle Service Contracts - Version 12.2 and later
Information in this document applies to any platform.
After applying a patch, when creating a Sublines via the APIs, all Sublines (LSE_ID = 13) are missing for all the Usage lines (LSE_ID = 12), The following error occurs when running the API.
ORA-06502: PL/SQL: numeric or value error in Package create_subline_line Procedure OKS_IMPORT_SUBLINE_PUB
1. Use the API OKS_IMPORT_SUBLINE_PUB to create a subline for a Usage line
2. Get the indicated error and the subline is not added to the Usage line.
Applied patch 34393008:R12.OKS.C but other patches might cause the issue as well.
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