Exception ORA-01722: invalid number, When Adding OU Restriction To CLM Document Style. (Doc ID 2878271.1)

Last updated on JUNE 21, 2022

Applies to:

Symptoms

When attempting to add operating unit to CLM document style, the following error occurs.

ERROR

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at line 1
..
at oracle.apps.po.common.server.PoCallableStatement.execute(PoCallableStatement.java:297)
at oracle.apps.po.style.server.DocumentStyleSvrCmd.checkIfTemplateUsagesAreValidOU(DocumentStyleSvrCmd.java:2212)
at oracle.apps.po.style.server.DocumentStyleSvrCmd.validateOperatingUnit(DocumentStyleSvrCmd.java:2103)
at oracle.apps.po.style.server.DocumentStyleSvrCmd.validateCurrentDocumentStyle(DocumentStyleSvrCmd.java:2056)
at oracle.apps.po.style.server.DocumentStyleSvrCmd.saveCurrentDocumentStyle(DocumentStyleSvrCmd.java:988)
at oracle.apps.po.style.server.DocumentStyleSvrCmd.execute(DocumentStyleSvrCmd.java:255)
at oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:144)
..
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.style.webui.StyleEditCO.processFormRequest(StyleEditCO.java:563)
..



STEPS

1. Navigate to CLM Purchasing Super User responsibility -> Setup -> Purchasing -> Document Styles.
2. Click on update icon corresponding to document style name xxxxx_AWARD.
3. From the Update Document Style page, select Operating Unit from the List of Values and click on Apply.
4. Reported error occurs.

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.