导入标准采购订单提示例程 fdpsql 无法读文件 ***/po/12.0.0/sql/PO_PDOI_GRP.start_process

请检查文件是否位于正确的产品目录下。

请检查启动并发管理器的人员是否拥有此目录和文件的读权限

在运行并发请求  requestid 的 SQL*Plus 时，并发管理器出现错误。

有关详情，请复查您的并发请求日志和（或）报表输出文件。

Import Standard Purchase Orders Error cannot read the file PO_PDOI_GRP.start_process issue.

Our programs failing with below error, You may check the concurrent request logs, Will see the error as below.

Concurrent Request logs:- You can check the concurrent request logs using request id.

Routine fdpsql cannot read the file po/12.0.0/sql/PO_PDOI_GRP.start_process

Import standard purchase orders:-

1)  Verify the executable method in the below PDOI concurrent programs:

 

2)  Check whether the attribute 'MULTI_ORG_CATEGORY' is set to 'S' in all the below concurrent programs:

 

3)  Test and run the program import standard purchase orders. Program will get completed successfully and should not get any error

或者使用以下SQL更新

Update fnd_concurrent_programs

set multi_org_category = 'S'

where concurrent_program_name='POXPOPDOI';

Verify the executable method in the below PDOI concurrent programs:

Import Standard Purchase Orders.

Import Price Catalogs.

Import Contract Purchase Agreements.

 Steps:

     1. Navigate to System Administrator -> Concurrent -> Program -> Define

     2. Query for the program for example 'Import Standard Purchas Orders'.

     3. Check the Executable method defined for the program. If it is 'SQL*Plus' then select the LOV beside Executable POXPDOI' and  reselect the executable as 'POXPDOI'.

     4. Confirm that the executable method has been changed as 'PL/SQL Procedure'.

     5. Do the same for the other programs.