Skip to main content
Question

ORA-06502 numeric or value error on Approve for Cost Accounting


PRODQ
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 445 replies

Is anyone experiencing/know the reason/have a solution for above error when selecting a large number of records to Approve for Cost Accounting, please?

 

Finance user is querying for a month’s worth of transactions (1679 currently); selects all, selects Approval for Cost Accounting/Approve for Cost Accounting

“Error...” pops up (company URL xx’d)

 

ProjectTransactions/List (server error)

Database error occurred. Contact administrator.

Error details: [{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error"}]

Request Id: e89543f5-19ba-40bf-b3fc-103873e62a36

Url:

main/ifsapplications/projection/v1/ProjectTransactionsHandling.svc/UpdateApprovalForCostAccounting

 

Any suggestions gratefully received! 

 

Thanks

Linda

2 replies

Alperen
Sidekick (Partner)
Forum|alt.badge.img+5
  • Sidekick (Partner)
  • 35 replies
  • January 29, 2025
Hello,Can you send the entire error section using the copy option?All API operations that return errors are located in that area. A faster control can be achieved.

PRODQ
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 445 replies
  • January 31, 2025
Alperen wrote:
Hello,Can you send the entire error section using the copy option?All API operations that return errors are located in that area. A faster control can be achieved.

This was all - obviously with our application URL.

 

ProjectTransactions/List (server error)

Database error occurred. Contact administrator.

Error details: [{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error"}]

Request Id: e89543f5-19ba-40bf-b3fc-103873e62a36

Url:

main/ifsapplications/projection/v1/ProjectTransactionsHandling.svc/UpdateApprovalForCostAccounting

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings