Skip to main content

Posts

Showing posts from 2014

COGS and DCOGS demystified

Before R12, EBS use to expense the value of the goods to COGS account as soon as Sales Order is ship confirmed in Oracle Order Management and revenue was recognized as soon as the order is imported in oracle AR. There was hardly any time gap between Ship confirm and Invoice generation in oracle systems but in real world there could be many reasons why revenue couldn't be recognized until customer actually accepts the goods in its warehouse. In order to stick with the matching principle stipulated by GAAP which states that expense has to be recorded in same period when revenue is recognized Oracle introduced the concept of Deferred COGS where Cogs recognization is deferred until Revenue is actually realized. In 11.5.10 COGS used to be debited as soon as an order was ship confirmed in oracle but now in R12 Deferred COGS is debited and when revenue is realized then actual COGS is debited and Deferred COGS is credit to offset the earlier entry, thus synchronizing the recogniti...

"User to Resource link has been not set correctly" error in CRM

PURPOSE Within any of the modules within the CRM Service Suite of products you are receiving the following error when attempting certain operations: "User Resource Link hast not been setup correctly.   Please contact your System Administrator." This error is to be expected for users not fully configured to "use" the software (especially if you are logged in under a user that typically doesn't use the software, but mainly administers it) In effect, Resources are what perform actions in the Service Module -- build Repair Orders, create Service Requests, Update Contact Information, etc. Being logged in as a User (for example JDOE) does not mean your user is a Resource (Doe, John) capable of using CRM. For each user that needs to be done and is likely something you have done for the bulk of your users as part of a business process, but maybe just not for this one you are testing when this error results. TROUBLESHOOTING STEPS To remedy for this...

Fixed Assets -Impairment FAQ

1. What does 'Impairment' mean ? A.An asset is impaired when its carrying amount exceeds its recoverable amount. 2. What is a 'Carrying amount' ? A.The carrying amount represents the amount at which an asset is recognized in the balance sheet after deducting accumulated depreciation and accumulated impairment losses. 3. What does the 'Recoverable amount' represent ? A.The recoverable amount of an asset or a cash-generating unit is the higher of its fair value less costs to sell and its value in use. 4. What is the 'Fair Value' of an asset ? A.Fair Value represents the amount obtainable from the sale of an asset in a bargained transaction between knowledgeable, willing parties.  What is the 'Value in Use' of an asset ? A.Value in use is the present value of the future cash flows expected to be derived from an asset or cash-generating unit. What does a Cash-Generating Unit represent ? A.A cash-generating unit is the smallest identifiable group...

PTO Flow in Oracle EBS

  Responsibility : Manufacturing and Distribution Manager  Create Items - Create PTO Model (PTO_MODEL_WIKI) using the PTO Model item template and assign it to organization M1 Ensure that the BOM Item type is Model in the Bills of Material tab and the Pick Components check box is checked in the Order Management tab - Create PTO Option Class (PTO_OC_WIKI) using the PTO Option Class item template and assign it to organization M1. Ensure that the BOM Item type is Option Class in the Bills of Material tab and the Pick Components check box is checked in the Order Management tab - Create 3 Items (PTO_ITEM, PTO_ITEM_1 & PTO_ITEM2) using the Finished Goods Item Template and assign it to M1 Org  Add the Items to a Price List - Navigate to Oracle Pricing Manager responsibility, query an Active Price list and add the items to the Price List and mention a value for price - Navigation: Oracle Pricing Manager ->Price Lists  Create s...

ATO Configuration flow in Oracle

Skip to content ATO Configuration Flow in Oracle Create items 1. To setup an ATO Model a few items are needed to get a BOM minimum skeleton. Through this example, an ATO item (parent), an option class and 3 components (purchased items) are needed. => Navigate to Inventory > Items > Master Items     Select organization :    V1 (Vision Operations) => Enter Item Name and Description (with XX=your initials) :        Model item name : XX AtoModel M01        Description : XX AtoModel M01 => Go to Tools -> Copy From :        Apply the 'ATO Model' template     In the Order Management tab, check that the Assemble to Order flag (ATO) is checked. In the General Planning tab, check the Make or Buy flag to Make. => Save the record, and assign the item to Organization M1. ...