If you're looking for Oracle Project Accounting Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Oracle Project Accounting has a market share of about 8.95%. So, You still have opportunity to move ahead in your career in Oracle Project Accounting. Mindmajix offers Advanced Oracle Project Accounting Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Oracle Project Accountant.
Q. Can you explain in detail about Burdening VS Mass Allocations
When you think of burden cost that is present in the Oracle project, understand that the prime motive of its design was to apply the overhead expenses as per the burden contracting method which traditionally government agencies in the United States. However, Oracle General Ledger Mass Allocations is known to offer the best traditional yet complete allocation of actual overhead expenses where ongoing burdening method does not exists.
Q. How to test the burden structure before processing
To test the burden structure, you need to use the window of View Burdened Costs before initiating with the processing costs. You need to have accomplished the cost along with the implementation and assigned burden schedules.
Q. What can be done if the expenditure type in a burden structure is not included?
In the oracle project, if it fails to find the expenditure type in the cost base at the time of burden process, then the expenditure item will not get burdened. Ideally, the burden cost is equivalent to the raw cost.
Q. What can be done if the expenditure type in burden cost code definition is not included?
If there is no expenditure type, then it may result to the Create and Distribute Summarized Burden Component which needs to be processed. This needs to be done since the expenditure type is said to be the key value in the expense item record.
Q. Know more about the Journal and its type?
Journal is known for recording the traction that a business doe. It includes the credit and debit lines in which debit needs to be equivalent to the credit. It is categorized into different types such as suspense journal which is also known as Unbalanced Journal, Reversal journals and Recurring Journals.
Q. Know more about the Translations & Revaluation along with its working level
Translation is used for translating the functional currency balances in the foreign currency balances that needs to be done at the accounting level. Then come the revaluation which is used for identifying the unreleased gain or loss that may occur during the currency inflation. Some of the examples can be Conversion Rate is 2, Foreign Currency is INR, or Functional Currency is USD to name a few.
Q. Could you define Security Rules and Cross validation Rules
Security rule is used for restricting the users from entering any kind of segment. While Cross validation rule is used for restricting the end user to enter the combinations of the code. Security rule works at the responsibility level while across validation rule works at the structure level.
Q. Know more about Dynamic Insertion?
It is possible for you to create a new account dynamically with the code combinations. For this, when you enter the data, it enables the dynamic insertion in the primary option to choose.
Q. What is the Difference between Standard Accrual and Standard Cash?
Standard Accrual includes Invoice and Payment Accounting while in Standard Cash only payment accounting is present. Not only this, Standard Accrual undergoes two phases. In first phase the good order is generated and received while in second phase the amount is paid for receiving the goods within the due time that is actually set by the supplier.
Q. Can you elaborate in detail about Flex field GL Qualifiers?
Generally it is assigned to the qualifiers and the individuals to make sure the definition in COA is clear. Natural Account is a type of option that should contain about the single account section which is natural. Then comes the Balancing Account where every structure needs to have the single balancing segment. There needs to be also cost center under which the section is used for the oracle asset. Furthermore, come the intercompany GL which usually uses the intercompany section in code associated with accounting.
Q. Can you help me know the difference between Primary Ledger Vs Secondary Ledger Vs Reporting Currency
Let us first compare Primary Ledger Vs Secondary Ledger in which the secondary ledger is used for the supplement purpose such as statutory reporting while primary ledger is used for corporate accounting. Moving on to the reporting currency, it is designed to maintain the corporate and statutory presentation of the legal entity transaction which needs to be parallel.
Reporting current is completely different than that of the secondary ledger which fulfills the need of supporting the reporting requirements.
Q. Define the Adjusting Period:
At the last time of the financial year which is used is known as the adjusting period. It helps in performing the adjustment and closure of the journal entries. You need to choose on including the period of adjustment or not in the calendar since it is one crucial decision that needs to be made.
Q. Can you explain different Purchase Orders (PO’s) types?
The first one that should be considered is Standard Purchase Order which is a legal detailing that is used for buying the goods and services by the supplier. The Blanket PO is another type which is used when you want to know the goods and services details. Other than this, there is Planned PO which is considered to be the agreement for long time that is used for committing in purchasing the items and services from single source. Furthermore comes the contract PO which is made when you are in agreement with the supplier on certain terms and situations.
Q. Can you explain more about 2 way, 3 way and 4 way matching?
To make the payment in 3 ways, you need to have PO ordered while in 4 way, it is important to compare different documents like PO, receipt, invoice and inspection. Furthermore, inspection will be done on those things which we have received if the 10 items get damaged.
Q. Explain in detail about the Payment Terms and how can it be defined:
Payables generally opt for the payment terms to ensure that calculation is done automatically for due date, discount date and discount amount for every invoice that is entered. If you want to make any changes in the payment terms or the one you are intending to use, understand that it will not be on the values. For this, you need to define the terms in the payment section.
Q. Can you help me know more about SWEEP Program and the process of the same?
It is one such particular type of program that runs to make sure that transfer of un-accounted invoice is done to the next opened period at the time of period end that closes with the accounts payable. Ideally you are not allowed to close the payable period, in case there is unaccounted invoice present in the payables.
Q. What is the distinguish between AP and AR invoice?
AP invoice is all about the amount that goes out to receive the original material from the seller or the supplier while AR invoice is the amount that comes in buy selling the product to the customer or parties or you can say revenues.
Q. Define Pre Payment in AP?
This type of option is all about the prepayment to be done in advance manner which is made to the supplier by the employee or the organization. It will later be applicable for the feature called debit. Such type of option is categorized into two sections one is permanent and Temporary Prepayment.
Q. Know more about Key flex filed in how many types is GL, AP, AR, & FA?
The purpose of using Key flex filed is to capture the important details of the company which I mandatory. Under GL sector, there is flex field, reporting attribute and ledger flex field of the GL, In AP section there is no flex filed, in AR there are two types which is sales tax location and territory Flex field while FA has got three types which are asset key, category, and location flex field.
Q. Can you explain the burden schedule that can be used for the project?
When you opt for the oracle project, understand that it determines which schedule can be used to calculate the multipliers such as the schedule to be made for overriding the assigned to the lower task, scheduling to be made while assigning to the project and the standard scheduling to be made for assigning to the lowest task. Generally when you look for the burden schedule option, you need to understand the three uses of it which is revenue accrual, internal costing and invoicing.
Q. Which date is used for the specific burden schedule version?
If there is a schedule type which is firm then oracle project would opt for the expenditure item date to understand which schedule is used for the burden cost calculation. But if you enter the schedule fixed date in the organization burden schedule, then the schedule fixed date is used for determining the effective burden of the schedule.
Other than this, if the schedule type turns out to be prevision, then the use of last date of GL period in the expenditure item date would fall out.
Q. Know the organization that was used for calculating the burden amount:
Generally in oracle project the use of expenditure organization is made to calculate the burden amount if the distribution overrides exists of the organization. But if you use the organization distribution overriding, the overriding to the organization is done instead of the expenditure organization.
Q. Where can be the burden cost distribution lines be seen?
It is possible to use the Expenditure Inquiry window since it helps in reviewing the burdened cost distribution lines.
Q. Why sometimes, the particular expenditure item does not get burdened?
In case, the oracle project does not distribute the cost in a proper manner or create the revenue for the expense item, then you can see the revenue rejection reason under the section of Expenditure Items window. That is when; you can use the folder option show field that displays either the Revenue Distr.
Q. What is required to add the new organization?
In you want to add a new organization, and then you need to add it to the version called Project Burdening Hierarchy.
Q. Can you explain the difference between KFF and DFF?
KFF is the unique identifier which is stored in the segment section while DFF is used for capturing the additional information that can be used later. It is stored in the attribute column.
Q. Which table get in receivable module when there is receivable interface is running from the order entry?
During this situation, there is RA_INTERFACE_LINES_ALL table which will soon get populated. Through this, AR picks the data to create the invoice with the help of “autoinvoice”. When “autoinvoice”.gets the data from ra_interface_lines_all, at the same time, it also picks up the data from the ra_interface_distributions_all and ra_interface_salescredits_all in case it is present.
Q. Can you explain the symbol of DFF in the form?
DFF in the form has the symbol of Square Bracket .
Q. Could you help me know the structure of KFF in the Accounting Flexfields?
In accounting flex field there is accounting, cost center, product, and future use.
Q. Do you know what is flex field Qualifier?
This type of qualifier is used for identifying the segments. There are different types of flex field qualifiers such as Segment of Intercompany, Cost Center segment, Balancing Segment, and Natural Account section Qualifier.