Top 29 Oracle Iexpense Interview Questions
Q1. How To Derive The Coconut Number For The Expense Which Contains The Project Accounting Data?
There is venture accounting generator that is answerable for information the entire cost of fee for the bills. The definition of the accounting is hooked up with the kind of rate that's gift inside the setup of rate template form and this is the principle motive why it is unnoticed.
Q2. What Can Be The Possible Reason For The Failure Of The Expense Report?
Ideally the principle motive of the problem is due to the record of the price which as in advance rejected with purpose “No Exchange Rate”. To make sure that solution is applied in a proper manner, it's miles vital to first create a outline for the alternate fee which desires to be legitimate. The alternate charge ought to be related to the rejected report of fee. Then it's far essential to re-run once more the complete software and migrate the final answer which might be suitable to different surroundings.
Q3. When The Expense Report Is Not Entered Through Oie Which Is Not Viewable In The Payable Application In The Entry That Is Made Invoices=>access=>cost Reports Form. Can You Explain What Shall Be
Certainly, when you go from the oracle iexpense mini percent 11IE.K and the applications that get releases onwards, you need to understand that oracle will not henceforth help the payable cost document of the audit activities. However, to available the capabilities of 11i.OIE.J, it's far critical for the Oracle to aid the price record shape for the access sports that are virtually made for the costs. Besides, there can also be no in addition enhancement of the capabilities that could be made to the price reviews shape present in the Oracle payable.
Q4. Is It Possible For Managers To Approve Or Reject The Individual Expense?
It is virtually no longer feasible for the managers to try this as they are given obligation to approve the entire document fee of the entire organization.
Q5. 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 nowadays’s time of digitalization, you could relive for the fact that there may be the exception data possible to be regarded on-line. For this, you need to go to the tab known as Expenses Export which is to be had in the Expenses Auditor obligations. Besides, such sort of result is available in different question pages which incorporates internet price auditor then price export then comes the export effects.
Q6. Can You Explain The Reason Of Why The Default Doe Of Tax Is Not As Desired On The Detail Page In The Internet Expense?
To make sure the preferred solution is nicely applied, it's miles vital to execute the stairs along with:
Log in as a payable supervisor in which the obligation to operate the unit with this problem is givenThen navigate the Setup -> Tax -> E-Business Tax Home. To call the project, you can preserve it as ‘Create Application Tax Options’, in which you want to go to the venture segment.
Q7. Explain The Term Asset Number Generation?
In the system, there is asset range which mechanically receives created one by one. There also are times which it subsequently skips the sequence. Suppose, there's a near period with the final asset wide variety say 326 and if we come up with the next length, you get the asset quantity say 32@This me there was one asset that is omit this is 327 and 32@There also can be times whilst with out even getting up the new number, you'll have to near the length. So make it a factor which you cautiously understand the asset range era idea and then use it similarly.
Q8. Does Iexpense Works With Some Other Applications, If Yes What Is The List?
There are different kinds of alternatives along with oracle payable, projects, grant account, approval management and alertness framework to call a few. Before running it with any other application, it is important to apprehend whether it may paintings and be like minded with it or no longer. This would keep your valuable time.
Q9. What Are Different Workflow Process Which Is Associated To Iexpense?
There are five distinct workflow system which incorporates fee holds, costs normal, credit playing cards, rate analysis and rate receipts to name some. Such form of option is counseled to make sure paintings go with the flow is achieved in a clean way that too with none type of issue.
Q10. What Is The Setup Process For Credit Card?
To make sure credit card software is mounted then definition of program and accounting is performed. Furthermore it also will increase growing the matching rule for employee and ensuring that credit score card all of the guidelines set is nicely defined.
Q11. Is There Any Minimum Support Patch Set Which Is Used For Oie 11i?
Yes, actually there is a help patcheset . It is generally the baseline patchset that's want for the OIE 11i which is 11 i.OIE. K. @However there wishes to be application of the patch on 11i.OIE.K.
Q12. Are There Any Concurrent Programs And Forms That Have The Use Of Credit Cards, If Yes Then What Are They?
Yes virtually there are alternatives to be had by means of the call of validation report, traction loader, incredible costs record, and bill interface to call some. To use them, typically two forms of home windows are used specifically Credit Card Programs window and Credit Cards window. If you're planning to apply it as part of kind of expenditure, then one has to keep in mind that it needs to be installation to the class of "Expense Reports".
Q13. What Is The Reason That Allocation Of Protect Expenditure Org Field Appears To Be Restrictive To 30 Char?
It is the R12 OIE allocation that's purpose but the fix for such type of worm remains a part of Patch 6251856.
Q14. Can You Explain The Reason Of Apxxxeer Gl Account Which Would Be On The First Line Nulled When You Would Shift To The Next Line?
Generally it's far the 6153249 computer virus account which creates the distance after the first of all entry that is made inside the guide rate report. However, there is a superb fixation of such malicious program to be had.
Q15. What Is Oracle Cursor : Implicit & Explicit Cursors?
There are some work areas which is referred to as non-public SQL. Personal SQL is utilized by Oracle to create the SQL declaration. PL/SQL allows to identify each e=paintings that is used it's far referred to as Cursor. For any sort of question which is associated with returning to a unmarried row, it's far essential to claim the implicit cursor. For the queries or issues which can be associated on returning to greater than a unmarried row, the cursor required the statement of explicitly.
Q16. Is It Possible To Use The Purchasing The Approval Hierarchy For The Expense Approval Process?
Certainly, it isn't always viable to try this which cannot be used for the approval method of the expense.
Q17. Can You Explain Me The Distinction Between The Purchase Req Which Would Be Made Through The Module Of Oracle Po?
The use of Purchase Req is made via bureaucracy while the use of iProc is made thru the net web page.
Q18. Can You Help Me Know The Generic Programs That Can Be Used For Loading And Validating The Credit Card Traction Data From Different Processors?
It is used with the ideal mixture of load and validating concurrent applications which includes Mastercard CDF traction loader and application of validation, Mastercard CDF3 traction loader, American express traction loader and application of validation, Diner’s membership traction loader and application of validation, US Bank visa traction loader and application of validation to call some.
Q19. What Can Be The Specific Reason To Use Requisitions Iprocurement Which Is Often Compared With The Oracle Po?
The main motive that iProc is cautioned due to the fact it's far a user pleasant solution and GUI that is any other solution that includes lot of capabilities that you'll be able to explore at the time of checkout.
Q20. How To Fix The Gps That Generally Occurs In The Asset Number Generation?
There are instances when in spite of vehicle era of Asset wide variety, there would be few talents. At such factor of time, you could create a manner out to replenish the gaps. The fixation requires the check that wishes to be made on the table known as Fa_distribution_history. It would provide you with a clean idea on which all are the lacking gaps and therefore you can trace it to evaluate where it's miles created be it in FA or PA.
Q21. If Oie Is Enabled For The Ame Then Are There Any Kind Of Signing Limits Which Can Be Defined Within The Product That Are Payable?
It is not feasible since the workflow of the AME technique will not make the complete utilization as there are OIE that restricts down the signing restrict facts. That is the primary motive why cost does no longer need to be entered as part of setup within the applications which might be payables.
Q22. Know The Difference Between Credit/tour Card And Pcard Function?
Often it will become difficult in the principles which are credit card capability and the capability of the procurement card. Since both the tow features depends on different self provider, tables, user interface, workflow manner and even the processing window, you may count on the distinction between the 2 in a much wider manner.
Q23. Know Different Ways To Enter The Expense If There Are Any?
Ideally, you may do it in guide foundation that is categorized into matters this is imported it from the spreadsheet template and then imported it from a credit card issuer.
Q24. Is There Any Specific Way To Configure Expense Report Numbers?
There is no hard and rapid rule to configure the rate document numbers. However, to configure the cost record range along with customise the expense report quantity format, you want to include the things which includes employee identity and the expense date record that changed into submitted in advance. To make certain this procedure goes in a clean way, you need to create the customise choice of the price file for which it is essential to adjust the plsql function.
That's AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice.You cana lso use the Internet Expenses source for the current numbering series which is AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice. The location of this function is present in the directpry of $AP_TOP/patch/a hundred and fifteen/square/apwcstmb.Pls. That you can locate easily.
Q25. Is There Any Kind Of Iexpense Main Table Which Is Present In R 12?
Yes there may be it consists of:
AP_EXPENSE_REPORTS_ALL
AP_EXPENSE_REPORTS_HEADERS_ALL
AP_EXPENSE_REPORTS_LINES_ALL
AP_EXPENSE_REPORTS_PARAMS_ALL
Understand that such sort of answer desires to be properly understood and then pass beforehand. Since, a unmarried mistake in it will now not be capable of make the assignment run well.
Q26. What Are The Ways To Create The Cc Traction?
There are multiple ways that can be used for creating the payment of CC traction. It consists of the charge to be made for the credit score card business enterprise which incorporates the position of worker. Then comes the fee to be made to the credit score card business enterprise which incorporates the position of company. There is likewise the problem of fee to be made to the credit card organisation which incorporates the function of each worker and the company.
Q27. Define Iexpense?
It is an exciting concept and an internet device that is mainly designed for filing and make sure that fee of the commercial enterprise is properly processed for the school and body of workers.
Q28. Could You Explain The Purpose Of Approval Hierarchy In Iexpense?
If there may be a profile alternative that is known as as “AME: Installed” and if its mode is about to ‘YES’ then it is viable to create the guidelines for approving up the installation within the phase of Oracle approval control. But if the setup is already no then you may have to use the approval process of manager or the employee for outcomes.
Q29. What Is The Reason Of Rejection Of Expense Report Which Is Generally Due By The Expense Report Exporting?
It is critical to put in force the answer which includes the stairs including payable needs to be lo in
Then navigation needs to be set Setup -> Lookups -> Purchasing
Then type ‘VENDOR TYPE’
During this technique, it's miles essential to make sure that the employee code is not quit dated and is nicely enabled.

