GRC CCG Configuration of Metabuilder 551 on 11g database

             Configuration of Metabuilder 551 on 11g database


Configuration on Windows
Requirement: Oracle forms 10.1.2 on windows

1. Extract the downloaded CCG_551_metabuilder.zip file in ‘C’ drive
Ex: C:\CCG_551_metabuilder

2. Take the back up of existing tnsnames.ora.
i. Copy the ccg_schema’s tns-name from ccg instance
ii. Paste it in forms repository,  Loc: <forms_repository>\NETWORK\ADMIN

3. Take the back up of default.env and add the below text.
Loc: <oas_repository>/forms/server/default.env
i. Add the value for ORACLE_HOME = <oas_repository/forms>
Ex: ORACLE_HOME=C:\DevSuiteHome_1
ii.  Add FORMS_PATH = <metabuilder_repository>\mb_ui
      Ex: FORMS_PATH=D:\DevSuiteHome_1\forms; C:\ CCG_551_metabuilder\mb_ui

4. Take the back up of registry.dat and add the below text.
Loc: <forms_repository>/forms/java/oracle/forms/registry/registry.dat

i. Add the value default.icons.iconpath=
ii. Add the value default.icons.iconextension=gif

5. Take the back up of existing formsweb.cfg and add the below text at the end of page.
       Loc: <forms_repository>\forms\server\formsweb.cfg
      Ex: D:\DevSuiteHome_1\forms\server\formsweb.cfg
-----------------------------
[metabuilder]
form=metabuilder.fmx
otherparams=param_dbinstance=orcl param_gwyuid=amhome/amhome
separateFrame=True
lookandfeel=Oracle
logo=amwind
pageTitle=Oracle Metabuilder 5.5.1
webUtilArchive=/forms/java/frmwebutil.jar,/forms/java/jacob.jar
archive_jini=frmall_jinit.jar,ico.jar
imagebase=codebase
---------------------------------

Edit this line(3rd) from above:
otherparams=param_dbinstance=<Sid> param_gwyuid=<ccg_home username>/<ccg_home pwd>

6. Copy the ico.jar from CCG_551_metabuilder /mb_ui/java directory to <forms_repository>/forms/java

7. Run the startinst.bat to start the application instance. Need to run every time when the Metabuilder starts.
    Loc: D:\DevSuiteHome_1\j2ee\DevSuite\startinst.bat

8. Open the Internet Explorer (IE) and type the below URL:
URL like http://myhost.mydomain.com/forms/frmservlet?config=metabuilder

Ex: http://127.0.0.1:8889/forms/frmservlet?config=metabuilder
Ex: http://abulle-lap:8889/forms/frmservlet?config=metabuilder


coming issue

# System parameter: default base HTML file
baseHTML=basejpi.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejpi.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files


add the TNS Entry all

LISTENER_A2GRCDB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.05.96)(PORT = 1908))
 )
)

FINDEV=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=cpnqmedaotzp15.)(PORT=1522))
            (CONNECT_DATA=
                (SERVICE_NAME=FINDEV)
                (INSTANCE_NAME=FINDEV)
            )
        )
A2GRCDB=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =10.0.45)(PORT = 1908)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =A2GRCDB)))
ADR_BASE = /oracle_home/app
ADR_BASE_LISTENER_A2GRCDB = /oracle_home/app

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