Oracle EBS Learnings

This is how the accounting works. Everything pertains to what an Organization owns, have and what it has to give. There is always a balance to what it owns and what it has to give. This  “balance”  is converted into an equation, also called  the Accounting Equation , which is: ASSETS = LIABILITIES +  OWNER’S EQUITY though I’ve understood it this way: OWNER’S EQUITY =  ASSETS – LIABILITIES Let’s take a simple example to justify the above equation, say you have Rs.1,000 but you know that you have to pay a loan of Rs.400 that you borrowed from your friend. So according to the equation Rs.1000 is your Asset, Rs.400 loan is your Liability and Rs.600 is the Equity that you own. Every organization which is registered with Government is obliged to disclose the above mentioned balance in a document called  Balance Sheet. That’s all for the accounting equation. Moving on after the accounting equation, There is a Debit  (Always on the  Left Side , written as  “DR”  for sho

The basic concept of Mass Allocation is  dividing  a  cost  on  some factors . If we take a simple example then consider 3 departments X, Y and Z using a single landline telephone. Each department has 2, 3 and 6 employees respectively. The bill for month of June-09 of landlines comes out to be Rs.1700. If you have to calculate the telephone usage for department Y. How will you do that? Is it Rs.1700? No. Is it 1700/3 (total divided by total number of employees in dept-Y)? No, because there were 8 more person using the same landline connection.  The answer is that you will allocate the total cost into each department based on the number of employee it has . So in this case the allocation will be 1700*3/11 and you’ll get Rs.463. Here is the department wise total of the telephone bill: Department X: Rs.309.09 (2 employees usage of 1700) Department Y: Rs.463.63 (3 employees usage of 1700) Department Z: Rs.927.27 (6 employees usage of 1700) This is the formula for MassAllocat

Query to search Responsibility by Concurrent program name SELECT frt.responsibility_name,                 frg.request_group_name,                 frg.description   FROM fnd_request_groups frg              ,fnd_request_group_units frgu              ,fnd_concurrent_programs fcp              ,fnd_concurrent_programs_tl fcpt              ,fnd_responsibility_tl frt              ,fnd_responsibility frs  WHERE frgu.unit_application_id = fcp.application_id  AND   frgu.request_unit_id = fcp.concurrent_program_id  AND   frg.request_group_id = frgu.request_group_id  AND   frg.application_id = frgu.application_id  AND   fcpt.source_lang = USERENV('LANG')  AND   fcp.application_id = fcpt.application_id  AND   fcp.concurrent_program_id = fcpt.concurrent_program_id  AND   frs.application_id = frt.application_id  AND   frs.responsibility_id = frt.responsibility_id  AND   frt.source_lang = USERENV('LANG')  AND   frs.request_group_id = frg.request_group_id  AND   frs.application_id = f