Problem
Following Error Occur when open a purchasing form
Solution
1. Connect apps user and run below query.
2. Run below script via apps user
3. Verify the issue by running following query.
Reference :
Choosing Approval Assignments Form From Menu - Nothing Happens - Form Does Not Open (Doc ID 1063223.1)
Following Error Occur when open a purchasing form
Solution
1. Connect apps user and run below query.
select object_name,policy_name, package,function,enable
from sys.all_policies
where object_name = upper('PO_DOCUMENT_TYPES_B')
union
select object_name,policy_name, package,function,enable
from sys.all_policies
where object_name = upper('PO_DOCUMENT_TYPES_TL')
union
select object_name,policy_name, package,function,enable
from sys.all_policies
where object_name = upper('PO_SYSTEM_PARAMETERS')
union
select object_name,policy_name, package,function,enable
from sys.all_policies
where object_name = upper('FINANCIALS_SYSTEM_PARAMETERS');
If query does not return above four policies, then add those2. Run below script via apps user
SQL>revoke EXEMPT ACCESS POLICY from APPS;
3. Verify the issue by running following query.
select count(*) from po_document_types;If above query return 0 rows, then issue will be resolved
Reference :
Choosing Approval Assignments Form From Menu - Nothing Happens - Form Does Not Open (Doc ID 1063223.1)
No comments:
Post a Comment