Oracle Purchasing "Blanket Release Approved" or "Standard Purchase Order Approved" Notification Has ORA-20002: 3835: Error '-6502 - ORA-06502: PL/SQL: numeric or value error' Error
(Doc ID 2865736.1)
Last updated on APRIL 22, 2024
Applies to:
Oracle Purchasing - Version 12.2.6 and laterOracle Workflow - Version 12.2.6 and later
Information in this document applies to any platform.
Symptoms
When attempting to approve purchasing documents (primarily Standard Purchase Orders and Blanket Releases) the error below occurs for notifications generated during the approval process
for event 'oracle.apps.wf.notification.send'.ORA-06512: at "APPS.WF_EVENT", line 2250 ORA-06512: at "APPS.WF_EVENT", line 821 ORA-06512: at "APPS.WF_EVENT",
line 666 ORA-06512: at "APPS.WF_CORE", line 318 ORA-06512: at "APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_EVENT", line 161 ORA-06512: at "APPS.WF_EVENT",
line 646 ORA-06512: at "APPS.WF_EVENT", line 2144
STEPS TO REPRODUCE
1. Open Purchasing responsibility
2. Navigate to Buyer Work Center > Orders page OR open Purchase Orders > Purchase Orders form OR open Release form
3. Enter data to create document and save.
4. Click Approve to submit Purchase Order or Blanket Release for approval
5. If required approvers open approval workflow notifications and use approve option to approve the document
6. Standard Purchase Order or Blanket Release Approval results in error after the document is approved
7. The error is related to "Blanket Release RELEASE-NUM has been approved" notification or "Standard Purchase Order NNNN has been approved" notification and will have error status with the above error stack
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |