APP-FND-01050 then APP-FND-00730(删除自动会计类型的解决办法)

纵横四海

The Override Value field is greyed out, or you receive errors when
clicking on the Override Value button on Define Columns Set form.

APP-FND-01050: This flexfield cannot be opened because it has no
displayed segments. Please contact your system administrator.
Modify your flexfield definition to display one or more segments.
This may also be caused by incorrect use of the DISPLAY= token to
the flexfield user exits in the form. In that case, please contact
your support representative.

Click on OK button on Error Window and following message displayed.

APP-FND-00730: This flexfield has an invalid value set. It may use a
special value set that uses an Edit event user exit, and the user
exit has failed. If you are using a form on a graphical user
interface (GUI) you may have an invalid value set of a different
type, possibly a table-validated value set where the table or view
does not exist or where there is an invalid WHERE clause. Contact
your system administrator or support representative to check and
correct the value sets this flexfield uses.

Enter the Override Segment first, then the Override Value.





该贴已经同步到 纵横四海的微博

纵横四海

pplies to: Oracle Receivables - Version: 11.5.9
This problem can occur on any platform.
FORM:RAXSUAGL - Define Automatic Accounting SymptomsYou get the following errors when trying to setup AutoAccounting:

APP-FND-01050 This flexfield cannot be opened because it has no displayed segments. Please contact your system administrator.

Modify your flexfield definition to display one or more segments. This may also be caused by incorrect use of the Display=token to the flexfield user exits in the form. In that case please contact your support representative.
.
When clicked on OK, it further throws the following error message:
APP-FND-00730: This flexfield has an invalid value set

Example:
You are able to define AutoAccounting in one ORG and not in another.
You are able to define other AutoAccounting accounts but not Freight.
The Freight account record appears to have been saved with no account segments.
You have defined segments for location flexfield but in vain.
CauseThe issue here could be that at some point probably the record in RA_ACCOUNT_DEFAULTS_ALL was saved, without saving the associated records in RA_ACCOUNT_DEFAULT_SEGMENTS.

SolutionRun the following sqls:

-- check for the available orgs
select organization_id, name from HR_ORGANIZATION_UNITS;

-- check the details with combination of gl_default_id and type for the particular org
select gl_default_id, type, org_id from RA_ACCOUNT_DEFAULTS_ALL;

-- check for the segments, if the necessary and defined values are available or not.
select rad.type, rads.segment, rads.table_name
from RA_ACCOUNT_DEFAULT_SEGMENTS rads,
RA_ACCOUNT_DEFAULTS_ALL rad
where rads.gl_default_id = rad.gl_default_id
and rad.org_id = &org_id;

You need to provide the org_id, in which the error occurs. From the output of the above query, check if the necessary segments are returned, for the corrupt account type. If the values are missing, then it implies that, for the record in the table RA_ACCOUNT_DEFAULTS_ALL, there are no corresponding entries in the table RA_ACCOUNT_DEFAULT_SEGMENTS_ALL. Hence, the suggested option is to delete the associated record from the table RA_ACCOUNT_DEFAULTS_ALL after taking a backup of the same.

Example:
create table ra_account_defaults_all_bak as
select * from ra_account_defaults_all;

delete from ra_account_defaults_all
where gl_default_id = 1015;

commit;
.
Now re-query the account type concerned, in the AutoAccounting form to check if the system allows you to enter. If you still have an issue, kindly log a service request with Oracle Support.

chentong1983

try:
1. Go into the responsibility: System administrator
2. Navigate to Application > Flexfields > Key > Segments > query the Position flexfield, Human Resources application > click on the structure that was set up for your business group
3. Click Segments > set up at least one segment > make sure the Enabled and Displayed check boxes are checked > Save > check the 'Allow dynamic inserts' box > freeze the flexfield definition > compile the flexfield