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
Sunday, July 26, 2015
Monday, July 13, 2015
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/
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
Primary Address, Bill – To – Address, Ship – To – Address
2. Customer Number Always Automatic
/ Manual?
Any thing Either Manual or Automatic
Any thing Either Manual or Automatic
3. What are the Mandatory Address’s
you should create a Customer for Communicate him?
Remit – To – Address
Remit – To – Address
4. Can U Merge the Customers? If
How?
Using the Merging Customer Window
Using the Merging Customer Window
5. What is Accounting Rules?
It is For Generating Revenue Recognition Programs like Monthly, Quarterly
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.
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
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.
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
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
Six, Credit Transactions: Invoice: Debit Memo: Charge back: Guarantee: Deposit
11. How can i reduce the Invoice
amount?
Using with Credit Transactions
Using with Credit Transactions
12. What are the Accounts to be use
in Transaction Types (Few)?
Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled.
Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled.
13. How can i Assign a
Deposit amount to an Invoice?
In the Invoice Window “Commitment” Region
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
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
Transactions/Credit Transactions
16. How many ways you can apply the
Receipt Amount?
Application: Mass Apply
Application: Mass Apply
17. How will you know a Customer
Balance Amount?
Using with the Customer Account Overview window
Using with the Customer Account Overview window
18. Can U Define Customer Agreements
using with AR?
No, In the Oracle Order Entry Module
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
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
Generating the Aging Buckets Report
Wednesday, July 8, 2015
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
Oralce Month End Closing - Oracle Inventory
Oracle Inventory
B –
Run Subledger Period Close exception report:
Month End Closing Process- Oracle Inventory
Following is the month end closing process of Oracle Inventory
A - Create Accounting and Transfer to GL:
Run the create accounting for Cost
management and check the output file for the following.
- Create Accounting
- Journal Import
B –
Run Subledger Period Close exception report:
Run Subledger period close exception
report to check the exception in this report.
Check the exceptions and resolve the issue.
Check the exceptions and resolve the issue.
C- Reconciliation:
Inventory Reconciliations
|
||
For the month of Feb-15
|
||
Opening balance as on 1 Feb 2015.
|
Inventory material Value
report
|
XXX
|
ADD:
|
||
Receipts ( PO Receipt )
|
Goods Receiving Detail
Report
|
XXX
|
Misc Receipts
|
Inventory Transaction
Register
|
XXX
|
Total Receipts
|
||
LESS:
|
||
Issuance
|
Item Issue Detail
|
XXX
|
Misc Issuance
|
XXX
|
|
Closing Balance as on 28 Feb2015
|
Inventory material Value
report
|
XXX
|
As per Report -
|
GL Trail Balance
|
XXX
|
Diff
|
XXX
|
|
Subscribe to:
Posts (Atom)