Thursday, 24 October 2013

Data Access Set

Data Access Set
          
      Data access set is used to restrict balancing segment values or management segment values with read or write privileges to a particular responsibility or user.
                Once we complete a ledger with the entire ledger options system internally generates a default data access set with the same name as our primary ledger which is going to give access to full ledger with read and write privileges. This will be automatically assigned to the responsibility using GL data access set profile option.   The default data access set will give access to full ledger with read and write privilege.  We cannot modify default data access set.
                We can also define additional data access set based on our business requirement. We can define any number of data access sets but only one data access set can be assigned to general ledger responsibility by using GL data access set profile option at any point of time.
                We cannot perform open/close periods from a responsibility to which we have a restricted data access set. We will be allowed to perform open/close periods only   those responsibilities to which we have full ledger access
Access set types:
1.       Full ledger
2.       Balancing segment value
3.       Management segment value
Full ledger:
                Full ledger accesses means having full read and write access to the ledger and all of its balancing segment values or management segment values
Balancing segment value:
                If you assign specific balancing segment values to legal entities and ledgers, you will only be able to use those balancing segment values during transaction processing and journal entry.
Management segment value:
                When securing management segment values for a ledger, take note of the management segment values you used when you assigned the default accounts to the ledger, such as the retained earnings account and the cumulative translation adjustment account.

The privileges available for all the three Data Access sets are:
Read only:  Users allow viewing data in ledgers and balancing or management segment values.
Read and Write: Allows users to view and enter data in ledgers and balancing or management segment values.

Steps required for defining data access set:
Step1:
                Define data access set
Navigation:
                Setup => financials => data access set
1.       Enter data access set name.
2.       Select chart of accounts.
3.       Select calendar.
4.       Select access set type.
5.       Enter access details.
6.       Select ledger/ledger set.
7.       Select specific balancing or management segment value.
8.       Select privileges read and write or read only as per our requirement.
9.       Save your work.
Step2:
                Assign data access set to GL responsibility
Navigation:
                Application: System administrator
                Profile => system





Tuesday, 22 October 2013

Cross-Validation Rules


Cross-Validation Rules
                Cross validation rules are used to restrict the combinations between the segments of a chart of accounts. For one chart of accounts we can define one or more cross validation rules.
Steps required defining cross validation rules:
Step1:
·         Enable cross validate segments option at our chart of accounts
Navigation:
                                Setup => financials  => flex field => key => segments
o   Select structure
o   Disable freeze flexfield definition
o   Enable cross validate segments
o   Enable freeze flex field definition
o   Compile structure
Step2:
·         Define cross validation rules
Navigation:
                                Setup => financials =>flexfields => key => rules
o   Select structure
o   Enter cross validation rule name and description
o   Enter error message and error segment
o   Select exclude and include rules
Include and exclude rules:
1.       For each cross validation rule we have a include rule
2.       Include rule is to determine to include all the combinations between the segments
3.       One include rule can have one or more exclude rules
4.       An exclude rule is to determined to exclude the combinations from an include rule.






Sunday, 20 October 2013

General Ledger

Oracle General Ledger:
                Oracle general ledger is the central repository accounting information. The main purpose of general ledger system is to record financial activity of a company and to produce financial and management reports to help people inside and outside the organization make decisions.   
General Ledger Accounting cycle:           
1.       Open Period
2.       Create / Reverse Journal entries
3.       Post
4.       Review
5.       Revalue
6.       Translate
7.       Consolidate
8.       Review /Correct Balances
9.       Run accounting report
10.   Close accounting period

Oracle General Ledger Integrates With:

                        Financials:
§  Payables
§  Receivables
§  Assets
§  Purchasing
§  Projects
§  Treasury
§  Property manager
§  Lease management
HRMS:
o   Human Resource
o   Payroll
Manufacturing:
v  Inventory
v  Work in process
v  Labor distribution
Public Sector:
Ø  Grants accounting
Ø  Public sector budgeting
Ø  Public sector financials
Ø  Federal financials
Business intelligence/Analytic Solutions:
ü  Financial consolidation hub
ü  Enterprising planning and budgeting
ü  Oracle financials service application
ü  Daily business intelligence
ü  Activity-Based management