My Oracle Support Banner

R12: AP: Payables Invoice And EBTax Analyzer Concurrent Program (APEBTAXAZ) Completes with Errors ORA-06502 and ORA-06512 (Doc ID 2901039.1)

Last updated on MARCH 06, 2024

Applies to:

Oracle Payables - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Payables Invoice and EBTax Analyzer which quickly ended in Error.

Log says: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1

APEBTAXAZ: Payables Invoice And EBTax Analyzer  concurrent program request Log file shows the following

+---------------------------------------------------------------------------+
Payables: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
APEBTAXAZ: Payables Invoice And EBTax Analyzer
+---------------------------------------------------------------------------+
Current system time is 12-SEP-2022 14:02:27
+---------------------------------------------------------------------------+
[12-SEP-2022 14:02:27]: **Starts**
[12-SEP-2022 14:02:27]: **SQL error and free**
[12-SEP-2022 14:02:27]: ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
.
The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Reque
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
Deleting empty output file.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 12-SEP-2022 14:02:27
+---------------------------------------------------------------------------+

Steps to reproduce:

  1. Navigate from the Payables responsibility to Requests > Run
  2. Query the single Request "Payables Invoice and EBTax Analyzer"
  3. Choose the OK button, then the Submit button
  4. Navigate to View > Requests and choose Find
  5. Click on View Output button to open output.
    It shows NO output generated.
  6. Click on View Log button to open the log file.
    It shows as above.

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
Cause
Solution
References


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