G-Invoicing: When Submitting an SFO or BIO MOD for Approval in the ECC Dashboard Users Are Directed To Error page: 'You have encountered an unexpected error. Please contact your System Administrator for assistance.' (Doc ID 3035821.1)

Last updated on JULY 19, 2024

Applies to:

Symptoms

When a user creates a modification to a Seller Facilitated Order(SFO) or Buyer Initiated order(BIO) users are getting an error page: 'You have encountered an unexpected error. Please contact your System Administrator for assistance.' when submitting the agreement for approval.

diagnostics shows oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

To reproduce the issue,

1. Log into a G-Invoicing responsibility
2. Modify existing order
3. Get the modification approved by the appropriate agency
4. Pull the modified order back to EBS
5. Run the ECC Incremental load
6. Navigate to the Performance Obligation page ('Update')
7. Fill in the necessary information in the line and schedule and apply
8. Update associated agreement
9. Submit the agreement
10. Approve the Agreement
11. Encounter the error page.

Changes

Cause

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