Monday 30 March 2015

Notification

 SELECT count(*) FROM GL_PERIOD_STATUSES gps , LAUD_AUDIT_TRANSACTIONS LAT , FND_APPLICATION fa , FND_USER fu , GL_LEDGERS gsb , GL_LOOKUPS_PERIOD_STATUSES_V gpsvnew , GL_LOOKUPS_PERIOD_STATUSES_V gpsvold,FND_APPLICATION_ALL_VIEW fav WHERE
lat.TABLE_NAME in ('GL_PERIOD_STATUSES')
and lat.PK_VAL3_ID=gps.application_id
and lat.PK_VAL2_ID=gps.period_name
and lat.PK_VAL1_ID=gps.set_of_books_id
and fa.application_id=gps.application_id
and fav.application_id=fa.application_id
and gsb.ledger_id=gps.set_of_books_id
and gps.application_id in (200,222,101)
and fu.user_id=gps.last_updated_by
and lat.old_value='C'
and lat.new_value='O'
--and gps.closing_status ='O'
and lat.COLUMN_NAME not in ('CREATION_DATE','LAST_UPDATE_DATE')
---and to_date(lat.transaction_date) >=to_date(sysdate)-10
and gpsvold.status_flag = lat.old_value
and gpsvnew.status_flag = lat.new_value
and gps.period_name in
(select period_name from gl_periods tt
where tt.period_set_name='BTVL Fiscal'
and end_date=(
select start_date-1 from gl_periods                  
where period_set_name='BTVL Fiscal'
and start_date<=sysdate
and end_date >=sysdate)
)
order by lat.transaction_date desc

Rule Subscribers in PCG

Saturday 28 March 2015

How the Oracle GRC Applications Suite Helps

                                                         Oracle provides an enterprise GRC platform for managing the changes to business processes and controls that are inherent in an EBS upgrade. The platform integrates documentation and process management, automated controls enforcement, and business intelligence to provide comprehensive capabilities for compliance and risk management requirements. By leveraging the Oracle GRC applications suite, organizations can ensure sustainable compliance, sound business processes, and protected information in post-upgrade operations. The Oracle GRC applications suite includes the following modules:
» Oracle Enterprise GRC Manager (EGRCM) provides the shared foundation and tools needed for enterprise-wide management of GRC programs and reduces overlapping and redundant policies, processes, risks, and controls.
» Oracle Fusion GRC Intelligence (FGRCI) empowers organizations to stay on top of critical risk management activities. It offers visibility into an organization’s upgrade readiness and risk responsiveness by providing risk, control and performance analytics and dashboards.
» Oracle Advanced Controls (OAC) continuously monitors, enforces and optimizes processes to prevent prohibited or suspicious activities. By monitoring critical setups and user access, it ensures adherence to company policy by identifying control breaches as soon as possible. There are several control governors that comprise OAC:
» Oracle Configuration Controls Governor (CCG) - Controls and tracks changes to key application setup and master data to facilitate change management without burdening core business operations. The solution records designated setup values, permitting quick examination and evaluation of new values and comparison of values from different releases, points in time or environments. It also performs continuous monitoring once the upgrade is done to ensure ongoing configuration integrity.
» Oracle Application Access Controls Governor (AACG) - Provides real-time monitoring and preventive enforcement of crucial access policies. The system anticipates potential segregation of duty (SOD) conflicts before they arise and prevents the assignment of roles or responsibilities within an application that would compromise proper SOD policies.
» Oracle Preventive Controls Governor (PCG) - Provides fine-grained control over users’ activities (e.g., viewing and editing key data), while tracking users’ changes, both completed and attempted. Organizations can limit or control the fields that users can view and edit, define the types of data that users can input in various fields, and limit transaction values to enforce financial and operational controls.
» Oracle Enterprise Transaction Controls Governor (ETCG) - Continuously monitors transactions to detect suspicious transactions and redundant business practices. During upgrades, companies will undertake changes in policies and controls, leaving them vulnerable to waste and fraud. ETCG spots anomalies in everyday transactions, thereby reducing cash leakage, and avoiding fraud and costly remediation.