PA_PRC: Transaction Import completed with error

最新推荐文章于 2021-10-16 09:05:50 发布

congbiaoyu4736

最新推荐文章于 2021-10-16 09:05:50 发布

阅读量201

点赞数

不知道是我的输入法有问题还是怎回事，用汉语输入法老打错字，本人实在受不了看到错别字，所以每次汉字出来又得二次改动，不胜麻烦，所以暂且用英语写了，望有缘看到文档的筒子们见谅，并非故意卖弄可怜巴巴的英文。

此外，发现很奇怪的文题，文字不能改字体什么的，打算插个图也总报错，可能是公司网络不允许吧。

Issue Description: PRC: Transaction Import program completed with error.

Error Message Details:

After set the profile PA: Debug Mode as Yes at User level, the error message is:

MSG-20003: ORA-20003: import1_prog:ORA-01403: no data foundIn OTHERS exception of import1
ORA-06512: at "APPS.PA_TRX_IMPORT", line 9830

02:04:37: ValidateItem: log_message: Checking for Receiver LE ID
02:04:37: ValidateItem: log_message: In OTHERS of ValidateItem
02:04:37: ValidateItem: log_message: Import1->ValidateItem
02:04:37: ValidateItem: log_message: ORA-01403: no data found
02:04:37: ValidateItem: log_message: Checking for Receiver LE ID
02:04:37: Import1: log_message: In OTHERS exception of import1
02:04:37: Import1: log_message: Inside Upd_PktSts_Fatal
02:04:37: Import1: log_message: Updated 0 packet statuses to T
02:04:37: Import1: log_message: Error in import1 procedure
02:04:37: Import1: log_message: Stage=In OTHERS exception of import1
02:04:37: Import1: log_message: ORA-01403: no data found

Issue Analyse:

We could get the interface id from log file and identify which row went error at the program.

Then check the program code by refering the log file, we could know the program using below logic to get the Receiver OU ID:

select carrying_out_organization_id,org_id
into l_project_organization_id,l_receiver_org_id
from pa_projects_all
where segment1=X_pnum;

But after i filled the project number in above query, there is no row give back. As i double checked, the project not exists in our system. So the program will go to the exception part and get back the exception errors. In addition, as checked in system, there is one similar project number exists.

So the solution should be: Raised a datafix to update the project number to the correct one. Then re-run the PRC: Transaction Import. Test passed in develop instance.

The datafix as below:

**************Datafix*************

--Run the below comment firstly, then mark it and run the next update script.
--Otherwise will get the error message.

/*alter session set current_schema = apps;

begin
mo_global.set_policy_context('S',3138);
end;*/

update pa_transaction_interface_all
   set project_number   = 'HOU437558(Proj Manage)',
       last_update_date = sysdate
where org_id = 3138
   and transaction_source = 'ALLOCATIONS'
   and batch_name = 'ETNL-PJ-09-MAY-14-041913-FeederPI-USe.jrn'
   and project_number = 'HOU437558(PROJ MANAGE)';
--23 rows will be updated