Oracle iExpense Interview Questions

If you're looking for Oracle IExpense Interview Questions for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle IExpense has a market share of about 1.2%.

So, You still have the opportunity to move ahead in your career in Oracle IExpense Administration. Mindmajix offers Advanced Oracle IExpense Interview Questions 2023. that helps you in cracking your interview & acquire your dream career as Oracle IExpense Administrator.

If you want to enrich your career and become a professional in Oracle IExpense, then enroll in "Oracle IExpense Training" - This course will help you to achieve excellence in this domain.

Best Oracle IExpense Interview Questions and Answers

1. Is it possible to use the purchasing the Approval Hierarchy for the expense approval process?

Certainly, it is not possible to do that which cannot be used for the approval process of the expense.

2. If OIE is enabled for the AME then is there any kind of signing limits that can be defined within the product that is payable?

It is not possible since the workflow of the AME process will not make the complete utilization as there are OIE that restricts down the signing limit data. That is the main reason why value does not need to be entered as a part of setup within the applications that are payables.

3. How to derive the coconut number for the expense which contains the project accounting data?

There is a project accounting generator that is responsible for understanding the total value of expense for the accounts. The definition of the accounting is attached with the type of expense which is present in the setup of the expense template form and that is the main reason why it is ignored.

4. How to get the results of the exports along with the revival of the importing and rejections when there is no Output File In R12?

In today’s time of digitalization, you can relive the fact that there is the exception data possible to be viewed online. For this, you need to visit the tab called Expenses Export which is available in the Expenses Auditor responsibilities. Besides, such type of result is available in different query pages which includes internet expense auditor then expense export then comes to the export results.

5. When you decide to review the diagnostic details of wf status is there any kind of specific node that presents the ‘FORCE’ value? 

At such time, there is APEXP that presents there are some of the unsupported use of the expedite solution that comes through the monitor of workflow.

6. Is there any minimum support patch set that is used for OIE 11i?

Yes, certainly there is a support patchset. It is generally the baseline patchset that is needed for the OIE 11i which is 11 i.OIE. K. 2. However, there needs to be the application of the patch on 11i.OIE.K.

7. When the expense report is not entered through OIE which is not viewable in the payable application in the entry that is made Invoices=>Entry=>Expense Reports Form. Can you explain what shall be behavioral which can be expected here?

Certainly, when you go from the oracle iexpense mini pack 11IE.K and the applications that get releases onwards, you need to understand that oracle will not henceforth support the payable expense report of the audit activities.

However, to available the features of 11i.OIE.J, it is important for Oracle to support the expense report form for the entry activities that are actually made for the expenses. Besides, there will also be no further enhancement of the features that would be made to the expense reports form present in the Oracle payable.

8. Know the difference between Credit/Travel Card and PCard function?

Often it becomes confusing in the two concepts that are credit card functionality and the functionality of the procurement card. Since both the two functions depend on different self-service, tables, user interface, workflow process, and even the processing window, you can expect the difference between the two in a wider manner.

9. Could you explain the purpose of the Approval Hierarchy in iExpense?

If there is a profile option which is called “AME: Installed” and if its mode is set to ‘YES’ then it is possible to create the rules for approving up the setup in the section of Oracle approval management. But if the setup is already no then you will have to use the approval process of the supervisor or the employee for results.

10. Are there any concurrent programs and forms that have the use of credit cards, if yes then what are they?

Yes certainly there are options available by the name of validation report, transaction loader, outstanding charges report, and invoice interface to name a few. To use them, generally, two types of windows are used namely Credit Card Programs window and the Credit Cards window. If you are planning to use it as a part of the type of expenditure, then one has to understand that it needs to be set up to the class of "Expense Reports".

11. Know different ways to enter the expense if there are any?

Ideally, you can do it on a manual basis which is categorized into two things that are imported from the spreadsheet template and then imported it from a credit card provider.

12. Can you help me know the generic programs that can be used for loading and validating the credit card transaction data from different processors?

It is used with the perfect combination of load and validating concurrent programs which include Mastercard CDF transaction loader and program of validation, Mastercard CDF3 transaction loader, American express transaction loader and program of validation, Diner’s club transaction loader and program of validation, US Bank visa transaction loader and program of validation to name a few.

13. What are the ways to create the CC transaction?

There are multiple ways that can be used for creating the payment of CC transactions. It includes the payment to be made for the credit card company which includes the role of employee. Then comes the payment to be made to the credit card company which includes the role of the company. There is also the complication of payment to be made to the credit card company which includes the role of both employee and the company.

14. What are different workflow processes which are associated to iExpense?

There are five different workflow process which includes expense holds, expenses regular, credit cards, expense analysis, and expense receipts to name a few. Such type of option is advised to make sure workflow is done in a smooth manner that too without any kind of issue. 

15. Is there any kind of iExpense main table which is present in R 12?

Yes, there is it includes:

* AP_EXPENSE_REPORTS_ALL
* AP_EXPENSE_REPORTS_HEADERS_ALL
* AP_EXPENSE_REPORTS_LINES_ALL
* AP_EXPENSE_REPORTS_PARAMS_ALL

 

Understand that such type of solution needs to be well understood and then move ahead. Since a single mistake in it will not be able to make the task run properly.

16. Does iExpense works with some other applications, if yes what is the list?

There are different types of options such as oracle payable, projects, grant account, approval management, and application framework to name a few. Before running it with any other application, it is important to understand whether it can work and be compatible with it or not. This would save you valuable time.

17. Explain the term Asset number generation?

In the system, there is an asset number that automatically gets created one by one. There are also times which it eventually skips the sequence. Suppose, there is a close period with the last asset number say 326 and if we come up with the next period, you get the asset number say 329.

This means there has been one asset which is miss that is 327 and 328. There can also be times when without even getting up the new number, you would have to close the period. So make it a point that you carefully understand the asset number generation concept and then use it further.

18. How to fix the Gps that generally occur in the Asset number generation?

There are times when in spite of auto-generation of Asset numbers, there would be few skills. At such a point in time, you can create a way out to fill up the gaps. The fixation requires the check that needs to be made on the table called Fa_distribution_history. It would give you a clear idea of which all are the missing gaps and thus you can trace it to assess where it is created be it in FA or PA.

19. What is Oracle cursor: Implicit & Explicit cursors?

There are some work areas which is called private SQL. private SQL is used by Oracle to create the SQL statement. PL/SQL helps to identify each e=work that is used it is called Cursor. For any kind of query which is related to returning to a single row, it is important to declare the implicit cursor. For the queries or issues that are related to returning to more than a single row, the cursor required the declaration of explicitly.

20. Is there any specific way to Configure Expense Report Numbers?

There is no hard and fast rule to configure the expense report numbers. However, to configure the expense report number such as customize the expense report number format, you need to include the things such as employee id and the expense date report that was submitted earlier. To make sure this process goes in a smooth manner, you need to create the customize option of the expense report for which it is important to modify the plsql function which is AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice.

You can also use the Internet Expenses source for the current numbering sequence which is AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice. The location of this function is present in the directory of $AP_TOP/patch/115/SQL/apwcstmb.pls. That you can find easily.

21. Can you explain the reason why the default doe of tax is not as desired on the detail page in the Internet expense?

To make sure the desired solution is well implemented, it is important to execute the steps such as:
Log in as a payable manager where the responsibility to operate the unit with this issue is given
Then navigate the Setup -> Tax -> E-Business Tax Home. To name the task, you can keep it as ‘Create Application Tax Options’, in which you need to go to the task section.

22. What is the reason for the rejection of the expense report which is generally due by the expense report exporting?

It is important to implement the solution which includes the steps such as payable needs to be lo in
Then navigation needs to be set Setup -> Lookups -> Purchasing
Then type ‘VENDOR TYPE’
During this process, it is important to ensure that the employee code is not end-dated and is well enabled.

24. What can be the possible reason for the failure of the expense report?

Ideally, the main cause of the problem is because of the report of the expense which as earlier rejected with reason “No Exchange Rate”. To make sure that the solution is implemented in the right manner, it is important to first create a definition for the exchange rate which needs to be valid.

The exchange rate must be associated with the rejected report of expense. Then it is important to re-run again the whole program and migrate the final solution which would be suitable to another environment.

25. Can you explain the reason for the APXXXEER GL Account which would be on the First Line Nulled when you would shift to the next line?

Generally, it is the 6153249 bug account that creates the space after the initial entry which is made in the manual expense report. However, there is a good fixation of such bugs available.

26. What is the reason that allocation of protecting expenditure org field appears to be restrictive to 30 char?

It is the R12 OIE allocation that is the reason but the fix for such type of bug is still a part of Patch 6251856.

27. What can be the specific reason to use requisitions procurement which is often compared with the Oracle PO?

The main reason that iProc is advised because it is a user-friendly solution and GUI is another solution that comes with a lot of features that you will be able to explore at the time of checkout.

28. Can you explain to me the distinction between the Purchase req which would be made through the module of Oracle PO?

The use of Purchase Req is made through forms while the use of iProc is made through the web page.

29. Define iExpense?

It is an interesting concept and an online tool that is specially designed for submitting and ensure that expense of the business is well-processed for the faculty and staff.

30. What is the setup process for a credit card?

To make sure the credit card program is established then the definition of the program and accounting is done. Furthermore, it also increases creating the matching rule for employee and ensuring that credit card all the policies set is well described.

31. Is it possible for Managers to approve or reject the individual expense?

It is certainly not possible for the managers to do that as they are given the responsibility to approve the whole report expense of the entire group.