ORACLE GENERAL LEDGER

 

ORACLE GL CONCEPTS:

Before any system can be used, it has to be "set up". Hence usage follows setup. This is something common. Therefore before the module GL becomes financials; it must be set up.

Oracle General Ledger is a complete financial management system for recording transactions, maintaining account balances and creating financial statements.

A) VALUE SETS

The value set contains a predefined name which contains information regarding segments, viz., the data type for the segment, maximum size of the segment (not more than 25 characters) minimum and maximum values of the segments. Value set is required to ensure that there is consistency as regards codes used. For the consistency a set of regulating rules have to be recorded. These rules ensure that only the values testing positively against these conditions are accepted. It is a group of values and related attributed you assign to a key flexfield segment or descriptive flexfield segment.

Note: For each segment there should be a separate value set.

VALIDATION TYPES FOR VALUE SETS

1. INDEPENDENT: It is an individual value set and there is no relation to this value set.
2. DEPENDENT: This value set always depends on an independent value set.
3. TABLE: This value set is used for retrieving the data or values existed in a table by using select statements.
4. NONE: Values cannot be stored by using this value set. During the transaction level values are entered.
5. PAIR :
6. SPECIAL: These value sets are used for descriptive flexfields.

FIELD: It is an area where data can be entered, updated and from where it can be deleted.

FLEXFIELD: A flexfield is a field made up of sub fields or segments. A flexfield appears on your forms as a pop up window that contains a prompt for each segment. Each segment has a name and a set of valid rules.

There are two types of flexfields.

1. Key Flexfield: The flexfield used for pinpointing accurate information are called key flexfields. It is made up of segments where each segment has both a value and a meaning, so we can think of flexfield as an intelligent field that business can use to store information represented as codes.
2. Descriptive flexfield: The flexfield used for describing an entity is termed as descriptive flexfield. According to the business requirements, descriptive flexfields are used to expand oracle application or to customize the same. It enables to capture additional information from the transactions.

Accounting Key Flexfields:

The OGL module contains only one key flexfield " accounting key flexfield', which will give us the financial information like how the data will be entered, how to generate reports, viz., financial statements. Without writing any program-codes, it can be customized as per business requirements.

Structure: The combination of segments with value sets is called as a structure.

B) SEGMENT

Segment is a single sub field within a flexfield. You can define the structure and meaning of individual segment when customizing a flexfield. It is also a part of the organization where information regarding division, region, company, product, department, etc., can be stored.

Organization

Company

Department

Accounts

In GL module, there should be a minimum of 2 segments (company & accounts) and a maximum of 30 segments.

VIEW: Using the view name, the rest of the modules of oracle application can be mapped for reports.

ALLOW DYNAMIC INSERT [check box]: It allows the user to enter a new unique code combination required. (It can be expanded as required).

Segment separator: They are . : - . Using segment separators the code combination values can be identified.

Freeze Flexfield definition: After enabling this checkbox, the structural information cannot be modified. For modifying information the checkbox has to be disabled.

Compile (push button): Once the freeze flexfield checkbox is enabled, the compile push button is activated. This push button will create the code combinations and flexfield view for the flexfield structure. After clicking the compile push button, the system will provide the user a "request".

Request: It is the feedback information from the server. It finds the status of your structure and whether the program is successfully compiled. For knowing about the request status the following path is to be used. View – request.

We have 4 statuses of the request:

1. Stand by
2. Running
3. Pending

• Error
• Warning
• Inactive
• No manager

4. Completed

C] QUALIFIERS

Qualifiers are words that explain the functions performed by a particular segment. There are four flexfield qualifiers provided by oracle for accounting flexfields. They are:

• Balancing segment
• Cost center segment
• Natural accounts
• Inter-company adjustment

Balancing Segment: The balancing segment qualifier is to be assigned to the company segment or enterprise segment or corporation segment. This assignment ensures that the debits at the company level are equal to the credits by compiling with the matching principle of accounting.

Cost Center Segment: The cost center segment qualifier allows us to draw special readymade reports provided by the module oracle assets. The use of it is high utility. Cost center assignment pertains to the fixed assets. Use of cost center qualifier is not mandatory, it is optional. By attaching this qualifier to any segment, income and expenditure of any cost division can be found out viz., department-wise, division-wise, cost is basically incurred at department / division.

Natural Accounts: This qualifier allows the user to specify the account types. The standard account types provided are:

Expenses

Revenue

Assets

Liabilities

Ownership / stockholders' equity

Inter-company adjustment: For adjustment of inter-company transactions, this qualifier is used. It is not mandatory.

Segment Qualifiers:

1. Allow Posting: By attaching this qualifier at any segment, the journals will be allowed to post at that segment level.
2. Allow Budgeting: Budgets will be prepared at segment level when this qualifier is attached.
3. Account Type: The account types, viz., expenses, revenues, assets, liabilities, stockholder / ownership describes the type of account. In addition to 'allow posting' and 'allow budgeting', this qualifier is also attached to accounts.
4. Reconciliation Flag: For account segment to reconcile the accounts with any sub accounts.
5. Control account: For controlling the sub accounts, if any.

D] CURRENCY (Define or enable)

Code Description Territory (country) Precision

INR Indian Rupee India 2

USD US Dollar USA 2

AUD Australian Dollar Australia 2

(ISO has recognized approx. 240 country's currency)

Using the currency code, we can record the expenses and income of every country. Whenever, oracle application is installed, it creates all the ISO currency codes. If those defined currencies are to be used, we have to enable that currency.

Non ISO currency codes can also be created.

E] PERIOD TYPES

Period – Daily / Monthly / Quarterly

Using period types, you can divide the financial year as per requirements for reporting purposes. In a fiscal year, two calendar years are covered.

Future Period: If the user gives No1 option, one future period will be opened.

F] CALENDAR

Accounting calendar

This calendar defines your accounting periods and fiscal years in OGL. Using accounting calendar window, accounting calendars are defined. Oracle financial analyzer will automatically create a "Time Dimension" using your accounting calendar. Give a prefix to every period to identify the same.

Fiscal Calendar

Without relation to a calendar year, any yearly accounting period is called a fiscal year. If fiscal year has been defined, the user should specify the AD of termination of the year.

Calendar Year

If the calendar year has been defined, the user can specify the AD of commencement.

Transaction Calendar

Using this calendar, you can setup the business on and off days (i.e., holidays). Apart from weekly holidays, additional holidays can be included. This calendar helps to restrict the user to enter any transactions on any holiday or business off days. The financial institutions will generate average balances reports with the help of this calendar.

G] SET OF BOOKS

A financial reporting entity that uses a particular chart of accounts, functional currency and accounting calendar, at least one set of books has to be defined for each business location.

Standard Options

Allow suspense posting

Enable average balance

Journal approval

Journal Entry tax

Budgetary Control Options

Enable Budget Control

Required Budget Journal

Average Balance options (Amount Rate Type)

QTD – Quarter To Date

PTD – Period To Date

YTD – Year To Date

EOD – End Of Day

Mandatory Accounts

Retained Earnings: The earlier period or earlier year balances will be transferred whenever the user closes the accounting period. This is a compulsory account to be created.

Suspense account: The difference in the amounts of debit and credit of the transactions will be transferred to this account. If the user, enables the 'allow suspense posting' checkbox in the standard option then this account gets activated.

Rounding off adjustment: The transaction total amounts can be adjusted (rounded off) to the nearest currency denomination and the difference is posted to this account.

Translation Adjustment account: If the user wants to translate the functional currency balances to foreign currency and if there is fluctuation in the currency rates in between the periods then the difference because of currency rates will be recorded in this account.

Reserve for encumbrance: Prepayments or anticipated expenditure is called as encumbrance. If budgets are to be prepared, this account will be created by enabling "budget control" in the budget control option.

Net Income: If the average balance option is enabled in the set of books, enabling "average balance" check box in standard options will create the net income account. This account is not to be posted manually.

Mandatory Account Chart

Code	Account Name	Allow Budgeting	Allow Posting	Type of account
M01	Retained Earnings	Yes	Yes	Stock/ownership
M02	Suspense Account	Yes	Yes	Asset/ Liability
M03	Rounding Off Difference Account	Yes	Yes	Stock/ownership
M04	Translation Adjustment	Yes	Yes	Stock/ownership
M05	Reserve for encumbrance	Yes	Yes	Stock/ownership
M06	Net Income	Yes	No	Stock/ownership

H] USER PROFILE

After defining set of books, the books will have to be assigned to a single or multiple users. After assigning the books, the user can perform and record transaction in the set of books.

I] OPEN / CLOSE ACCOUNTING PERIODS

After assigning the set of books, for recording the accounting transactions, the user should open the desired accounting period. Once the transactions are completed, the period can be closed.

The five statuses of accounting periods are:

Never Opened

Open

Future period

Closed

Permanently closed

J] DETAILS OF TABLES IN GL

Fundamental (Master) Tables:

Fnd_Applications

Fnd_ID_Flex_Structure

Fnd_ID_Flex_Code

Fnd_Tables

Fnd_Flex_Values

Fnd_ID_Value_Sets

Fnd_Columns

Base or Set Up Tables

Gl_Code_Combination (view)

GL_Set_Of_Books

STEPS FOR DEFINATION OF SET OF BOOKS

1. Define value sets

Setup: Financials: Flexfield: Validation: Sets

2. Define key flexfield segments

Setup: Financials: Flexfield: Key: Segments

3. Enter the segment values

Setup: Financials: Flexfield: Key: Values

4. Define or enable currency

Setup: Financials: Currency: Define

5. Define period types

Setup: Financials: Calendar: Type

6. Define accounting calendar

Setup: Financials: Calendar: Accounting

7. Define transaction calendar

Setup: Financials: Calendar: Transaction

8. Define set of books

Setup: Financials: Books: Define

9. Attach set of books to profile

Other: Profile

10.Sign in again

11.Open the accounting period

Setup: Open/ Close

 

R12 ORDER MANAGEMENT – WHAT’S CHANGED?

 

 

R12 ORDER MANAGEMENT – WHAT'S CHANGED

 

 

Good question. I'm in the process of figuring this out myself. However, here are a few things I do know based on my research and my recent R12 engagement.

Multiple Operating Unit Access – In 11i, a responsibility could only be tied to a single operating unit. However, in R12, responsibilities can be assigned to one or more operating units by assigning the responsibility to a security profile. This is a great enhancement for businesses where users require multi-organization access.

Credit Card Entry Enhancements - An additional field has been added to the order entry screen to capture the security code typically located on the back of a credit card. Additionally, the credit card number is encrypted at the database level and stored within the Payments (formally iPayments) module. I'll put out a more detailed article that talks about the drastic changes to the iPayments module.

Reoccurring Charges - Functionality has been added to the TSO (Telecommunications Service Ordering) module which allows reoccurring billings. This is perfect for subscriptions and other like services.

Partial Period Revenue Recognition – A joint OM and AR enhancement, partial period revenue recognition is a set of new revenue recognition rules in AR which allow for revenue recognition on a daily basis. Previously in 11i revenue recognition could only be done on a monthly basis.

Pay Now or Pay Later – Upfront billing in Order Management can now be done and can be configured based on pricing charges, taxes, deposits, installment billing, and prepayments.

Mass Scheduling Changes – The scheduling concurrent request can now pick up lines that have errored in the scheduling workflow activity. It also can now pick up lines that are in Entered status – both converted and manually entered orders.

Customer Acceptance Process - Oracle R12 now provides the ability to introduce a customer acceptance step prior to invoicing. By setting up a deferral reason in AR, invoicing can be deferred until acceptance has been captured.

Tax Updates – Additional tax fields have been added to the order entry screens that provide more flexibility with Vertex.

 

 

Architectural Changes to Inventory - in 11i, Discrete and Process Inventory modules were entirely separate entities. Oracle has converged these modules into one data structure, where functionalities from both modules have combined to be available to both. This doesn't mean much from an OM perspective, but technical changes have been performed to the Pick Release and Ship Confirmation processes to work with the new combined inventory model.

Architectural Changes to OM, Install Base, and Service Contracts Integration – My understanding is that there is no functionality changes, but from a technical standpoint Oracle has implemented a best practice approach  to OM to Install Base and OM to Service Contracts touchpoints to ensure API calls are used rather than direct queries.

 

Profile Options

A user profile is a set of changeable options that affect the way your application runs. The system administrator can set user profiles at different levels:

Site level     These settings apply to all users at an installation site.
Application level     These settings apply to all users of any responsibility associated with the application.
Responsibility level     These settings apply to all users currently signed on under the responsibility.
User level     These settings apply to an individual user, identified by their application username.

Important Profiles
1.1. HR: Business Group
1.2  HR: Security Option
1.3: HR: User Type (FOR accessing HRMS functions)
1.4  HR: Cross Business Group

2.1. GL: Set of Books(11i)
2.1  GL:%Ledger%  (R12)
2.3  GL: Data Access Set. This profile option to control the ledgers that can be used by Oracle General Ledger.

3.1. MO: Operating Unit
3.2. MO: Security Profile (R12)
3.3. MO: Default Operating Unit

4.1 Tax: Allow Override of Tax Code
4.2 Tax: Invoice Freight as Revenue
4.3 Tax: Inventory Item for Freight

5.1 Sequential Numbering
5.2 INV: Intercompany Currency Conversion

6. RCV: Processing Mode - Batch, Immediate, Online

Values set at a higher level cascade as defaults to the lower levels. Values set at a lower level override any default from a higher level. For profile options that need to differ at the operating unit level, including OE: Item Validation Organization, OE: Set of Books, and GL: Set of Books, you must set the values at the responsibility level. Oracle General Ledger windows use the GL Set of Books profile option to determine your current set of books. If you have different sets of books for your operating units, you should set the GL Set of Books profile option for each responsibility that includes Oracle General Ledger windows.

For profile options that need to differ at the set of books level, including Sequential Numbering, set the values at the responsibility level.

Profile options specify default values that affect system processes, system controls, and data entry. In a multiple organization
environment you may want to confine the effect to a specific operating unit. Therefore, you may want to change your profile options to be visible and updatable at the responsibility level.

1. MO: Operating Unit = {the users Operating Unit name}
     This points the responsibility to the appropriate Operating Unit.
This the profile which holds the value of operating unit org_id when ever user login into system his org_id is  value is transfered to profile value base on this profile  we get data and put data from databaseUsed primarily in a multiorg environment.
     Set the site level to the desired default operating  unit.
     If there is more than 1 Operating Unit Defined, this profile option must be set at the responsibility level for each responsibility.
Example: Suppose we define a responsibility Purchasing Super User US . Then MO : Operating Unit at this responsibility level determines which Opertaing unit can this responsibility(or the user assigned to this responsibility) acess.

2. OE: Set of Books and GL: Set of Books
Each Responsibility is identified with a set of books using the profile option GL : Set of Books Name, a responsibility can only see the accounting information for that set of books in orcale GL.

3. HR: Business Group
Business Group that is linked to the security profile for a responsibility. This option is used online to control access to records that are not related to organization, position, or payroll.
This option is seeded at Site level with the start-up Business Group. It is view only. Values are derived from the HR:Security Profile user profile option.

HR:Security Profile     Restricts access to the organizations, positions, and payrolls defined in the security profile. This option is seeded at Site level with the view-all security profile created for the Startup Business Group.  The business group you define appears in the list of values when you set up the HR: Security Profile profile option.

Security Groups
Security groups are a method of partitioning data. When you use the standard HRMS security model, you do not use security groups. The business group is the only data partition. Responsibilities are linked to business groups. Therefore, to access different business groups, users must change responsibilities.
If you want one responsibility to be enabled for more that one business group, you must use Cross Business Group responsibility security. In this model, security groups are defined to partition data within a business group. Multiple security groups can then be linked to one responsibility, even if they partition different business groups. To use security groups you must set the user profile option Enable Security Groups to Yes and run the Multiple Security Groups process.

HR: Cross Business Group
In the Oracle HRMS model, the business group is at the country level and a top organization encompasses all business groups in a company worldwide. People, projects, jobs, and organizations can be located in different business groups for different countries and all information can be shared throughout the enterprise.
Oracle Projects allows the visibility of all business groups to one another. For example, you can search staff resources on projects across business groups, and charge any project across the enterprise for a resource.
You control access to single or multiple business groups by setting the profile option HR: Cross Business Group:
• Set the profile option to Yes to allow cross business group access.
• Set the profile option to No to allow only single business group access.

Q. What are the main profile

Q. What are the main profile options relating to Organization setup and
what are they used for?

A. · HR:User Type = HR User
This is necessary to allow the Inventory responsibility to complete the organization setup. Setting the profile to a value of 'User' as opposed to 'Payroll & User' will restrict the Inventory user from accessing any Payroll information if Oracle Payroll is installed.

· HR: Business Group = {the users Business Group name}
This points the responsibility to the appropriate Business Group. when multiple Business Groups are defined, you must associate each responsibility with one and only one Business Group.
A responsibility can not see organization data from more than one Business Group.

· MO: Operating Unit = {the users Operating Unit name}
Used primarily in a multiorg environment. This points the responsibility to the appropriate Operating Unit. Set the site level to the desired default operating unit.If there is more than 1 Operating Unit Defined, this profile option must be set at the responsibility level for each responsibility.

 

11i vs R12

Get the Cost of an Item (API)

API to Get the Cost of an Item

Group Team

Below code can be used to get the cost of an Item.

The function returns the item cost for a given item and the organization.

All the parameter used in the Api are IN Parameter. Cost_group_id and Cost_type_id have the default value as NULL.

We can pass cost_group_id or cost_type_id, if you desire most specific cost Information. Do not pass both the cost group and Cost type at the same time.

API can fail for the below scenario

• Invalid item/organization combination.
• Item is not cost enabled.
• Item has no cost in the specified cost group or cost type.

 

DECLARE

v_inventory_item_id NUMBER := 832215;
v_organization_id NUMBER := 209;
v_api_version NUMBER := 1.1;
v_cost_type_id NUMBER;
v_item_cost NUMBER := 0;
v_cost_group_id NUMBER;
BEGIN


dbms_output.put_line('API CST_COST_API to get the Item Cost);
v_item_cost := CST_COST_API.get_item_cost
(p_api_version => v_api_version,
p_inventory_item_id => v_inventory_item_id,
p_organization_id => v_organization_id,
p_cost_group_id => v_cost_group_id,
p_cost_type_id => v_cost_type_id
);

IF v_item_cost is NULL THEN

dbms_output.put_line('Issue in getting the Item Cost and Issue can be any one specified in the error scenario of the post');

ELSE

dbms_output.put_line('Item Cost is ' || v_item_cost);

END IF;

EXCEPTION

WHEN
OTHERS
THEN

dbms_output.put_line('Error in calling api and the error is ' ||
substr(SQLERRM,
1,
200));
END;

Oracle EBS R12: General Ledger and Receivables Fundamentals 1Z0-216

Oracle EBS R12: General Ledger and Receivables Fundamentals 1Z0-216

Question: 1

AutoAccounting automatically generates accounting flexfields for Receivables transactions.

Identify four accounts generated by AutoAccounting. (Choose four.)

A. Tax

B. Freight

C. Payable

D. Discount

E. Revenue

F. Receivable

Answer: A, B, E, F

Question: 2

When you change a summary account template funds check level from none to advisory or

absolute, you must _____.

A. Do nothing else (no additional work is needed)

B. Complete the required data on the template for the new funds check level

C. Delete the original template and then re-create it for the appropriate funds check level

D. Change the time period on the template to the earliest period to identify the begin date of the

new funds check level

Answer: C

Question: 3

Choose the correct sequence of the budget accounting cycle in Oracle applications.

A) Freeze budgets.

B) Define budgets and budget organization.

C) Review and correct budgets.

D) Report on budgets.

E) Enter budget amounts.

A. E, D, C, B, A

B. B, E, C, D, A

C. A, B, C, D, E

D. E, A, B, C, D

E. B, E, C, A, D

Answer: E

Question: 4

What are the five steps for creating MassAllocation journal entries? (Choose five.)

A. Posting journal entries

B. Reviewing journal entries

C. Validating cross-validation rules

D. Freezing the accounting flexfield

E. Generating MassAllocation journals

F. Creating the MassAllocation definition

G. Validating the MassAllocation definition

Answer: A, B, E, F, G

Question: 5

John has created two ledgers: one primary and one secondary. The primary ledger stores

transactional data and the secondary ledger stores only adjustments. The secondary ledger

shares the same chart of accounts, accounting calendar or period-type combination, and

currency as the associated primary ledger. John wants to obtain a complete accounting

representation that includes both transactional data and adjustments while running reports.

Identify the best option.

A. Merge the primary ledger and the secondary ledger, and run reports.

B. Transfer adjustment data from the secondary ledger to the primary ledger while running

reports.

C. Transfer transactional data from the primary ledger to the secondary ledger while running

reports.

D. Use ledger sets to combine the adjustments-only secondary ledger with the primary ledger

when running reports.

Answer: D

Question: 6

ABC Enterprises is implementing Oracle E-Business Suite Release 12. They possess much data

relating to Assets, HRMS, Inventory, vendors, and customers. They also have budgetary control

enabled, and they have a substantial amount of budget data. They want to upload their data into

Oracle with the use of Oracle Web Application Desktop Integrator. Identify four types of data that

can be used for uploading data by using Web ADI. (Choose four.)

A. HRMS data

B. Assets data

C. Vendors data

D. Budgets data

E. Inventory data

F. Customers data

Answer: A, B, D, E

Question: 7

The GL accountant tells you that to minimize maintenance efforts, disabled account code

combinations must be automatically deleted from the budget organization periodically. At the

same time, if new account code combinations have been defined, these must be automatically

added. What would be your response?

A. The Oracle General Ledger budget functionality cannot satisfy this requirement.

B. If the client wants to do this, customization of Oracle Workflow is the only option.

C. To do this, automatically run the Maintain Budget Organization program periodically.

D. It is possible to automatically add new account code combinations, but disabled accounts must

be deleted manually.

E. It is possible to automatically delete the disabled account code combinations, but new

accounts must be added manually.

Answer: C

Question: 8

Journal creation rules in Subledger Accounting are defined by event type and event class. Identify

the event type associated with the event class of reverse.

A. Invoice

B. Receipts

C. Adjustment

D. Chargeback

E. Transactions

F. Credit memo

G. Bills receivable

Answer: B

Question: 9

Treeline Company is getting ready to complete its month-end process. It needs to create a profitand-

loss statement and wants to use the Financial Statement Generator feature to create the

report. Which two elements are required to create the report? (Choose two.)

A. Row set

B. Report set

C. Workbook

D. Column set

E. Content set

Answer: A, D

Question: 10

Your client is using Oracle Trading Community Architecture (TCA) relationship manager to create

and manage relationships among parties. However, your client is having difficulty understanding

circular relationship types. Select two examples of circular relationships. (Choose two.)

A. Company H is an affiliate of company G.

B. Company A is the parent company of company B and company C.

C. Company J is a subsidiary of company K and company L is a division of company K.

D. Company M is a shareholder of company N and company N is a shareholder of company P.

E. Company D is a competitor of company E, which is a competitor of company F, which in turn is

a competitor of company D.

Answer: A, E

Question: 11

Your client has requested that you set up gapless numbering for its invoices. In your testing, you

realized that the numbers for deleted invoices were missing from the sequence. How would you

prevent that problem?

A. Reuse deleted invoice numbers.

B. Do not allow deletion of invoices.

C. Create a custom report listing deleted invoice numbers.

D. Select Show Deleted Invoice Numbers in your system options.

Answer: B

Question: 12

The accounting setup process in Oracle General Ledger consists of three main steps. (Choose

three.)

A. Update accounting options.

B. Approve accounting options.

C. Complete the accounting setup.

D. Create an accounting setup structure.

Answer: A, C, D

Question: 13

ABC Enterprise closes its books on March 31st. These activities have been identified to be

performed for the closure of books.

1) post

2) translate

3) review

4) consolidate

5) revalue

6) run accounting reports

7) close accounting period

In which order must these activities be performed?

A. 1, 3, 5, 2, 4, 6, 7

B. 5, 2, 3, 1, 7, 4, 6

C. 1, 5, 2, 3, 4, 7, 6

D. 1, 3, 2, 5, 7, 4, 6

Answer: A

Question: 14

The GL accountant tells you that he has defined two budgets. After selecting the budget

organization in the Enter Budget Amounts form, he can select only one budget from the list of

values (LOV). What would be your response?

A. The budget status is current.

B. The last fiscal year of the budget is closed.

C. The first fiscal year of the budget was never opened.

D. Accounts must be reassigned to the budget organization.

Answer: C

Question: 15

There are several setup steps for receipts in Oracle Receivables; some are required whereas

others are optional. Which two setup steps are optional? (Choose two.)

A. Define receipt classes.

B. Define receipt methods.

C. Define receipt sources.

D. Define AutoCash rule sets.

E. Define application rule sets.

Answer: D, E

Question: 16

Your manager has asked you to create a period close process that maximizes the efficiency of

your two staff members and minimizes the number of closing days. Identify two sets of

subledgers that can be closed concurrently. (Choose two.)

A. Payables and Assets

B. Projects and Payables

C. Inventory and Receivables

D. Payables and Receivables

E. Order Management and Projects

Answer: D, E

Question: 17

When you assign a template to a rule in Bill Presentment Architecture, you enter a range of ___.

A. Data sources

B. Transaction types

C. Transaction dates

D. Customer accounts

Answer: C

Question: 18

Ten analysts are assigned the same Receivables responsibility and are given their own logins.

The requirement is to restrict three of the analysts from creating chargebacks or adjustments.

What would be your advice to ensure compliance with this internal control?

A. Use forms personalization to restrict function access.

B. Set the "AR: Cash - Allow Actions" system profile to no at the responsibility level.

C. Set the "AR: Cash - Allow Actions" system profile to no at the user level for the three analysts.

D. Set the "AR: Cash - Allow Actions" system profile to yes at the user level for the three analysts.

E. Set the "AR: Cash - Allow Actions" system profile to yes at the application level for the three

analysts.

Answer: C

Question: 19

Which three statements are true about mapping rules? (Choose three.)

A. You can define account rules.

B. You can define segment mapping rules.

C. You can modify your rollup rule after it has been saved.

D. You can define segment or account rules, but not a combination of both.

E. You can define segment rules instead of account rules for faster processing.

Answer: A, B, E

Question: 20

All receipts that fail validation during AutoLockbox processing remain in the _____ table.

A. AR_PAYMENT_SCHEDULE

B. AR_PAYMENTS_INTERFACE_ALL

C. AR_INTERIM_CASH_RECEIPTS_ALL

D. AR_INTERIM_CASH_RCPT_LINES_ALL

Answer: B