ITPub博客

首页 > 数字化转型 > ERP > Get error while update the PA_TRANSACTION_INTERFACE_ALL table

Get error while update the PA_TRANSACTION_INTERFACE_ALL table

原创 ERP 作者:仗剑浪迹天涯 时间:2014-05-19 15:28:53 0 删除 编辑

As some data error, i am going to update the Project Number filed on PA_TRANSACTION_INTERFACE_ALL Table. But once i applied the SQL, there will appear the error message:

MSG-20003: ORA-20003: import1_prog:
ORA-
28115: policy with check option violation
ORA-
06512: at "APPS.PA_TRANSACTION_INTERFACE_T3", line 99
ORA-
04088: error during execution of trigger 'APPS.PA_TRANSACTION_INTERFACE_T3'
ORA-
06512: at "APPS.PA_TRX_IMPORT", line 9368

Metalink refer docs:

--Transaction Import Error MSG-20003: ORA-20003: import1_prog:ORA-28115: policy with check option violation (Doc ID 1618365.1)

--PA_TRANSACTION_INTERFACE_ALL - How to Resolve ORA-28115:Policy with check violation (Doc ID 1492752.1)

Solution is adding one script before run the update SQL:

/*alter session set current_schema = apps;
begin
mo_global.set_policy_context('S',3138);
end;*/

After execute above SQL, then re-run the update SQL,there will no error and data modified successfully.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26225838/viewspace-1164324/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-05-16

  • 博文量
    3
  • 访问量
    17598