bob3535
asked on
Where to find if the purchased item is an asset or something else from PO?
Hello Experts,
In Oracle Apps, Usually, we purchase an item using purchase order.
During purchasing an item, and when the goods is received, is there any place where we mention if the goods received is an "Asset" or something that is used for "Consumption(or some other word)" . If so, what is the table and the column that specifies tis situation. It can be a PO table, Receiving table or any other table.
Any help is greatly appreciated.
Thank you
In Oracle Apps, Usually, we purchase an item using purchase order.
During purchasing an item, and when the goods is received, is there any place where we mention if the goods received is an "Asset" or something that is used for "Consumption(or some other word)" . If so, what is the table and the column that specifies tis situation. It can be a PO table, Receiving table or any other table.
Any help is greatly appreciated.
Thank you
ASKER
Dear markgeer Sir,
With all due respect, I did not understand what you had mentioned in the reply.
1) I am working in the Release 11i version of Oracle Apps.
2) I have around 5 years of experience working in Oracle Applications.
3) My questions was simple. --
The functional requirement that I got was - When items are purchased in the Purchasing module using the Purchase Order (PO), in the P2P process, usually the items that we buy are identified basing on their type.
I wanted to know if something exists in Oracle, such that, I can differentiate if the items that we are buying through PO is an Asset Item or a Non-Asset item. If yes, Where in the backend of the Oracle database can I find such information. I mean which column in which table has this kind of information.
Any help is greatly appreciated. Thank you Sir
With all due respect, I did not understand what you had mentioned in the reply.
1) I am working in the Release 11i version of Oracle Apps.
2) I have around 5 years of experience working in Oracle Applications.
3) My questions was simple. --
The functional requirement that I got was - When items are purchased in the Purchasing module using the Purchase Order (PO), in the P2P process, usually the items that we buy are identified basing on their type.
I wanted to know if something exists in Oracle, such that, I can differentiate if the items that we are buying through PO is an Asset Item or a Non-Asset item. If yes, Where in the backend of the Oracle database can I find such information. I mean which column in which table has this kind of information.
Any help is greatly appreciated. Thank you Sir
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Experts.
Thank you for all your comments. Yes I know Oracle Applications is a little tricky applications and answers to questions are not straight forward.
Anyways, I shall close this question for you, as I did not get a particular answer. Thank you all.
Thank you for all your comments. Yes I know Oracle Applications is a little tricky applications and answers to questions are not straight forward.
Anyways, I shall close this question for you, as I did not get a particular answer. Thank you all.
ASKER
Admin, please close it. Thank you
It looks to me like fmarshall and I both gave you the answer, which is basically: the database cannot answer this question for you. You need to talk to the business users.
That may not be the answer you were hoping for, but that is not the same as saying we didn't answer your question.
"Oracle Applications is a little tricky..." That is a huge understatement!
That may not be the answer you were hoping for, but that is not the same as saying we didn't answer your question.
"Oracle Applications is a little tricky..." That is a huge understatement!
ASKER
OK Markgeer Sir,
With all due respect, I dont want to start a discussion here. I have only 5 years of experience in Oracle APps, which is very less compared to your(the experts) experiences here.
But, what i really wanted was to get this question closed. I am not satisfied with the answers and thus, cannot award points. That is my issue. If you want to keep the question open, i dont have a problem.
Thank you All.
With all due respect, I dont want to start a discussion here. I have only 5 years of experience in Oracle APps, which is very less compared to your(the experts) experiences here.
But, what i really wanted was to get this question closed. I am not satisfied with the answers and thus, cannot award points. That is my issue. If you want to keep the question open, i dont have a problem.
Thank you All.
I'm sorry that you're not satisfied with the answers. Perhaps you can tell us "what?" about the answers was not satisfying? I think it's an easy answer - although I understand that you were hoping for a different type of answer. Yet, please understand that the "different type of answer" probably doesn't exist.
I've reviewed my earlier response and would have to ask:
"How could the answer be different really?"
I've reviewed my earlier response and would have to ask:
"How could the answer be different really?"
This question is more of a "functional" one (that is: how does the business use the product?) than a "technical" question (like: which column of which table has this data?).
If you are somewhat new to Oracle Apps, you will learn that it is not designed to help a business run efficiently. And it certainly is not designed to allow easy, informed access to the data in the tables outside of the application. Oracle Apps is designed to be flexible enough that Oracle can market it to almost any business or organization and claim that it has the features that almost any business will need. This flexibility and configurability come at a price though. It obviously isn't optimized for any single business or industry (other than to make money for Oracle). And, it doesn't include many hard and fast rules (certainly not any foreign keys in the database!) about which data should go where. It offers "flex fields" that can be set up uniquely for each organization that uses Oracle Apps to track particular pieces of data that are significant to that organization.
So, where someone in your organization chose to track this particular data (if at all) may not be as easy to answer from the database as you might be thinking. Check with a lead pourchasing person in your organization. They may be able to show you on a screen where they can see or enter this data. Then, if you still need to find it in the database, you should be able to figure that out with the screen as your clue.