Monday 25 January 2016

Oracle Treasury Tables in oracle apps

XTR_A_BANK_ACCOUNTS           

XTR_A_BANK_BALANCES             Created by ORACLE on 17-DEC-93

XTR_A_BANK_SETTLEMENT_CODES     Created on 21-SEP-94

XTR_A_BOND_ISSUES             

XTR_A_BUY_SELL_COMBINATIONS    

XTR_A_COMPANY_LIMITS            

XTR_A_COMPANY_PARAMETERS        This table is used to audit Xtr_Company_Parameters

XTR_A_COUNTERPARTY_LIMITS      

XTR_A_DEAL_DATE_AMOUNTS         

XTR_A_DEAL_ORDERS               Created from Entity XTR DEALS by ORACLE on 28-NOV-94

XTR_A_DEALER_CODES              Created by ORACLE on 06-MAY-95

XTR_A_DEALER_LIMITS             Created by ORACLE on 25-JUL-96

XTR_A_DEALS                     Created from Entity XTR DEAL by ORACLE on 06-MAY-93

XTR_A_EXPOSURE_TRANSACTIONS   


XTR_A_EXPOSURE_TYPES           
XTR_A_FUTURES                   Created from Entity XTR FUTURES by ORACLE on 16-JUN-95

XTR_A_FUTURES_FEES             

XTR_A_FUTURES_MARGIN_DETAILS    

XTR_A_GL_REFERENCES            

XTR_A_INTERGROUP_TRANSFERS      

XTR_A_JOURNAL_ENTRY_ACTIONS    

XTR_A_JOURNALS                 

XTR_A_MASTER_CURRENCIES        

XTR_A_PARTY_DEFAULTS            Created from Entity XTR PARTY by ORACLE

XTR_A_PARTY_INFO                Created from Entity XTR PARTY by ORACLE on 06-MAY-93

XTR_A_PORTFOLIOS               

XTR_A_PRO_PARAM                 Created by ORACLE on 20-FEB-95

XTR_A_PRODUCT_TYPES           

XTR_A_RATE_SETS                 Created on 01-FEB-95

XTR_A_REVALUATION_DETAILS       Created on 01-FEB-95

XTR_A_REVALUATION_RATES         Created on 01-FEB-95

XTR_A_ROLLOVER_TRANSACTIONS  

XTR_A_SETTLEMENT_CATEGORIES     Created on 27-JAN-95

XTR_A_STANDING_INSTRUCTIONS     Created on 27-JAN-95

XTR_A_TAX_BROKERAGE_RATES       Created by ORACLE on 13-MAR-95

XTR_A_TAX_BROKERAGE_SETUP       Created on 27-JAN-95

XTR_A_TAX_CATEGORIES            Created on 27-JAN-95

XTR_ACCEPTED_BIDS               Created by ORACLE on 13-SEP-95

XTR_ACCOUNT_DEBIT_AUTHS             Created by ORACLE on 14-FEB-97

XTR_ACCRLS_AMORT                    Accrual amounts for deal transactions

XTR_ACCRUAL_AMORTISE_SETUP         

XTR_AMOUNT_ACTIONS          Amount action information

XTR_AMOUNT_TYPES            Amount type information

XTR_ARCHIVE_DETAILS         Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_ERROR_LOG       Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_HISTORY         Created by ORACLE on 02-JUN-95

XTR_ARCHIVE_SETUP           Created by ORACLE on 02-JUN-95

XTR_AUDIT_COLUMNS           Created by ORACLE on 27-MAY-96

XTR_AUDIT_GROUPS     

XTR_AUDIT_MODULE_ACCESS             Created by ORACLE on 06-MAR-97

XTR_AUDIT_SUMMARY                 

XTR_AUTH_CCY_COMBINATIONS         

XTR_AUTH_TYPE_SUBTYPE_PROD        

XTR_AVG_RATES_RESULTS     

XTR_BANK_ACCOUNTS                   Bank account information

XTR_BANK_BAL_INTERFACE           

XTR_BANK_BALANCES                   Daily bank balance information

XTR_BATCH_EVENTS                   

XTR_BATCHES                        

XTR_BIDS_RECD                       Created on 23-NOV-94

XTR_BILL_BOND_ISSUES               

XTR_BOND_ALLOC_DETAILS              For realized gain/loss from bond resale

XTR_BOND_COUPON_DATES               Coupon dates for bond issues

XTR_BOND_ISSUES                     Bond issues information

XTR_BROKERAGE_CATEGORIES           

XTR_BUY_SELL_COMBINATIONS            Buy and sell currency combination information

XTR_CALL_DETAILS                    

XTR_CASHPOOL_ATTRIBUTES            

XTR_CFLOW_REQUEST_DETAILS            Update Settlement Accounts Request Details.

XTR_CFLOW_UPDATED_RECORDS          

XTR_COMPANY_AUTHORITIES             User access authorities of companies

XTR_COMPANY_LIMITS                 

XTR_COMPANY_PARAMETERS             

XTR_CONFIRMATION_ACTIONS           

XTR_CONFIRMATION_DETAILS            Confirmation letter details

XTR_CONFIRMATION_SETUP              Created by ORACLE on 06-JUL-96

XTR_COST_OF_FUNDS                  

XTR_COUNTERPARTY_LIMITS            

XTR_COUNTRY_COMPANY_LIMITS         

XTR_CUM_DIST_CALCS                  Created on 03-DEC-93

XTR_CURRENCY_CROSS_RATES           

XTR_DATA_FEED_CODES                 Created by ORACLE on 30-MAY-96

XTR_DATE_AMOUNT_TYPES             

XTR_DATE_TYPES                      Date types information

XTR_DDE_FEED_LOCKS                   Created by ORACLE on 20-NOV-96

XTR_DEAL_CONFO_TYPES               Deal confirmation types used in confirmation letter templates

XTR_DEAL_CONTACTS                  Created on 28-MAR-96

XTR_DEAL_DATE_AMOUNTS           

XTR_DEAL_LINKING     

XTR_DEAL_ORDERS                     Created from Entity XTR DEALS by ORACLE on 28-NOV-94

XTR_DEAL_OVERWRITE_TYPES           

XTR_DEAL_RETRO_TESTS               

XTR_DEAL_STATUSES                   Deal status information

XTR_DEAL_SUBTYPES                   Deal subtype information

XTR_DEAL_TYPES                      Deal type information

XTR_DEALER_CODES                    Treasury users information

XTR_DEALER_LIMITS                   Dealer limits information including limit amounts

XTR_DEALS                         

XTR_DEALS_INTERFACE              

XTR_DEDUCTION_CALCS             

XTR_EXPOSURE_SUMMARY                Created by ORACLE on 21-OCT-96

XTR_EXPOSURE_TRANSACTIONS          

XTR_EXPOSURE_TYPES                  Exposure type information

XTR_EXT_IMPORT_INTERFACE           

XTR_EXTERNAL_CASHFLOWS              Not currently used

XTR_FORECAST_PERIOD_TEMP     

XTR_FORECAST_PERIODS                Not currently used

XTR_FUTURES                         Created from Entity XTR FUTURES by ORACLE on 16-JUN-95

XTR_FUTURES_FEES                   

XTR_FUTURES_MARGIN_DETAILS         

XTR_FX_MULTIPLE_CONTRACTS          

XTR_FX_PERIOD_WEIGHTINGS            Limit weightings information

XTR_FX_ROLL_PRE_DETAILS             Created by ORACLE on 15-SEP-95

XTR_FX_ROLL_PRE_ITERATIONS          Created by ORACLE on 15-SEP-95

XTR_FX_WHAT_IFS                     Created by ORACLE on 01-MAY-97

XTR_GAIN_LOSS_DNM                  

XTR_GENERAL_LEDGER_SUMMARY          Created by ORACLE on 28-JUN-96

XTR_GL_BY_PARTY                     Created by ORACLE on 06-MAY-97


XTR_GL_REFERENCES                 

XTR_GROUP_LIMITS                   

XTR_HEDGE_ATTRIBUTES              

XTR_HEDGE_CRITERIA                 

XTR_HEDGE_ITEMS_TEMP               

XTR_HEDGE_JOURNAL_ACTIONS          

XTR_HEDGE_POLICIES                 

XTR_HEDGE_PRO_TESTS                 Stores the hedge prospective effectiveness test results.

XTR_HEDGE_RELATIONSHIPS             This table stores hedge relationship information

XTR_HEDGE_RETRO_TESTS               Stores hedge level retrospective effectiveness test and measurement details.

XTR_HEDGE_STRATEGIES                This table stores key reporting, or financial disclosure, information that is common to all the
                                    Hedges designated within that Strategy.

XTR_HOLIDAY_RULES                   Holiday rules defined for different currencies

XTR_HOLIDAYS                        Holidays defined for different currencies

XTR_IG_JOURNAL_STRUCTURES          

XTR_IMPORT_TRAILER_DETAILS        

XTR_IMPORT_TRANSFER_ERRORS        

XTR_INTERACCT_TRANSFERS            

XTR_INTEREST_PERIOD_RATES          

XTR_INTEREST_RATE_AVERAGES          Created by ORACLE on 05-DEC-94

XTR_INTEREST_RATE_BANDS             Interest rate band details for different interest rate policies

XTR_INTEREST_RATE_EXP_PER           Created by ORACLE

XTR_INTEREST_RATE_EXPOSURE     

XTR_INTEREST_RATE_POLICY      

XTR_INTEREST_RATE_RANGES       

XTR_INTEREST_TOLERANCES        

XTR_INTERFACE_ERRORS           

XTR_INTERGROUP_TRANSFERS        Intercompany loans or deposits information

XTR_INTRA_DAY_LIMITS            Created by ORACLE on 07-AUG-96

XTR_IRE_MATURITY_BY_POLICY      Created by ORACLE on 12-JUN-97

XTR_IRS_ACTUALS                 Created by ORACLE on 22-MAY-97

XTR_ITEM_RELEASE_DETAILS     

XTR_JEA_DUPLICATE              

XTR_JOURNAL_ENTRY_ACTIONS      

XTR_JOURNALS                    Detailed journal entry information

XTR_LAYOUT_RESULTS            

XTR_LAYOUT_TEMPLATE             Confirmation letter template information

XTR_LAYOUT_TEMPLATE_LINE        Confirmation template lines

XTR_LAYOUT_VALUES               Common variables for the confirmation templates

XTR_LAYOUT_VIEW_FX_CONFO         Created by ORACLE on 6 JUL 96

XTR_LAYOUT_WHERE_CLAUSE    
    
XTR_LIMIT_EXCESS_LOG            Limit exceptions caused by deal transactions

XTR_LIMIT_TYPES                 Information on defined limit types

XTR_LIMIT_UTILIZATION_FEE       Created by ORACLE on 22-OCT-97

XTR_LOAN_SECURITIES             Created by ORACLE on 30 October 1995

XTR_MARKET_DATA_INTERFACE      

XTR_MARKET_PRICES               Current rates for foreign exchange and money market deals

XTR_MASTER_CURRENCIES         

XTR_MIRROR_DDA_LIM_ROW_TMP     Created by ORACLE on 17-JUL-96

XTR_MIRROR_DDA_LIMIT_ROW      

XTR_MTS_RECORDS               

XTR_MTS_RECORDS_HISTORY       

XTR_ONE_STEP_SETTLE_CODES     

XTR_PARCEL_SPLITS               Parcel split detail information for discounted securities deals

XTR_PARTY_DEFAULTS              Counterparty default settlement information

XTR_PARTY_GROUPS                Party group information

XTR_PARTY_INFO                  Created from Entity XTR PARTY by ORACLE on 06-MAY-93

XTR_PAY_REC_RECONCILIATION      Information on successfully transferred bank statements

XTR_PAYMENT_SCHEDULE            Payment schedule information for retail term money deals

XTR_PORTFOLIO_DEAL_AMOUNTS     

XTR_PORTFOLIOS                  Company portfolio information

XTR_POSITION_HISTORY           

XTR_PRICE_MODELS             

XTR_PRINTED_FILE_DETAILS     

XTR_PRO_DUAL                     Used within ORACLE for basing forms on without base tables

XTR_PRO_PARAM                   Treasury system parameter settings

XTR_PRODUCT_TYPES               Product type information

XTR_PRT_BODY                    Created by ORACLE on 07-MAR-96

XTR_PRT_HEAD                    Created by ORACLE on 07-MAR-96

XTR_QUICK_INPUT_DEALS          

XTR_QUICK_INPUT_QUOTES          Created by ORACLE on 28-APR-97

XTR_R_BANK_BALANCES             Created by ORACLE on 17-DEC-93

XTR_R_CURRENCY_CROSS_RATES     

XTR_R_DEAL_DATE_AMOUNTS        

XTR_R_DEALS                     Created from Entity XTR DEAL by ORACLE on 06-MAY-93

XTR_R_EXPOSURE_TRANSACTIONS   

XTR_R_INTEREST_PERIOD_RATES    

XTR_R_ROLLOVER_TRANSACTIONS    

XTR_R_SPOT_RATES               

XTR_RATE_GROUPS                 Created from by ORACLE on 07-JUL-96

XTR_RATE_PREFERENCES            Created by ORACLE on 09-JUL-96

XTR_RATE_SETS                   Interest rates for retail term money deals

XTR_RECLASS_DETAILS             Stores reclassified effective unrealized gain/loss amounts.

XTR_RECONCILIATION_PASSES       Reconciliation criteria for bank statement lines
   
XTR_RECONCILIATION_PROCESS      Reconciliation method definitions

XTR_REG_HEDGE_POLICIES         

XTR_REVALUATION_DETAILS        Revaluation results of Treasury deals

XTR_REVALUATION_MARGINS     

XTR_REVALUATION_RATES         

XTR_REVIEW_CURRENCIES     

XTR_REVIEW_TRANSACTIONS         Created on 08-FEB-95

XTR_RM_MD_CURVE_RATES          

XTR_RM_MD_CURVES                Market data curve attributes

XTR_RM_MD_SET_CURVES           

XTR_RM_MD_SETS                  Market data set attributes

XTR_ROLLOVER_TRANSACTIONS   

XTR_SETTLEMENT_CATEGORIES    

XTR_SETTLEMENT_CONTACTS      Created on 28-MAR-96

XTR_SETTLEMENT_SCRIPTS       Created on 18-FEB-97

XTR_SETTLEMENT_SUMMARY      .

XTR_SETUP_AUDIT_REQMTS      Created on 28-JAN-96

XTR_SOURCE_OF_IMPORTS       Import source information used for reconciliation

XTR_SOURCE_TYPES                                      

XTR_SPOT_RATES              History of foreign exchange rates

XTR_STANDING_INSTRUCTIONS     

XTR_STMT_TXNS     

XTR_STOCK_ALLOC_DETAILS         This table is to store realized gain/loss info for STOCK

XTR_STOCK_CASH_DIVIDENDS        This table is to store the Stock Cash Dividend records

XTR_STOCK_ISSUES                This table is to store the Stock Issues setup.

XTR_SYS_LANGUAGES     

XTR_SYS_LANGUAGES_TL        Created by ORACLE on 16-AUG-96

XTR_TAX_BROKERAGE_RATES    

XTR_TAX_BROKERAGE_SETUP     Tax and brokerage schedule information

XTR_TAX_CATEGORIES          Tax categories used for grouping the calculation methods and rates

XTR_TAX_DEDUCTION_CALCS    

XTR_TEMP_AUDIT_VIEW     

XTR_TERM_ACTIONS            Term adjustments for retail term money deals

XTR_TIME_RESTRICTIONS       Term limits information

XTR_TMP_FX_EXPOSURE         Created by ORACLE on 11-JUN-97

XTR_TRANSACTIONS_INTERFACE    

XTR_VOUCHER_REFERENCES      Created on 02-DEC-94

XTR_WF_USER_ROLES           Treasury Workflow Events

XTR_WHATIF_DETAILS          Created on 02-DEC-94

XTR_WHATIF_RATES            Created on 02-DEC-94

XTR_YIELD_CURVE_DETAILS     Created on 29-OCT-96

XTR_YIELD_CURVES            Created on 29-OCT-96

Friday 22 January 2016

Oracle Property table list in oracle apps

Property:

PN_PROPERTIES_ALL
PN_LOCATIONS_ALL

Leases :

PN_LEASES_ALL
PN_LEASE_DETAILS_ALL
PN_OPTIONS_ALL
PN_PAYMENT_TERMS_ALL
PN_DISTRIBUTIONS_ALL

Variable Rent Agreement:

PN_VAR_LINES_ALL
PN_VAR_PERIODS_ALL
PN_VAR_RENTS_ALL
PN_VAR_RENT_DATES_ALL
PN_VAR_RENT_INV_ALL
PN_VAR_RENT_SUMM_ALL

Full list is here:

PN_ACCOUNTING_EVENTS_ALL
PN_ADDRESSES_ALL
PN_AE_HEADERS_ALL
PN_AE_LINES_ALL
PN_COMPANIES_ALL
PN_COMPANY_SITES_ALL
PN_CONTACTS_ALL
PN_CONTACT_ASSIGNMENTS_ALL
PN_CONTACT_ASSIGN_HISTORY
PN_CURRENCIES
PN_DISTRIBUTIONS_ALL
PN_EMP_SPACE_ASSIGN_ITF
PN_INDEX_EXCLUDE_TERM_ALL
PN_INDEX_HISTORY_HEADERS
PN_INDEX_HISTORY_LINES
PN_INDEX_LEASES_ALL
PN_INDEX_LEASE_CONSTRAINTS_ALL
PN_INDEX_LEASE_PERIODS_ALL
PN_INDEX_LEASE_TERMS_ALL
PN_INSURANCE_REQUIREMENTS_ALL
PN_INSUR_REQUIRE_HISTORY
PN_LANDLORD_SERVICES_ALL
PN_LANDLORD_SERVICE_HISTORY
PN_LEASES_ALL
PN_LEASE_CHANGES_ALL
PN_LEASE_DETAILS_ALL
PN_LEASE_DETAILS_HISTORY
PN_LEASE_MILESTONES_ALL
PN_LEASE_OPTIONS_ITF
PN_LEASE_TRANSACTIONS_ALL
PN_LOCATIONS_ALL
PN_LOCATIONS_ITF
PN_LOCATION_FEATURES_ALL
PN_LOCATION_PARKS
PN_MILESTONES_ITF
PN_NOTE_DETAILS
PN_NOTE_HEADERS
PN_OPTIONS_ALL
PN_OPTIONS_HISTORY
PN_PAYMENT_ITEMS_ALL
PN_PAYMENT_ITEMS_EFC
PN_PAYMENT_SCHEDULES_ALL
PN_PAYMENT_TERMS_ALL
PN_PAYMENT_TERMS_EFC
PN_PHONES_ALL
PN_PROPERTIES_ALL
PN_RENT_ROLL_LEASE_EXP_ITF
PN_RIGHTS_ALL
PN_RIGHTS_HISTORY
PN_SET_MILESTONES
PN_SET_TYPES
PN_SPACE_ALLOCATIONS_ALL
PN_SPACE_ALLOC_ITF
PN_SPACE_ASSIGN_CUST_ALL
PN_SPACE_ASSIGN_EMP_ALL
PN_SPACE_ASSIGN_LEASE_ITF
PN_SPACE_ASSIGN_LOC_ITF
PN_SPACE_UTIL_LEASE_ITF
PN_SPACE_UTIL_LOC_ITF
PN_SYSTEM_SETUP_OPTIONS
PN_TENANCIES_ALL
PN_TENANCIES_HISTORY
PN_TERM_TEMPLATES_ALL
PN_VAR_ABATEMENTS_ALL
PN_VAR_BKPTS_DET_ALL
PN_VAR_BKPTS_HEAD_ALL
PN_VAR_CONSTRAINTS_ALL
PN_VAR_DEDUCTIONS_ALL
PN_VAR_GRP_DATES_ALL
PN_VAR_LINES_ALL
PN_VAR_PERIODS_ALL
PN_VAR_RENTS_ALL
PN_VAR_RENT_DATES_ALL
PN_VAR_RENT_INV_ALL
PN_VAR_RENT_SUMM_ALL
PN_VAR_VOL_HIST_ALL
PN_VOL_HIST_BATCH_ITF
PN_VOL_HIST_LINES_ITF
PN_REC_EXP_ITF
PN_REC_EXPCL_DTL_ALL
PN_REC_EXPCL_DTLLN_ALL
PN_REC_EXPCL_DTLACC_ALL
PN_REC_ARCL_ALL
PN_REC_ARCL_EXC_ALL
PN_REC_EXP_LINE_ALL
PN_REC_EXP_LINE_DTL_ALL
PN_REC_AGREEMENTS_ALL
PN_REC_AGR_LINABAT_ALL
PN_REC_AGR_LINAREA_ALL
PN_REC_AGR_LINCONST_ALL
PN_REC_AGR_LINES_ALL
PN_REC_AGR_LINEXP_ALL
PN_REC_ARCL_DTL_ALL
PN_REC_ARCL_DTLLN_ALL
PN_REC_EXPCL_ALL
PN_REC_EXPCL_TYPE_ALL
PN_REC_EXPCL_INC_ALL
PN_LOC_ACC_MAP_ALL
PN_LOC_ACC_MAP_HDR_ALL
PN_REC_CALC_PERIODS_ALL
PN_REC_PERIOD_BILL_ALL
PN_REC_PERIOD_LINES_ALL
PN_REC_LINBILL_ALL
PN_PAY_GROUP_RULES
PN_PAY_GROUP_BYS
PN_ADJUSTMENT_DETAILS
PN_ADJUSTMENT_SUMMARIES
PN_DISTRIBUTIONS_HISTORY
PN_PAYMENT_TERMS_HISTORY
PN_VAR_BKHD_DEFAULTS_ALL
PN_VAR_TEMPLATES_ALL
PN_VAR_CONSTR_TEMPLATES_ALL
PN_VAR_CONSTR_DEFAULTS_ALL
PN_VAR_LINE_TEMPLATES_ALL
PN_VAR_BKDT_DEFAULTS_ALL
PN_VAR_TRX_DETAILS_ALL
PN_VAR_TRX_HEADERS_ALL
PN_VAR_ABAT_DEFAULTS_ALL
PN_VAR_DEDUCT_ARCH_ALL
PN_RENT_INCREASE_SUMMARY_ITF
PN_VAR_VOL_ARCH_ALL
PN_OPEX_AGREEMENTS_ALL
PN_OPEX_PRORAT_BASIS_DTLS_ALL
PN_OPEX_EST_PAYMENTS_ALL
PN_OPEX_CRITICAL_DATES_ALL
PN_OPEX_NOTES_ALL
PN_OPEX_RECON_ALL
PN_OPEX_RECON_PRTBS_ALL
PN_OPEX_RECON_EXP_GRP_ALL
PN_OPEX_RECON_DETAILS_ALL
PN_OPEX_EXP_GRPS_ALL
PN_OPEX_RECON_CRDT_ALL
PN_VAR_REPORT_DATES_ALL
PN_RENT_INCREASE_DETAIL_ITF
PN_RENT_INCREASE_DETAILACC_ITF
PN_VAR_LINE_DEFAULTS_ALL

Thursday 21 January 2016

Introduction to Oracle GRC


Introduction:-
Oracle GRC term is relatively new word compared to Oracle E Business Suite ,
But it is getting hot day by day. Where GRC Stands for Governance – Risk Management – Compliance. GRC takes cares of Corporate Governance ,Corporate Compliance , and Enterprise Risk management. GRC integrates organizations to manage known and unknown risks –
which helps to demonstrate compliance with their organizational policies and external regulations.
GRC includes Orchestrating employees in other words we can call it as configuring GRC system
as well as configuring employees or an organization. GRC came into spotlight only after
Sarbanes-Oxley Act which need for all US listed companies to design and implement suitable SOX compliance.


Components of Oracle GRC:-
AACG: – Application Access Controls Governor

It provides a real time monitoring and enforcement controls.
Currently It also includes prevention of access provisioning for Responsibility
based security design in Oracle EBS, We have custom connectors for RBAC based security design for EBS.Oracle AACG provides library of Best practice controls library.

PCG: – Preventive Controls Governor

As names tells it’s a preventive controls mechanism ,
where Preventive controls can be used in EBS Forms (except OAF Forms )and EBS Workflows.
PCG Protects sensitive application data.One of the widely used feature of
PCG is Audit feature which reduce audit costs, reduced maintenance costs and increased IT productivity.

Please check this link for more information :  http://docs.oracle.com/cd/E25459_01/index.htm

CCG: – Configurations Controls Governor

CCG mainly geared towards application integrity and functionality.
The solution enables tracking of all changes, providing a detailed audit history,
and records designated setup values, permitting quick comparison of values from different points in time or environments. With Oracle Configuration Controls Governor, you can ensure application integrity, audit changes, and continuously monitor setups. As a result, you can reduce financial loss, regulatory cost, audit effort, and the risks associated with them.

TCG: – Transaction controls Governor

TCG continuously monitors transactions against policies to detect suspicious transactions or
redundant business practices that get in the way of performance. By spotting anomalies in everyday transactions, the system prevents cash leakage , TCG resides inside AACG which will minimize the installation efforts.

History of Oracle GRC :-

Oracle acquired Logical Apps a California based company in October 2007.
Logical apps were leading provider  of automated Governance ,
Risk and Compliance Controls management solutions. During Oracle acquisition

1) Oracle AACG version was in 7.X version but as of today they are in 8.6.5.The upgrade path was from 7.X > 8.0 > 8.1> 8.2> 8.5>8.6.3>8.6.4>8.6.5

2) Oracle PCG was in its 6.X version but as of today they are in 7.3.3 and this is the upgrade path for
(6.5.3 – 6.5.8)->6.5.8.1->7.1.2->7.2.2.2->7.2.3->7.3->7.3.1->7.3.2->7.3.3

3) Oracle CCG current version is 5.5.1,Oracle didn’t made any significant updates for CCG.

4) Oracle TCG current version is 8.6.5.

For More information check the below link from Oracle -
   http://docs.oracle.com/cd/E51797_01/index.htm

https://docs.oracle.com/en/applications/
      http://docs.oracle.com/cd/E25137_01/index.htm

Metalink Notes:

Enterprise Governance Risk and Compliance (EGRC) Product Information (Doc ID 1084596.1)

Critical Patch Information for Oracle Configuration Controls Governor (CCG) (Doc ID 1080374.1)

Critical Patch Information for EGRC (EGRCC, EGRCM, EGRCI) 8.6.4.3000(8.6.4.3347) Onwards. (Doc ID 1518219.1)

Responsibilities not visible to user in oracle apps

We recently encountered this issue on a R12 instance fully functional instance.

 1) Login as sysadmin or any user who as privileges to create user/add responsibilities

2) Create a new user and add responsibilities or add additional seeded/custom responsibilities to existing user


3) New/existing user logs in but he/she cant see the new responsibility.

Strange isnt it. I had encountered a simillar situation post 11.5.x to 11.5.10.2 upgrade, but the underlying problem is different here.

To tackle this situation, we ran the concurrent program “Workflow Directory Services User/Role Validation” with below parameters:

p_BatchSize – 10000 (Default Value 10000)
p_Check_Dangling – Yes (Default value No)
Add missing user/role assignments – Yes (Default Value No)
Update WHO columns in WF tables – No (Default Value No)

So what does this concurrent program do. It syncs all the user and role related WF tables with latest information viz., WF_LOCAL_ROLES, WF_LOCAL_USER_ROLES, WF_USER_ROLE_ASSIGNMENTS etc.,

The time taken to complete this program depends on the number of users/roles to be synched. After completion of this request the affected user can log back in to see the missing responsibilities.

You can also schedule this request to run every 15 minutes or so, but it depends how frequently you create/assign new users/roles/responsibilities.

Tuesday 12 January 2016

Master Note for Governance Risk and Compliance Manager (GRCM) 7.8 in oracle GRC





Master Note for Governance Risk and Compliance Manager (GRCM) 7.8 










https://support.oracle.com/epmos/adf/images/t.gif
In this Document































APPLIES TO:
Oracle Governance, Risk and Compliance Manager - Version 7.8 to 7.8 [Release Rel 12]
Information in this document applies to any platform.

PURPOSE
This Master Note answers questions and provides current information about the GRCM 7.8 release.  It contains a list of available externally published GRC Manager 7.8 Notes organized into sections.  This Master Note was last updated on 10-18-2012.

QUESTIONS AND ANSWERS
Documentation
Certification Matrix
See Document 741001.1 for the current GRCM Certification Matrix.
Software Download Location
The complete GRC Manager 7.8 release is a combination of the GRCM 7.8 software and the UCM 7.5.2 software.  The GRCM 7.8 software is available as Patch 12751816 on My Oracle Support https://support.oracle.com.   Follow the instructions below to download the GRC Manager 7.8 release software.
1.      Go to  https://support.oracle.com and login to My Oracle Support
2.      Select the Patches and Updates tab.
3.      Enter in the Patch Number 12751816 and click the Search button.
4.      Click on the patch link and then the Download button.
The UCM 7.5.2 software is not available for download anywhere on the Oracle site and will need a Media Request Service Request opened in order to obtain the software.
Patch Information
  • Note 760314.1  GRC Manager 7.8 has been Released with Patchsets

Newly Created or Updated Notes
  • Note 1499825.1  GRCM 7.8 Not Receiving email Notification When a Business Process Enters ValidateBusinessProcess Workflow
  • Note 1487862.1  GRCM 7.8 Single Sign On (SSO) not working, IE Browser prompts for login
  • Note 1477275.1  GRCM 7.8 Audit Map Filter Does Not Funtion Properly in GRCM When Searching For Processes
  • Note 1450207.1  GRCM 7.8 User With Admin Role Can Add Test Result in Mgmt Assessment Without Permissions
  • Note 1450261.1  GRCM 7.8 Management Assessment In Scope FilterSelection Does not Work Correctly
  • Note 1450309.1  Cannot Make Managment Assessment Reviewers Mandatory in GRCM 7.8
  • Note 1450274.1  Mass Update Controls Creates Numerous Version Documents in GRCM 7.8

Notes about GRC Manager Requirements and Limitations
  • Note 1387303.1  Upload the GRCM e100server.config file and Ensure the Correct Product is Selected for the Service Request
  • Note 447333.1  Cloning, Migrating, Backup Governance Risk Compliance Manager
  • Note 956132.1  Unable To Create New Organization Map Node Using Internet Explorer 8 on GRC Manager 7.8
  • Note 980626.1  Can We Install Two Instances of GRC Manager 7.8 on The Same Server?
  • Note 1105690.1  How Can You Set Password Expiration to be 90 days and Also Enforce a Minimum Password Length in GRCM
  • Note 1071607.1  Is There a Way To Install a GRC Manager 7.8 Environment With High Availability Clustering Options?
  • Note 450503.1  Is Secure Sockets Layer (SSL) Compatible With the GRC Manager Application?
  • Note 461085.1  What are the supported Platforms for Governance, Risk and Compliance Manager?
  • Note 1381505.1  Are the Macintosh Computers Supported as a client in GRCM 7.8?
  • Note 749982.1  Is The GRC Manager 7.8 Software Supported On a VMware Virtual Machine?
  • Note 737690.1  Can you install GRCM 7.8 with Oracle 10g RAC database?
  • Note 1054052.1  Can GRC Manager (GRCM) 7.8 be Integrated With GRC Controls (GRCC) Version 8.5?
  • Note 986544.1  Can The GRC Manager Virtual Directory and The Content Server Virtual Directory Be Located Under Separate Websites in IIS Web Server?
  • Note 577696.1  Approval Messages Do Not Show Up in My Inbox in GRC Manager
  • Note 781711.1  What are the Major, Minor, and Maintenance GA Releases for the GRC Manager?

Notes about GRC Manager Installation Issues?
  • Note 1101821.1  Receiving The Error, 'Oraoledb.Oracle' provider is not registered on the local machine, During The Post Installation GRCM 7.8 Steps
  • Note 1269929.1  GRCM 7.8 Creating New Business Process Receives JavaScript Error in AdminTreeFunctions.js Function "expand(objDiv)"
  • Note 1150416.1  Receiving Invalid Unicode Character Error in GRCM After Data Migration
  • Note 789821.1  The Following Error is Seen in the Event Viewer When GRC Manager is Started: "e100.e100Exception unable to connect to the remote server"
  • Note 783554.1  Installing GRC Manager 7.8, Received Internal Error 2908 and Error 1406: "Could not write value Local Package to key\products \...\InstallProperties"
  • Note 828726.1  e100Server.config cannot be read successfully due to exception System.ApplicationException: Invalid XML Error Starting a New GRCM Install
  • Note 445559.1  Resolving SocketException Errors When Attempting to Start GRCM Solution by Changing Port Numbers
  • Note 828756.1  Could not load file or assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50 Error on New GRCM Install
  • Note 856173.1  Is There A Dataloader, Or Other Bulk Method To Load Information Into GRC Manager?
  • Note 800565.1  How to Setup Oracle GRCManager 7.8 Active Directory (ADSI) Security
  • Note 1487862.1  GRCM 7.8 Single Sign On (SSO) not working, IE Browser prompts for login
  • Note 753504.1  How To Install the 11 Workflows That Are Mentioned in the Installation Guide for GRC Manager
  • Note 448017.1  TargetInvocationException Error When Accessing GRC Manager
  • Note 783910.1  Error When Checking In Map in New GRC Manager Install: "Content item was not successfully checked in. The content ID must be specified"
  • Note 812763.1  Error after installation of GRC Manager: "Attributelockchildrenhasanillegalvalueonelement in AppState.InitializeWorkFlowForms"
  • Note 859471.1  Error When Trying To Add an Attachment To a Business Process: "Unable to generate a temporary class  (result=1). error CS200" 
  • Note 446000.1  GRC Manager (GRCM) Error: "HTTP Error 404 - File or directory not found."
  • Note 783561.1  Error When Starting Up the GRC Manager Application After Installation: "Could Not Find The Target Url"
  • Note 755895.1  How To Resolve The Getlocalorgmap: Object Reference Not Set To An Instance Of An Object Error
  • Note 579103.1  Values for Field Created Through GRC Manager are not Saved When Populated
  • Note 784523.1  How Do You Manually Uninstall The GRC Manager Application When The Application is Not Listed in The Add/Remove Programs Manager?

Notes about Configuring GRC Manager?
  • Note 1227646.1  How To Configure GRCM 7.8 To Throw an Exception and Not an Application Error?
  • Note 1241394.1  How To Make the Risk Criticality Field Not Be Required in GRCM 7.8?
  • Note 1068290.1  How To Allow Email Notifications to be Sent to the Originator of an Action Item or Issue When the Status Changes to Closed or Canceled
  • Note 1262110.1  How Do You Change the Mail Server that the GRCM Application Uses to Send Email?
  • Note 1196479.1  Some Data fields are Not Propagated in GRCM with MCL or MPL
  • Note 1268680.1  How to Increase the Field Size for Test Instructions to be 2000 Characters in GRCM?
  • Note 1216504.1  How To Increase Field Length of Audit Cycle and Financial Statement in GRCM 7.8
  • Note 986058.1  How Do You Enable The "Get" Link For The Attachments in GRCM 7.8?
  • Note 800046.1  What Are The List of Possible Values For The Configuration Entries NOTIFY_RECEPIENTS_SOA_DSR and NOTIFY_RECEPIENTS_SOA_ISS?
  • Note 982193.1  How Do You Make The Control Description Field Mandatory When Creating a New Control in GRC Manager 7.8?
  • Note 782812.1  How To Disable Mandatory Fields in GRC Manager During Business Process And Control Creation
  • Note 743077.1  How Do You Copy Custom User Defined Field Values from One Business Process to Another In GRC Manager?
  • Note 780980.1  How Do You Get User Defined Field Values Defined in The Master Component Library (MCL) Propagated To All The Linked Business Processes?
  • Note 1056959.1  How To Increase The Length of Certain Fields in GRC Manager
  • Note 446261.1  How to Change the Title Field (dDocTitle) From a Maximum of 80 Characters to a Maximum of 255
  • Note 1350467.1  How To Increase the ASP.NET Timeout For the GRC Manager When Opening a Test Plan to Avoid Timeout Exception?
  • Note 1326007.1  How To Increase The ASP.NET Execution Timeout For GRC Manager When Using the Mass Update Function To Avoid Timeout Exception?
  • Note 1128604.1  How to Increase The ASP.NET Timeout For The GRC Manager MCL Propagation Process To Avoid pPerformUpdateFromMaster Error
  • Note 445759.1  How to Increase The ASP.NET Timeout For The GRC Manager Copy Process To Avoid inpPerformCopyProcess Error
  • Note 603759.1  How To Change The Oracle GRC Manager Database Definition To Communicate With a Different Database Server?
  • Note 756694.1  How To Resolve "Remotingexception: Service Not Found" Error When Accessing GRC Manager by Changing the Port Number
  • Note 848349.1  How To Configure the InitDelay Service Tag in GRCM 7.8
  • Note 749944.1  How Do You Give The Business Process Owner The Ability To Retire The Business Process In The GRC Manager Application?
  • Note 742295.1  How Do You Default The GRC Manager User Interface To Be Displayed in English
  • Note 736461.1  What Are The Steps To Change The Name Of The Optional 4th Map Name On The GRC Manager Select Map Screen?
Notes about GRC Manager Patched Issues?
  • Note 760314.1   GRC Manager 7.8 has been Released with Patchsets
  • Note 1499825.1  GRCM 7.8 Not Receiving email Notification When a Business Process Enters ValidateBusinessProcess Workflow
  • Note 1477275.1  GRCM 7.8 Audit Map Filter Does Not Funtion Properly in GRCM When Searching For Processes
  • Note 1450207.1  GRCM 7.8 User With Admin Role Can Add Test Result in Mgmt Assessment Without Permissions
  • Note 1450261.1  GRCM 7.8 Management Assessment In Scope FilterSelection Does not Work Correctly
  • Note 1450309.1  Cannot Make Managment Assessment Reviewers Mandatory in GRCM 7.8
  • Note 1450274.1  Mass Update Controls Creates Numerous Version Documents in GRCM 7.8
  • Note 1421081.1  GRCM 7.8 Cannot Make Management Assessment Reviewers Mandatory in Wizard or Assessment
  • Note 1337683.1  Unable to Change The Assigned To User on an Action Item in GRCM 7.8
  • Note 1338030.1  The In Scope Field Value on a Control Changes From YES to NO After Edit of Related Risk in GRCM 7.8
  • Note 1143878.1  How to Determine What Patch Level is Installed in the GRC Manager Environment?
  • Note 1278024.1  All Business Processess Are Displayed With The Same Title on Mass Update Page in GRCM 7.8
  • Note 1268522.1  GRCM 7.8 "Add Control" Button is Active for a Test Plan when Not in "Edit" State
  • Note 1210344.1  GRCM 7.8 Process Profile Report Returns Inconsistent Results
  • Note 1181684.1  Exception With Audit Map Length Over 250 Characters After Installing GRCM 7.8 Patchset 10
  • Note 1181643.1  GRCM 7.8 Admin Overrides For Management Workflows Not Functioning Properly.
  • Note 1181531.1  GRCM Exception When Initiating Testing or Assessment From Top of Organizational Map
  • Note 1070549.1  The Workflow History Information in GRC Manager 7.8 is Not Always Sorted Correctly by Date
  • Note 983975.1  The Date For United Kingdom is Being Stored and Displayed in The Wrong Format in GRCM 7.8
  • Note 961753.1  Users Have To Relogin To GRC Manager After Attaching File With Multiple Attachments Option Enabled
  • Note 880976.1  Error Message Received When Clicking On A Control In A Test Plan Test Cover in GRCM 7.8
  • Note 850421.1  The Content Item is No Longer in The System Error is Logged When Adding a New Business Process in GRCM
  • Note 850441.1  JavaScript Error in function "selectAddlMap()" When editing the Business Process and Pressing The "i" Button For The Optional 4th Map
  • Note 880387.1  Workflow Contributor Email Value Not Being Defined For GRCM Using Oracle Database
  • Note 881014.1  Control Owner is Not Able To Test Control During Audit Testing in GRCM 7.8
  • Note 850463.1  Control Owner of Retired Control Still Needs To Update Test Plan Document Before Test Will Complete
  • Note 837238.1  The Original Test Instructions From When The Test Was Executed For a Completed Test Are Not Retained
  • Note 850957.1  Initiating Testing From Organizational Map With Control Owner Feature Enabled The Test Cover Document is Not Being Routed To Control Owners
  • Note 851007.1  When Executing Controls In Scope Testing a Control Owner is Unable To Select Testing Complete Until All Other Controls Owners Complete Testing
  • Note 808370.1  Invalid Date Format Error When GRCM Date Format is DD/MM/YYYY on Action Item Due Date Using French Language Preference
  • Note 781003.1  The "Add attachment" Button is Only Active For Controls and is Not Available For Assertions and Risks When Adding Objects From The MCL
  • Note 761691.1  GRC Manager MPL Propagation Always Sets In Scope Flag Value To No In Linked Business Process
  • Note 762283.1  Unable To Remove The Initiate Management Assessment Link From The Organizational Map User Interface
  • Note 747693.1  Test Results Lose Link To Test Instructions When An Edit Is Made To The Control
  • Note 747278.1  Exception Received When Attempting To Edit a Control After Rejecting The Data Collection Workflow
  • Note 762269.1  BPCreator User Can Only Edit or Initiate a Test Plan When They Are The Owner Of The Test Plan
  • Note 760174.1  ORA-907 Error: MISSING RIGHT PARENTHESIS IN CMSSEARCH.EXECUTE EXCEPTION IN GRC Manager
  • Note 739962.1  ORA-12704: Character Set Mismatch Exception When Opening a Business Process in GRC Manager 7.8 Using Oracle Database

Notes about GRC Manager Issues with Workarounds?
  • Note 1099924.1  Received "Thread was being aborted" Exception When Running Report in GRC Manager
  • Note 1084912.1  How Can I Delete a Control in a Business Process That is Already Initiated in GRC Manager?
  • Note 1081547.1  How Can You Re-assign The Tester Field on a Test Plan Cover in GRCM After The Test Plan Has Already Been Started
  • Note 1074943.1 A "Deleted Map Element" Entry is Listed in a Control After Deleting a Map Entry From The Optional 4th Map in GRCM
  • Note 1211794.1  How Do You Get the Default Templates Directory and All four Sub-directories Back Into the Organizational Map?
  • Note 1052051.1  Unable To Create a User Defined Field in GRC Manager 7.8
  • Note 1086004.1  GRCM 7.x Errors During MCL Propagation: pvSendRequestToStellent: The operation timed out
  • Note 979722.1  GRCM 7.8 User Defined Fields will not save after installing Patchset5
  • Note 733046.1  Receiving Timeout Exception in GRC Manager Application when Adding Large Attachments
  • Note 822626.1  Access denied Occurs When Adding a User Defined Field in GRCM Using NTLM Authentication
  • Note 953822.1  How Do You Select a Past Date for Expected Completion Date Under the Remediation Tab When Creating Issues in GRCM 7.8
  • Note 738852.1  GRC Manager Users Are Unable To Edit Document When In Data Collection Workflow
  • Note 760681.1  Receiving Object reference Exception Error When Running Any Report in GRC Manager
  • Note 951308.1  Receiving Error "Argument 'Index' Is Not A Valid Value" When Refreshing From MCL Process
  • Note 941911.1  Receiving Error Message When Uploading Large File To GRC Manager
  • Note 552976.1  Active Directory User Attributes are Missing From the Users Table for New Users Logging Into the GRCM Application
  • Note 822653.1  Why Are ADSI External User Names Listed in Reverse Order as Lastname Firstname, and Have To Search Using Opposite Name Search Boxes?
  • Note 448916.1  Calendar is out of date - User Unable to Run Reports
  • Note 448462.1  Exception Received When Attempting To Approve a Business Process
  • Note 755904.1  Invalid Unicode Errors When Cutting and Pasting From Excel Document to GRC Manager
  • Note 757241.1  Workflow Email Notifications Generated By Oracle GRC Manager Have Incorrect URL Link Definition
  • Note 738630.1  Unable To Open Some Business Processes: "Invalid unicode character" Error
  • Note 1064415.1  How To Resolve ORA-00942 Exception in GRCM 7.8 When I Create a Map Entry, Add in New Fiscal Periods, or Create a New Business Process?
  • Note 784608.1  Maximum Request Length Exceeded When Attempting To Add a New Node To a Map File in GRC Manager
  • Note 746364.1  Exception Error Encountered When Adding Multiple Associated Risks To Controls In GRCM
  • Note 784617.1  Error inSaveMap Thread was being aborted Exception When Attempting To Add a New Node To a Map File in GRC Manager
  • Note 789693.1  GRCM Assertions Risks Controls Matrix Report Timing Out
  • Note 445569.1  Resolving Orphaned Issues in GRC Manager

Notes about General GRC Manager Information?
  • Note 1317066.1  How is a New User Defined Field Added to the GRCM 7.8 Application?
  • Note 1091814.1  Is There An Addon required For GRCM 7.8 To Be Able To Script Survey Templates?
  • Note 761621.1  Where Is the Contributor Name Obtained From in GRC Manager Emails?
  • Note 445379.1  How To Interpret the GRC Manager Heat Report
  • Note 447622.1  How is the Heat Map is calculated on the Executive Dashboard?
  • Note 738871.1  How Do You Delete an Organizational Map from the GRC Manager Application?
  • Note 859553.1  How Can You Remove a Test Results Document From The GRC Manager Application?
  • Note 741243.1  Is There a Way to Replace an Attachment to a Test Cover That Is In a Status of Released?
  • Note 798068.1  Can The User Assigned to The Organizational Folder Permission Ever Be Removed Once Assigned in The GRCM Manager?
  • Note 977627.1  Is the Unicode Patch 7496670 Included in the GRCM 7.8 Base Patchsets?
  • Note 728200.1  How Do I Refresh GRC Manager Views When The "Refresh DB Views" Button on the Configuration Administration Page is Missing?
  • Note 856126.1  What Is Recommended Design of Organization Map and Are There Any Samples, Best-Practices or Recommendations for Organization Map Setup?
  • Note 807248.1  Why Does Running the GRCM Report "All Controls Tested Within the Period" Produce No Results?
  • Note 814354.1  How Can Test Results be Viewed While Creating an Issue After Rejecting a Test?
  • Note 449767.1  Is There a Reason Why a Business Processes Would Have All of The Buttons Greyed Out When it is in a Released State?
  • Note 740503.1  Best Practices For Backups of GRC Manager
  • Note 805441.1  Control Version and Content Server Revision Values Do Not Always Match on Control History Page
  • Note 601530.1  Is It Possible To Edit a Process That Has Been Retired?
  • Note 1052033.1  What is The Full Product Name That Should Be Selected in My Oracle Support When Opening Service Requests For The GRC Products? 

Notes about GRC Manager Third Party Product Issues?
  • Note 790631.1  E-mail Notification Body issues using Microsoft Exchange mail servers
  • Note 760299.1  GRC Controls Are Not Available Through GRC Manager
  • Note 470804.1  Unable to Login, Access Portal.htm, or Browse to any Content Server Page for Which Windows Event Viewer Event IDs 2214 and 2268are Thrown
  • Note 845799.1  JavaScript Error with Lotus Notes
  • Note 813656.1  Parser Error Message: Unrecognized configuration section 'xhtmlConformance' 1.1.4322.2379