Running Data_Retention_Pkg.Prune_Access_Request gets ORA-01722: invalid number in RSA Identity Management and Governance
Originally Published: 2016-12-05
Article Number
Applies To
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1P15
Issue
Error starting at line : 2 in command -
EXECUTE Data_Retention_Pkg.Prune_Access_Request(SYSDATE-90)
Error report -
ORA-01722: invalid number
ORA-06512: at "AVUSER.DATA_RETENTION_PKG", line 59
ORA-06512: at line 1
01722. 00000 - "invalid number"
*Cause: The specified number was invalid.
*Action: Specify a valid number.Cause
Resolution
Workaround
Related Articles
RADIUS Authentication failure in RSA SecurID Access - Request did not parse properly Number of Views Request forms for adding user access allow the selection of entitlements already granted indirectly in RSA Identity Govern… Number of Views ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle Number of Views Authentication Manager Log Messages (13001-13008) Number of Views SecurID: Unable to request Certificate for a Check Point Firewall through PKCS10 request in RSA Certificate Manager Number of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 RSA MFA Agent 2.4.3 for Microsoft Windows Group Policy Object Template Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.4.3 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
