AR或者OM出现Please Define Sales Representatives解决方法

ARXSUDRC Receipt Classes Errors With APP-AR-96994: Please Define Sales Representatives [ID 357454.1]
	Modified 24-JAN-2009     Type PROBLEM     Status PUBLISHED

Checked for relevance on 25-Jan-2009

In this Document
  Symptoms
  Changes
  Cause
  Solution

---

Applies to:

Oracle Receivables - Version: 11.5.10
This problem can occur on any platform.
FORM:ARXSUDRC.FMB - Define Receipt Classes and Payment Methods

Symptoms

On 11.5.10 in Production:
Trying to setup new Receipt Classes and getting an error when trying to open the form. The transactions workbench also will not open. This is for a new organization just created.

ERROR
NO_DATA_FOUND
APP-AR-96994: Please define sales representatives.
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-20002.

STEPS
The issue can be reproduced at will with the following steps:
1. Setup->Receipt-> Receipt Classes

Changes

The organization has just been created

Cause

The issue is caused by the following setup: replicate seed data has not been run for the new org
so the salesrep does not exist for the new org.

Solution

To implement the solution, please execute the following steps:

1. Confirm that the org_id does not exist in the salesrep tables.

select org_id,salesrep_id
from ra_salesreps_all; 

Select org_id,salesrep_id
from JTF_RS_SALESREPS;

2. If the org_id for the newly created organization is not displayed in the results, then log on as system administrator and run the replicate seed data program for the new organization.

3. Please retest the issue.

4. If the issue is resolved, please migrate the solution as appropriate to other environments.

---

 

 Related

---

Products

---

·   Oracle E-Business Suite > Financial Management > Credit to Cash > Oracle Receivables