Oracle Release 12.1 Documentation Library

Oracle Library 

Below is the Oracle Library Link for Oracle R.12, You can get all the documentation that is required. 

http://docs.oracle.com/cd/B53825_08/current/html/docset.html

http://docs.oracle.com/cd/B53825_08/current/html/docset.html

For more details please visit http://www.oracle.com/
                                                 http://docs.oracle.com/

Add or delete segments to an existing accounting flexfield structure

Oracle ebusiness  suite>Oracle Financial> Oracle General Ledger (GL)

QUESTION OF THE DAY!!  

                

Module: Oracle GL

Question:  Can you add or delete segments to an existing accounting flexfield structure?

No. This will cause data inconsistencies and data corruption. Development and Support do not support changes to the accounting flexfield. Changing your flexfield definition once you have used it to acquire data can cause serious inconsistencies with existing data, which could cause data corruption. 

Update segment qualifiers or rollup groups for an existing value

Oracle ebusiness  suite>Oracle Financial> Oracle General Ledger (GL)

QUESTION OF THE DAY!!  

                

Module: Oracle GL

Question:  How do you update segment qualifiers or rollup groups for an existing value?

You need to unfreeze all flexfields that use the value set. Then you should be able to update the values. See Note 1015950.600 for detailed steps and scripts to find the flexfields that use a particular value set.  

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/

Oracle Interview Question - Oracle Receivables

Oracle E-Business Suite > Oracle Financial > Oracle Interview Questions

Interview Questions on Oracle Apps AR module – Functional

.

1. How many Address’s can have one Customer?
Primary Address, Bill – To – Address, Ship – To – Address

2. Customer Number Always Automatic / Manual?
Any thing Either Manual or Automatic

3. What are the Mandatory Address’s you should create a Customer for Communicate him?
Remit – To – Address

4. Can U Merge the Customers? If How?
Using the Merging Customer Window

5. What is Accounting Rules?
It is For Generating Revenue Recognition Programs like Monthly, Quarterly

6. What is Invoicing Rules?
The Invoicing Rules Helps you when you receive data from Outside systems like Auto Invoices how the data should insert and It contains 2 rules Advance Invoice, Arrears Invoice.

7. Where should the customers send the payments of Invoices?
Remittance Banks or Vendor Places

8. What is the Transaction Type?
It describes us whether you want transfer the Receivables data into General Ledger or not. And also whenever you create an invoice what are the accounts should be effected and also the sign of Transaction also.

9. What is a Transaction Source?
It is For Invoice or Invoice Batch numbers whether automatically or manually

10. How many Transactions we have?
Six, Credit Transactions: Invoice: Debit Memo: Charge back: Guarantee: Deposit

11. How can i reduce the Invoice amount?
Using with Credit Transactions

12. What are the Accounts to be use in Transaction Types (Few)?
Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled.

13. How can i Assign a Deposit amount to an Invoice?
In the Invoice Window “Commitment” Region

14. What is the Guarantee?
It is agreement between both sides for goods or services in the future, specific range of periods

15. Give the Navigation for Credit Transactions?
Transactions/Credit Transactions

16. How many ways you can apply the Receipt Amount?
Application: Mass Apply

17. How will you know a Customer Balance Amount?
Using with the Customer Account Overview window

18. Can U Define Customer Agreements using with AR?
No, In the Oracle Order Entry Module

19. What are Aging Buckets?
It is for Outstanding Reports purpose the no of days in various ranges

20. How will U View the Outstanding Balance of a Customer?
Generating the Aging Buckets Report

Customer interface tables in Oracle Applications

Question of the Day!!  

                

Module: Oracle Accounts Payables

Question:  What are various customer interface tables?

ANS:   Following are the Customer Interface tables in Oracle applications. 

        RA_CUSTOMERS_INTERFACE_ALL

        RA_CUSTOMER_PROFILE_INT_ALL

        RA_CUSTOMER_BANKS_INT_ALL

        RA_CUST_PAY_METHOD_INT_ALL

        RA_CONTACT_PHONES_INT_ALL 

Top 20 Common Interview Questions

Top 20 Common Interview Questions and Answers

1. Tell me about yourself.
This is probably the most asked question in an interview. It breaks the ice and gets you to talk about something you should be fairly comfortable with. Have something prepared that doesn't sound rehearsed. It's not about you telling your life story and quite frankly, the interviewer just isn't interested. Unless asked to do so, stick to your education, career and current situation. Work through it chronologically from the furthest back to the present.

2. Why are you looking for another job (or why did you leave your previous job)?
On the surface, this appears to be a simple question, yet it is easy to slip. I would suggest not mentioning money at this stage as you may come across as totally mercenary. If you are currently employed, you can say it's about developing your career and yourself as an individual. If you are in the unfortunate position of having been downsized, stay positive and keep it brief. If you were fired, you should have a solid explanation. whatever your circumstances, do not talk about the drama but remember to stay positive.

3. What do you know about this organization?
Do your homework prior to the interview. Doing the background work will help you stand out. Find out who the main players are -- have they been in the news recently? You're not expected to know every date and individual but you need to have a solid understanding of the company as a whole.

4. Why do you want this job?
This question typically follows on from the previous one. Here is where your research will come in handy. You may want to say that you want to work for a company that is x, y, z, (market leader, innovator, provides a vital service, whatever it may be). Put some thought into this beforehand, be specific and link the company's values and mission statement to your own goals and career plans.

5. Who are our main competitors?
This shows you really understand the industry and the main players. Think about a few and say how you think they compare (similarities, differences). This is a good opportunity to highlight what you think are the company's key strengths.

6. What would your previous co-workers say about you?
This is not the arena for full disclosure. You want to stay positive and add a few specific statements or paraphrase. Something like "Joe Blogs always mentioned how reliable and hard working I was" is enough.

7. How do you handle stressful situations and working under pressure?
There are several ways of addressing this one. You may be the sort of person that works well under pressure; you may even thrive under pressure. Whatever the case, make sure you don't say you panic. You want to give specific examples of stressful situations and how well you dealt with them. You may also want to list a few tools you use to help you, such as to-do lists, etc. It is alright to say that you will ask for assistance when the job is more than what you can handle. It is equally acceptable to say that you work best under pressure if this is indeed the case and relevant to the particular role.

8. Are you applying for other jobs?
If you are serious about changing jobs then it is likely that you are applying to other positions. It is also a way of showing that you are in demand. Be honest but don't go into too much detail; you don't want to spend a great deal of time on this. If asked about names of who you have spoken to, it is absolutely legitimate to say you prefer not to disclose that information at this stage.

9. What are you like working in a team?
Your answer is of course that you are an excellent team player; there really is no other valid answer here as you will not function in an organization as a loner. You may want to mention what type of role you tend to adopt in a team, especially if you want to emphasize key skills such as leadership. Be prepared to give specific examples in a very matter of fact sort of way.

10. What sort of person do you not like to work with?
This is not an easy one as you have no idea whom you would be working with. Even if you can immediately think of a long list of people who you don't like to work with, you could take some time to think and say that it's a difficult question as you have always gotten on fine with your colleagues.

11. What is your greatest strength?
This is your time to shine. Just remember the interviewer is looking for work related strengths. Mention a number of them such as being a good motivator, problem solver, performing well under pressure, loyal, positive attitude, eager to learn, taking the initiative, attention to detail. Whichever you go for, be prepared to give examples that illustrate this particular skill.

12. What is your biggest weakness?
This is a challenging question -- as if you have no weaknesses you are obviously lying! Be realistic and mention a small work related flaw. Many people will suggest answering this using a positive trait disguised as a flaw such as "I'm a perfectionist" or "I expect others to be as committed as I am." I would advocate a certain degree of honesty and list a true weakness. Emphasize what you've done to overcome it and improve. This question is all about how you perceive and evaluate yourself.

13. What has been your biggest professional disappointment/achievement so far?
If asked about disappointments, mention something that was beyond your control. Stay positive by showing how you accepted the situation and have no lingering negative feelings. If asked about your greatest achievement, choose an example that was important to you as well as the company. Specify what you did, how you did it and what the results were. Ideally, pick an example that can relate to the positions you are applying for.

14. What kind of decisions do you find most difficult to take?
There is no right or wrong answer here. The logic behind this type of question is that your past behaviour is likely to predict what you will do in the future. What the interviewer is looking for is to understand what you find difficult.

15. Tell me about a suggestion that you have made that has been successfully implemented.
Here the emphasis is on the implemented. You may have had many brilliant ideas, but what the interviewer is looking for is something that has actually materialized. Be prepared to briefly describe how it went from an idea to implementation stage.

16. Have you ever had to bend the rules in order to achieve a goal?
Beware of this type of question! Under no circumstances is it necessary to break company policy to achieve something. Resist the temptation to answer and give examples, as what the interviewer is looking for is to determine how ethical you are and if you will remain true to company policy.

17. Are you willing to travel or relocate if necessary?
This is something you need to have very clear in your mind prior to the meeting. There is no point in saying yes just to get the job if the real answer is actually no. Just be honest as this can save you problems arising in the future.

18. Why should we hire you?
This is an important question that you will need to answer carefully. It is your chance to stand out and draw attention to your skills, especially those that haven't already been addressed. Saying "because I need a job" or "I'm really good" just won't cut it. Don't speculate about other candidates and their possible strengths or flaws. Make sure you focus on you. Explain why you make a good employee, why you are a good fit for the job and the company and what you can offer. Keep it succinct and highlight your achievements.

19. Regarding salary, what are your expectations?
This question is always a tricky one and a dangerous game to play in an interview. It is a common mistake to discuss salary before you have sold yourself, and like in any negotiation, knowledge is power. Do your homework and make sure you have an idea of what this job is offering. You can try asking them about the salary range. If you want to avoid the question altogether, you could say that at the moment, you are looking to advance in your career and money isn't your main motivator. If you do have a specific figure in mind and you are confident you can get it, then it may be worth going for it.

20. Do you have any questions for us?
This one tends to come up every time. Have some questions prepared. This will show you have done some research and are eager to know and learn as much as possible. You probably don't want to ask more than three or four questions. Try and use questions that focus on you becoming an asset to the company. A generic question might be "how soon can I start if I were to get the job." Another idea is to ask what you would be working on and how quickly they expect you to be able to be productive. Remember to ask about next steps and when you can expect to hear back.

Bare in mind that the interview starts from the minute you walk into the building until you leave and are out of sight. Don't think that just because you have left the meeting room, you are "off the hook." You need to maintain an image of confidence, enthusiasm, competence, reliability and professionalism throughout.

Month End Closing - Oracle Fixed Assets

Oracle Fixed Assets

Oracle Fixed Assets Month End closing 

Complete the entire pending asset to be added in the asset book through mass addition or manual.

Complete All Transactions for the Period Being Closed

You need to ensure that all transactions have been entered for the period being closed. Once a depreciation period in Oracle Assets has been closed, it cannot be re-opened. Check that no-one is entering transactions as Oracle Assets prevents transaction data entry while the Depreciation Run Process is running. You need to complete all transactions for Oracle Assets:

Prepare and Post Mass Additions

Complete Manual Additions

Complete Adjustments

Complete Retirements

Complete Transfers

Then if you required, you need to assign distribution lines to all assets.

If an asset has not been assigned to a distribution line, the period end Depreciation Process will not complete, and will not close the period. Take the advantage of running "Assets Not Assigned to Any Cost Centers Listing” report to determine which assets have not been assigned to a distribution line.

3. Run Calculate Gains and Losses

This is optional, the Calculate Gains and Losses program for retirements can be submitted prior to running depreciation. The Calculate Gains and Losses process is performed independently for each depreciation book.

4. Run the depreciation

Run depreciation, you have two option you can run depreciation without closing Period and run depreciation with Period closed.

Note: Once FA period closed it can’t be open.

5. Create accounting

Run Create Accounting program and transfer journal entries to GL.

A - Create Accounting and Transfer to GL:

·         Run The Depreciation (Draft)

Run the depreciation (Draft) after adding the assets into asset book. Calculate Gains and Losses concurrent request automatically run with the depreciation and Journal Entry Reserve Ledger Report.

Analyze the Gain and Loss report and Journal Entry Reserve Ledger Report.

·         Run The Depreciation (Period Close)

Run the depreciation (Period Close) after Running and analyzing the draft depreciation.

·         Create Accounting – Assets

After the period close and run the final depreciation run create accounting program to create accounting for fixed assets.

·         Transfer to GL Report

For transfer entries to GL run this report.

B – Reconciliation with GL:

·         Subledger Period Close Exceptions Report

Run Subledger period close report to see the exceptions in the module during the period. Due to that accounting is not created or transactions still not transfer to GL.

Reconciliation reports:

·         Account Analysis Report – Sub ledger

·         Trail Balance

How to reconcile oracle inventory

How to reconcile oracle inventory: