EBS PO 设置采购选项时候报错 Error Defining Purchasing Options

问题 Symptom

当设置采购选项,选择OU的时候,弹出如下错误:

When attempting to define Purchasing Options when trying to call the Operating Unit in this form.the following error occurs:

QQ图片20160322120949.png

The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function:KeyFlexfieldDefinitionFactory.getStructureNumber could not find the structure definition for the flexfield specified by Application = SQLGL, Code = GL# and Structure number = oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[190 ].)

重现步骤 Reproduce

The issue can be reproduced at will with the following steps:

设置一个新的帐套、OU、库存组织

1. Define a new Ledger, Operating Unit, Inventory Organization.

运行“复制系统初始的数据”

2. Run "Replicate Seed Data" Concurrent Request.

定义一个职责,分配帐套和OU

3. Define a Responsibility and assigned the Ledger and Operating Unit. 

定义"GL: 分类账"、"MO: 业务实体"、"MO: 安全配置文件"

4. Define profile options GL: Ledger, MO: Operating Unit and MO: Security Profiles.

定义财务选项

5. Define Financial Options

解决方法 Solution

根据下面的SQL,找到对应的COA弹性域:

Identify  the flex structure, the following query can be used  i.e :

SELECT  FSP.set_of_books_id,
       GLS.currency_code,
       COAFS.id_flex_structure_code coa_structure_code
 FROM financials_system_params_all FSP,
     gl_sets_of_books GLS,
     fnd_id_flex_structures COAFS
 WHERE FSP.org_id= :1 --输入你查询的OU的org id。input the org id you query
 AND FSP.set_of_books_id = GLS.set_of_books_id
 AND COAFS.id_flex_num = GLS.chart_of_accounts_id
 AND COAFS.application_id = 101 /** SQLGL **/
 AND COAFS.id_flex_code = 'GL#'

重新编译此弹性域,检查是否编译成功(看请求)  

Recompile the Flexfield,  review the compile is successful.

通过以下方式清除高速缓存:

Clear the cache using Functional Adminstrator Responsibility:

功能管理员-核心服务-缓存-全局设置-清除全部缓存

Functional Adminstrator ->core services ->caching framework ->global configuration ->clear all cache

重新检查是否可以成功设置了。

Re-test and save successfully the Purchasing Options Setup needed.

补充一些可能性

  • COA弹性域维护的时候,段值必须是1、2、3、4这样的,如果维护成10、20、30,则必然会出现此类错误。

  • 没有运行 "复制系统初始的数据"



参考资料:Doc ID 1368290.1

本文标题:EBS PO 设置采购选项时候报错 Error Defining Purchasing Options

本文链接:https://catonisland.cn/post/181.html

本文版权归作者所有,欢迎转载,转载请以文字链接的形式注明文章出处。

相关文章