GRC CCG

GRC and ERP Intigration


CCG: How to Reset the Configure & Remove button for CCG and Agent component (Doc ID 789482.1)

select t.target_id,t.target_name,v.attribute_type,v.attribute_value,
NVL(p.displayed_name,'Platform') product,
v.product_id
from
am_targets T,
AM_PRODUCT_ATTRIBUTE_VALUES V,
am_products p
where v.attribute_type in ('PRODUCT_STATUS','ENABLED_FLAG')
and t.target_name = 'FINDEV'
and v.target_id = t.target_id
and p.product_id(+)=v.product_id
order by 1


UPDATE
 am_product_attribute_values
SET attribute_value = 'C'
WHERE
target_id = 100
  and product_id in (1,-1)
  and attribute_type ='PRODUCT_STATUS';

UPDATE
am_product_attribute_values
SET attribute_value = 'N'
WHERE
target_id = 100
and product_id in (-1)
and attribute_type ='PRODUCT_STATUS';


FINDEV_AM_AGENT_LINK
FINDEV_ERP_LINK


SQL> select OWNER,DB_LINK,USERNAME from all_db_links;

OWNER                   DB_LINK                                                                USERNAME
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------
AMHOME                   FINDEV_ERP_LINK                                                            APPS
AMHOME                   FINDEV_AM_AGENT_LINK                                                        AM_AGENT_007

SQL>

drop database link FINDEV_ERP_LINK;
drop database link FINDEV_AM_AGENT_LINK;


Errors in file /oracle_home/app/diag/rdbms/a2grcdb/A2GRCDB/trace/A2GRCDB_j000_1832.trc:
ORA-12012: error on auto execute of job 692
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "AMHOME.AM_PLSQLUTIL_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AMHOME.AM_PLSQLUTIL_PKG"
ORA-06512: at "AMHOME.AM_ATTRIBUTES_PKG", line 191
ORA-06512: at "AMHOME.AMDPLY_PKG", line 876
ORA-04065: not executed, altered or dropped stored procedure "AMHOME.AM_PLSQLUTIL_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AMHOME.AM_PLSQLUTIL_PKG"
ORA-06512:



exec apsdply_pkg.deploy_apps(692);



SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS FROM ALL_OBJECTS WHERE OBJECT_NAME IN ('AM_PLSQLUTIL_PKG','AM_LOV_PKG');


Compile Objects