My Oracle Support Banner

Costed Indented Bill Of Materials Report – Is Completing In Error(ORA-01436, ORA-01722). (Doc ID 2435422.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Reports

When attempting to Costed Indented Bill of Materials Report ,
the following error occurs.

java.sql.SQLException: ORA-01436: CONNECT BY loop in user data,java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

The issue can be reproduced at will with the following steps:
1. Submit Costed Indented Bill of Materials Report




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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