Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cash Position Data Extraction - error - ORA-12899: value too large for column ??? (actual: 81, maxim

edited Dec 12, 2019 9:11AM in Payables, Payments & Cash Management 1 comment

Content

Hi - we are using 19D (11.13.19.10.0).

We schedule the "Cash Position Data Extraction" to run daily at 11am on PROD. Since 5th Dec it has been erroring, with this in the log file - example for 6th Dec:

Invoking Data Extraction ESS Job...
JDev Implemented Job Running, ID: 1180835
Entering getExtensibleDimensions...
Exiting getExtensibleDimensions...
year:2017,month:11date:6
Start Date2017-12-06
Entering insertStmtHeaders...
Number of statement headers inserted: 20 at: Fri Dec 06 11:00:04 UTC 2019
Number of deleted statement headers inserted: 0 at: Fri Dec 06 11:00:05 UTC 2019
Entering insertStmtLines
Number of statement lines inserted: 277 at: Fri Dec 06 11:00:05 UTC 2019
Number of deleted statement lines inserted: 0 at: Fri Dec 06 11:00:07 UTC 2019
Exiting insertStmtLines...
Exiting insertStmtHeaders...
Entering insertAPPayments...
------------------------------------------------------------------------------------
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!