My Oracle Support Banner

Error Trying To Create SWOT On Partner Business Plan (Doc ID 2318103.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Partner Management

When attempting to Create a SWOT analysis,
the following error occurs.

ORA-20001: The process has encountered a SQL error. Details: SQL error message -1422 and get_seq_info and ORA-01422:
exact fetch returns more than requested number of rows and AFSQNUMB.pls and select SEQ.DOC_SEQUENCE_ID, SEQ.TYPE, SEQ.NAME ...
ORA-06512:at "FUSION.APP_EXCEPTION", line ORA-06512: at "FUSION.FND_SEQNUM", line 831

The issue can be reproduced at will with the following steps:
1. Open a partner
2. Click on Business Plans
3. Create a Business Plan
4. Enter required fields then click Save and Continue
5. Click on SWOT tab
6. Click button to add strength or weakness. Error is received.

The issue has the following business impact:
Due to this issue, users cannot .


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

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