ORA-20001,APP-FND-01728

ORA-20001: APP-FND-01728: An Assignment does not exist for these parameters [ID 556269.1]

Applies to:

Oracle Order Management - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5 to 11.5
Information in this document applies to any platform.
***Checked for relevance on 31-OCT-2011***

Symptoms

On 11.5.10.2 in Production:
When attempting to create new order transaction type the following error occurs.

ORA-20001: APP-FND-01728: An Assignment does not exist for these parameters

STEPS
The issue can be reproduced at will with the following steps:
1. Create a new Transaction Type:
         Order Management > Setup > Transaction Type > Define
2. Create a new sequence. OM > Setup> Documents >Define
3. Make sure the category exists (same name as order transaction type) OM>setup>Docs>Categories
4. Assign the sequence to category. OM > Setup> Documents >Assign
5. Use the category in a new sales order


Due to this issue, users cannot assign new order numbers for the new order type

Cause

 The 'Sequence Assignment' operation was done specifying a Set of Books which did not relate to the Operating Unit which was automatically in force (because of the Responsibility selected) when the Document Type was created.

Solution

You can use the following SQL*Plus query (run as the 'APPS' username) to verify which Set of Books should have been used when assigning the Sequence:
First, navigate to 'Order Management > Setup > Transaction Types > Define', and query the relevant Transaction Type.
Use 'Help > Diagnostics > Examine' to establish the value of ORG_ID.
Then navigate to 'Order Management > Setup > Documents > Assign' and query for the Category which has the same name as the above Transaction Type.
Use 'Help > Diagnostics > Examine' to establish the value(s) of SET_OF_BOOKS_ID used to link Document Sequences to this Category

Then run :

select p.org_id, p.set_of_books_id, s.name
from ar_system_parameters_all p, gl_sets_of_books s
where p.set_of_books_id = s.set_of_books_id
  and org_id = &Org_ID_established_above;

If the Set of Books returned by the above script is not one of the ones which appear in the Sequence Assignment form, then that Assignment can not be seen from the Operating Unit which you are using.