Erp gruop3 cvr-sr
- 1. Oracle E-Business Suite (ERP r12) BIS 671 Group3 Case Study :: Joes Tintton Fashion Business Chart of Accounts
- 2. Agenda Case Study Pre Set-up Propose How to Creating Cross Validation Rules (CVR) Propose How to Creating Security Rules (SR)
- 3. Case Study Joes Tinton Fashion Business Chart of Account Rules
- 5. Rules Cross Validation Rules(CVR) 1. There is no Line of Business begin with 1x-5x in Men Section and 6x-9x in Women Section 2. There is no Expense Accounts with Unspecified Department 3. There is no revenue from other department except Sales & Marketing department Security Rules(SR) 1. Allow the officers of each Corporate, Department to access only their own organization
- 6. Pre Set-up How to View Segment Flex field Set Security Enable Set Security Type
- 7. How To View Segment Flex field
- 8. How To View Segment Flex field 2 1 3 Access Path
- 9. Corporate Segment :: Set Security Enable Corporate Checked
- 10. Corporate Segment :: Set Security Type Corporate Select
- 11. Department Segment :: Set Security Enable Corporate Checked
- 12. Department Segment :: Set Security Type Corporate Select
- 13. Account Segment :: Set Security Enable Corporate Checked
- 14. Account Segment :: Set Security Type Corporate Select
- 15. Creating Cross Validation Rules (CVR) Access Path
- 16. CVR Rules :: No Line of Business Begin with 1x to 5x in men Section and 6x to 9x in Women Section Alternative
- 17. CVR Rules :: No Expense Accounts with Unspecified Department Example Sale&Marketing Cost of goods sold 01.03.5100.1.61 Cost of goods sold 01.00.5100.1.61
- 18. CVR Rules :: No Expense Accounts with Unspecified Department Structure G3 Name CVR Rules
- 19. CVR Rules :: No revenue from other department except Sales & Marketing department
- 20. CVR Rules :: No revenue from other department except Sales & Marketing department
- 21. CVR Rules :: No revenue from other department except Sales & Marketing department
- 22. CVR Rules :: No revenue from other department except Sales & Marketing department Example Sale&Marketing 01.03.4100.1.61 R&D 01.01.4100.1.61
- 23. CVR Rules :: No revenue from other department except Sales & Marketing department Structure G3 Name CVR Rules
- 24. Test CVR Rules :: Can not Entry Line of Business begin with 1x-5x in Men Section and 6x-9x in Women Section
- 25. Test CVR Rules :: Can not Entry Expense Accounts with Unspecified Department
- 26. Test CVR Rules :: Can not Entry No revenue from other department except Sales & Marketing department
- 27. Test CVR Rules :: Revenue account is valid only on Sales & marketing and line of Business Entry Valid
- 28. Creating Security Rules (SR) Access Path
- 29. SR Rules :: Allow the officers of each Corporate, Department to access only their own organization Corporate : Creation SR Corporate Name SR Rules
- 30. SR Rules :: Allow the officers of each Corporate, Department to access only their own organization Corporate : Assign to Controller Corporate Controller SR Rules
- 31. SR Rules :: Allow the officers of each Corporate, Department to access only their own organization Department : Creation SR Department Name SR Rules
- 32. SR Rules :: Allow the officers of each Corporate, Department to access only their own organization Department : Assign to Controller Department Controller SR Rules
- 33. Test SR Rules :: The staff is working in Thailand, Singapore 03 Malaysia
- 34. Test SR Rules :: The staff is working on Sale & Marketing. 05 Logistic
- 35. Test SR Rules :: 1: The staff is working on Thailand, Singapore . 2: The staff is working on R&D, Production, Sale & Marketing and Procurement Entry Valid
- 36. Cross-Validation Rules and Security Rules Question