Implementing Oracle Human Resources

PrerequisitesYou must complete your implementation of Oracle General Ledger.

Steps1. Switch Responsibility to US HRMS Manager.

2. Define Org Types (Other Definitions > Lookup Tables). Org Types can be Business Group, Department, HQ, or any other types suited to your business needs.

3. Define locations (Work Structures > Location). These are used to set up organizations in the next step.

4. Define organizations (Work Structures > Organization > Description). In the Organization Classifications region, assign business groups.

5. Use SqlPlus to check your work and make a note of your ORGANIZATION_ID and BUSINESS_GROUP_ID from table HR_ALL_ORGANIZATION_UNITS.

6. Switch responsibility to System Administrator.

7. Set the site level value for profile option HR: Business Group to one of the new business groups defined above.

8. Set the responsibility-level (US HRMS Manager) value for profile option HR: Business Group to one of the new business groups defined above.

9. Set the site-level value for profile option HR: Security Profile to one of the new business groups defined above.

10. Set the responsibility-level (US HRMS Manager) value for profile option HR: Security Profile to one of the new business groups defined above.

11. Switch responsibility to US HRMS Manager.

Note: A single Organization can act as a business group, a legal entity and an operating unit. Please be very clear before starting this setup.

12. Define Legal Entity (Workstructure > Organization >Description):a. Associate the GRE/Legal Entity classification with your organization and continue with additional setups as needed.
b. Enter the set of books.

13. Double check your work:a. Under Help > Diagnostics, examine for block HOU1 and field BUSINESS_GROUP_ID.
b. Verify the value of BUSINESS_GROUP_ID for block $PROFILES$ and field PER_BUSINESS_GROUP_ID,
c. Verify the value of BUSINESS_GROUP_ID.

14. Define your operating unit (Workstructure > Organization >Description)a. Associate the Operating Unit classification with your organization and continue with additional setups needed.
b. Enter the legal entity.
c. Switch to the Sysadmin responsibility.
d. Change the site level profile option for MO: Operating Unit to the operating unit you defined.

15. Switch to the HR responsibility.

16. Define the HR Organization (Workstructure > Organization > Description)a. Associate the HR Organization classification with your organization.

17. Define Inventory Organization (Workstructure > Organization > Description)a. Associate the Inventory Organization classification.
b. Click Others.
c. In Accounting Information, enter the legal entity, the set of books, and the operating unit created earlier.
d. Use SqlPlus to double-check data in tables 

HR_ALL_ORGANIZATION_UNITS,

HR_ORGANIZATION_INFORMATION, 

HR_LEGAL_ENTITIES, and 

HR_OPERATING_UNITS.

18. If you wish to enable multi-organizational features for new installations, then run the Adadmin concurrent program to enable Multi-Org at site level. Adadmin will pick the MO: Operating Unit profile value set at the site level.

19. If you are implementing a new installation you must create employees:a. Define the employee. (People > Enter and Maintain)
b. Define the manager of the employee by clicking Assignment. This step also assigns the employee to an organization. The manager's organization must be one of an HR business groups you have defined previously.

Note: You must enter the manager for an employee for Oracle Marketing Online Workflow approval to work correctly. If you are creating a new business group instead of using the seeded business group, and if you receive the flexfield error (Code = GRP), then you must set up the People Group flexfield.

20. Set up a Business Unit:a. Navigate to US HR MANAGER->Other Definitions->Look Up Tables.
b. In the Look Up Tables form, search for and set up values for ORG_TYPE.
c. In the CODE field for ORG_TYPE, enter the value BU (This is the key).
d. In the meaning field enter the value Business Unit and a free-form description.
e. As an option, you may also define Company with the code COMP and Department with the code DEPT.
f. After you have defined your ORG_TYPE, you must describe your ORG_TYPE. This is done by navigating to US HR MANAGER->Work Structures->Org.-> Description.
g. Once you have opened the Description form, select the New tab.
h. In the Name field, enter the business unit name. For example, Business Computer Organization.
i. Using the Type list of values, select the Business Unit that you defined previously.
j. Enter an address.
k. Save the record.

Oracle DISCOVERER

Simple Folder : from Single Table

Complex Folder: Join two simple folders

Custom Folder : SQL query WHERE ORDER BY Having Group By

1)Connect to the Admin Edition

2)Create Business Area and Create Simple Folder

3)Connect to the Desktop Edition and Create new Workbook by select

  the Business Area whatever we have created.

4)Once we select the Business Area it will shows the folders which we have in the Business Area

  select folder and Columns => Select Next button and Finish Button

 

Note:- In the Business Area we have more than one Simple folder we can select only one simple folder columns not multiple folder

2)If we want to select  columns from Multiple folders then we will go for creation of

  Complex Folders.

 

VenodrID VendorName Cdate  SiteID    SiteCode   Cdate  City

=======  ========== ===== ====== ======== ===== ====

1)Create Two Simple Folders in Admin Edition

2)Select the Primary key from Simple Folder => Right click=>New join

   Select the Join Condition.

   Note: for Outer join select Options Button

         for multiple join conditions select Multi Item Button

3)System will create the join condition between the Simple folder we can find that end of the  Simple folder.

4)Go to Desktop Edition and Create Workbook by select Business Area select the columns from  multiple folders and design the Format.

 

Sort Options :

1)Right Click on the Workbook column name

  => Item Properties  =>to change the Column Name

  => Group Sort  =>To make grouping

  => Sort Low  to High =>Ascending order

  => Sort high to Low  =>Descending order

  => Format Data     => To format the Data

  => Format Heading  => Format the Heading

  => Format Exception =>To give the Format Conditions

Add Title to the Workbook:

1)Go to Tools Menu=> Options=> Table Tab=>Check the Title Check Box

  Double click on the Title Text enter the Title

2)Select the Button called Insert button  to Insert Date , Time, Parameter valued and so on

  

Custom Folder:

                            SQL Query

1)go to Admin Edition

2)Right click Business Ares => New Custom Folder

                             => New Folder From Database to Create Simple Folder

3)Go to Desktop  edition and select the Business Area

  we can find both Simple and Custom Folder

Note: Once we select column from Custom Folder Simple folders will be disabled we can not  select the Column from simple folders.

4)Select the Column and Select Finish Button.

Creation of Custom Folder

1)Go to Administrator  Edition Select the Business area =>Right Click

  select the option called New Custom Folder

2)Enter the  Select Statement whatever is valid

3)Define the Workbook in the Desktop Edition by selecting the Business area.

Grouping the Records:

If we would like to apply any group by clause then we will select Column name

=>Right Click => Group Sort which will group the records based on the column

Attach the Title

Go to the Tools menu Options field =Select the Tab called Table check the

check box called Title => Double click on that and enter the Title.

Select  Insert button to insert the Data , Time and as well as Parameter Values.

 

Attach the parameters:

Select Tools Menu Parameters option

select the new button select the column name for comparison select the relation

and specify the condition.

To Display the parameter value in the Title then go to title Select Insert button

insert the Parameter name .

Item Classes :

Item class is nothing but list of values which will be attach to the parameter to

Select single value or multiple values.

Go to Admin Edition select Item classes tab =>Right Click select Item classes

Select the Folder . and select the column name

So that we can use that LOV for that folder and as well as for the selected column.

Go To Desktop Edition attach the parameter

Check the check box called Allow users to enter multiple values.

So that user can select multiple values at a time otherwise single value.

Complex Folders :

Joins Simple Folders by using Join Condition

 For Ex :ap_invoices_all              simple folder

         ap_invocie_distributions_all Simple Folder

Use the Join condition between both the Folder select data from both the tables.

Go to Desktop edition select the columns from both the folders whatever are required  and design the work sheet

Display the Total:

select  Tools menu Totals option to display the Grand total and as well as the

Sub Total

select the Group function and column Name and select either Grand total or Subtotal.

Press OK

From Vendor ID

To    Vendor ID

WHERE vendor_id between :from id and :to id

Attach the Parameters and Conditions:

1)Go to Tools Menu =>Parameters=>New

  Select the Column Name and Define the Parameter

Use Parameter in the Condition:

1)Go to Tools Menu=>Conditions=>New

  Select Condition , Item And Value

2)If we would  like to provide multiple conditions by using either AND (or) OR

  we will use the Add Button

3)Double click on the AND it will be changed to OR

LOV Creation:

 Go to Admin Edition select Business Area => Folder

Right Click=> Item Classes =>Select column Name.

2)Go to the Desktop Edition Parameters attach the parameter

  will be displayed LOV.

Display Total:

1)Go to Tools=>Total option => New button

   select group function and Column Name

   select either Grand Total or Sub Total (If it subtotal At what level)

2)Enter the Prompt as per that value will be displayed

Display Formula Columns:

  1)Tools menu=>Calculations options=>New

  select the Function an pass the Arguments select column in the Workbook

  Layout

Register User Defined Functions:

1)Go to Sell Prompt create Function with return value compile successfully.

2)Go to Admin Edition => Tools=>Register PL/SQL Function=>

  Enter the Function Name (If package function enter package name also)

3)Go to Arguments tab enter the Parameter details also.

4)Select Validate button and Ok button.

5)go to Desktop Edition Tools=>Calculations=>All function

  where we can find the function whatever we have registered.

6)Select the function pass the parameter we can get the result.

Oracle GL, AP, AR, FA and CE faqs

1. Which module is not included in Procurement?
a) Oracle Payables
b) Oracle Purchasing
c) Oracle Order Entry
d) Oracle Cash Management
e) Both C) and d)
f) Both b) and d)

2. Top Ten List is
a. Shortcuts to up to ten user-defined functions
b. Shortcuts to the ten most frequently used functions
c. Shortcuts to exactly ten user-defined functions
d. List of the top ten new features

3. Which of the following data are not partitioned by operating units?
a. Payables
b. Assets
c. Receivables
d. Purchasing
e. Order Management

4. Which of the following are reasons why it is desirable to share information between applications?
a. Minimizes time for implementation setup
b. Makes information available to every application in the system
c. Minimizes data synchronization problems, because each piece of data is kept in only one table
d. Keeps users from having to enter identical data in more than one place
e. Increases processing speed

5. Which of the following is not a qualifier for an accounting flexfield?a. Balancing segment
b. Category segment
c. Natural account segment
d. Cost center segment
e. Secondary Tracking Segment
f. Management Segment

6. Which of the following is not an organization classification?
a. Primary Ledger
b. Legal entity
c. Operating unit
d. Inventory organization
e. Business Group

7. How are journal entries in Oracle General Ledger organized?
a. Lines, Headers, Batches
b. Groups and then Lines
c. Batches, Headers and then Lines
d. Worksheets, headers, lines
e. Batches, Worksheets and Headers

8. Is it necessary to change password at regular intervals in Oracle Applications?
a. True
b. False
 

9. It is possible to create Responsibility for General Ledger Application without Menu?
a. True
b. False

10. The maximum number of segments in Chart of Accounts flexfield is 40.
a. True
b. False

11. Which of the following is not part of Responsibility?
a. Menu
b. Data Group
c. Request Group
d. Password
e. None of the above

12. Descriptive Flexfields are mandatory in Oracle Applications.
a. True
b. False

13. Chart of Accounts is a good example for Descriptive Flexfield in Oracle.
a. Yes
b. No

14. Once we login to Oracle Applications, we can not logout immediately.
a. True
b. False

15. What is CCID?
a. Cross Currency ID
b. Code Combination ID
c. Cost Center ID
d. Compilation Code ID
e. None of the above

16. It is necessary to configure MO: Operating Unit for Accounts Payables Application?
a. True
b. False

17. Oracle Alerts can be used to send alert messages to managers in the company?
a. True
b. False

18. Which of the following is not a valid Oracle Alert?
a. Periodic alert
b. Event Alert
c. Monthly Alert
d. Yearly Alert
e. All of the above
f. Both C) and d)

19. Oracle workflow can be used for
a. sending notifications to employees as required
b. setting approvals mechanism in the company
c. implement business flow in company
d. All of the above

20. One of the users in the company forgot his password. Which of the following is appropriate?
a. User will not be able to login to the application in his lifetime
b. User can request system administrator to change the password
c. system administrator needs to create a new user immediately
d. Company needs to dismiss the employee for forgetting the password
e. None of the above

21. What is MOAC?
a. Multiple Organization Access Control
b. Multiple Organization Applications Control
c. Multiple Operations Units Access Control
d. Match Organizations with Account Codes
e. None of the above

22. Which of the following is optional while defining Responsibility?
a. Menu
b. Start Date
c. Data Group
d. Request Group
e. None of the above

23. What is the difference between Key Flexfield (KFF) and Descriptive Flexfield (DFF)?
a. KFF and DFF are Mandatory
b. KFF and DFF are Optional
c. KFF is Optional and DFF is Mandatory
d. KFF is Mandatory and DFF is Optional
e. None of the above

24. What of the following is true?
a. Responsibility is attached to Menu
b. Responsibility is attached to User
c. Menus are attached to User
d. User is attached to Responsibility
e. None of the above

25. What of the following is a good example for Oracle Workflow?
a. Posting of GL Journals
b. GL Journal Approval
c. GL Budget Creation
d. Creation of Responsibility in Sys Admin
e. None of the above

26. Which of the following items is NOT a valid consideration when you need to import legacy data into Oracle General Ledger?
a. Adding new GL columns for data not accommodated by GL
b. Network throughput rate
c. Interfacing legacy tables to Oracle GL tables
d. Working around legacy-system shortcomings
e. Not Applicable

27. Which data element is not present in Oracle General Ledger?
a) Budgets
b) Journal entries
c) Customers
d) Accounts master file
e) Encumbrances

28. What is the initial status of an accounting period in Oracle General Ledger?
GreenChain Software Solutions Pvt. Ltd. Question Paper
Private Circulation Only 4
a) Future-Entry
b) Open
c) Never Opened
d) Closed
e) Permanently Closed

29. What is the very first step in setting up Oracle General Ledger?
a) Primary Ledger
b) Chart of Accounts
c) Suspense accounts
d) Security rules
e) Cross Validations Rules

30. Which option best describes the function of security rules?
a) They restrict access to a Primary Ledger
b) They restrict access to Account Combinations
c) They restrict access to Segment Values
d) They restrict access to Forms
e) They restrict access to Operating Units

31. Which of the following is not a prerequisite for entering a Primary Ledger?
a) Chart of Accounts
b) Budgetary Control Group
c) Accounting calendar
d) Functional currency
e) Not Applicable

32. How should T be defined in Summary Accounts?
a) Summary account
b) Parent value
c) Child value
d) Rollup group
e) Not Applicable

33. By what entity is the authorization limit for manual journal entry set in Approvals?
a) Position
b) Journal source
c) Journal category
d) Employee
e) User

34. If a journal with four different balancing entities is out of balance, what accounts will be used as balancing accounts?
a) Intercompany account
b) Suspense account
c) Offset account
d) Target account
e) Not Applicable

35. Which one of the following Mass Allocations options usually generates the most journal lines?
a) Constant
b) Looping
c) Summing
d) Total
e) All of the above

36. Which line describes the function of the Journal Import program?
a) Delete Journal entries
b) Modify Journal Entries
c) Import Journal entries
d) Corrects journal entries
e) Not Applicable

37. What of the following choices is not a valid display option in account assignments for row sets?
a. B
b. C
c. E
d. T
e. Not Applicable

38. What do you need to do with bank statement lines that are marked as External?
a. Reverse receipts
b. Need not do anything
c. Create miscellaneous transactions
d. Mark them as Internal afterwards
e. Stop the payments

39. Which of the following statements is true?
a. You cannot purge without archiving
b. You can archive without purging
c. Oracle Cash Management purges Forecasting the open interface automatically
d Oracle Cash Management purges Bank Statements in the open interface automatically
e. Bank statements from production tables can be deleted

40. Cashier has decided to Void the Payment and wants to process the invoice only after talking to the supplier as there is some discrepancy. Which invoice action will be the best choice?
a. None
b. Hold
c. Cancel
d. Stop
e. Release

41. Accounts Payables is integrated with Purchasing and uses Matching options. Which of the following is not possible in Invoice Workbench?
a. Two - Way Matching
b. Three - Way Matching
c. Four - Way matching
d. One - Way Matching
e. None of the above

42. Payables clerk has validated one invoice in Invoice Workbench in Payables module by mistake and does not want this invoice to be paid. Which one of the following is the best option?
a. Cancel the Invoice immediately from invoice workbench
b. Delete the invoice from Payables Application
c. Inform Cashier through mail or inter office correspondence that invoice should not be paid
d. Apply Hold on the invoice immediately
e. Run concurrent program "Reverse Validated Invoice" and select invoice no. as parameter

43. Which of the following is NOT possible while designing Withholding Taxes in Payables?
a. Create Withholding Tax Invoice during Invoice Validation
b. Create Withholding Tax Invoice during Invoice Payment
c. Create Withholding Tax Invoice while saving the invoice
d. All of the above
e. None of the above

44. Oracle payables is set up at the _____ level in a multi org environment?
a. Legal Entity
b. Business Group
c. Operating Unit
d. Inventory Organization
e. HR Organization

45. Which of the following is NOT a valid Invoice Type in Payables Module?
a. Prepayment
b. Post payment
c. Mixed
d. Withholding Tax
e. Debit Memo

46. Where do you assign Ledger to an Asset Book in Assets Module??
a. System Options
b. Asset Category
c. Book Controls
d. Asset Fiscal Years
e. Prorate Conventions

47. Select the sequence of physical inventory counting of assets in FA?
a. Enter Physical inventory data, Run comparison, View Results
b. Run Comparison, View Results, Enter Physical Inventory Data
c. Enter Physical inventory data, View Results, Run comparison
d. View Results, Enter Physical inventory data, Run comparison
e. View Results, Run comparison, Enter Physical inventory data

48. Which of the following is not a valid Asset Book in Fixed Assets module?
a. Corporate Book
b. Tax Book
c. Depreciation Book
d. Budget Book
e. None of the above

49. Among the following, which one is first step in India Localization?
a. Define TDS Sections
b. Supplier Additional Information
c. Regime Registration
d. Tax Names
e. Invoice Tolerances

50. Which of the following is NOT a valid TDS threshold limit in India Localization?
a. Single
b. Cumulative
c. Single and Cumulative
d. Amount Ranges
e. None of the Above

51. BOE Agent is Optional while entering Bill Entry Invoices?
a. Yes
b. No

52. PLA invoices can be updated with Acknowledgement Date after saving PLA entry in PLA invoice window.
a. Yes
b. No

53. Sale Tax Concession Form can be issued immediately after entering and saving Supplier Invoice.
a. Yes
b. No

54. Which of the following information is NOT used by Oracle Assets in India Localization for calculating depreciation as per IT Act?
a. Block of assets
b. Date Placed In Service
c. Date of Acquisition
d. Applicable Depreciation Rate %
e. Depreciation Rate

55. Excise Registers are updated based on ___________ in the Bond Register Setup used for transaction?
a. Transaction Source
b. Transaction Type
c. Transaction Date
d. Transaction Currency
e. Exchange Rate