Oracle EBS Learnings

Bank Set-Ups have changed considerably in R12 since 11i. Prior to R12 of the Oracle E-Business Suite, the Payables application owned the bank, branch, and bank account tables and shared the data with other Oracle applications such as Receivables, Payroll, and Treasury.  Since the release of R12, the bank account model has changed in following ways: Banks and Bank Branches are created in TCA (Trading Community Architecture) parties.  The relationship is one-to-many (each Bank can have one or more Branches). The Bank Accounts have a one-to-many relationship with existing Bank Branches (each Bank Branch can have one or more Bank Accounts), but Bank Accounts are owned by the Cash Management application, not TCA. During the creation of a new (or updating an existing) Bank Account, you can specify which other installed Oracle applications you want to use the new (or updated) Bank Account with o Receivables o Payroll o Treasury  o Payables The Bank Accounts are f...

Fix SQL Developer loading issue in Mac: Let's say that you didn't like  default SQL developer PL/SQL Schema syntax and you are playing around with some custom syntaxes and in process have screwed the setting of your SQL developer and it doesn't load. Whenever you double click on the sql developer and it just hangs saying loading SQL extensions or gives some other reason or Let's say IT department being how frugal they are had given you a used MAC and you are trying to install SQL Developer and suppose it already had an version of SQL Developer all install and it doesn't let you open the existing you couldn't find out what is missing or wrong with your setup. You have uninstalled and reinstalled the SQL developer several times and still SQL Developer is stuck in the loading phase. You have ensured correct version of Java JDK is installed and you are following all the steps mentioned in the installations steps of Oracle SQL developer, you can do either of ...

Oracle applications R12.X forms don't open with Mac OS 10.X out of the box. It requires some work around to ensure that the forms open with firefox. This Blog post explains the workaround I used to open forms in firefox. STEP1: Uninstall existing firefox application Firefox version later than 52.X don't open the JAR/JAVA Files for Oracle Applications hence I have to uninstall any later versions of Firefox by removing Firefox from the applications folder for mac and thrashing it for good.  STEP2: Download older version of Firefox. Download the dmg file from  https://archive.mozilla.org/pub/firefox/releases/52.1.2esr/mac/en-US/ Once downloaded install firefox on mac and move the binary to applications folder. On the firefox to the preferences (or Developer options) and set the update option to 'Never check for updates' in the Advanced tab. Note: Since this firefox version is old it won't have all the security patches installed so use  STEP3 : Add t...

Copying Menu can be a Tedious task for a Functional Consultant, He or She has to manually do it by copying and pasting or by using Dataload. Oracle has come up with a solution in R12 for the same. Get Functional Administrator Responsibility Go to Core Services>> Menu. Enter the Menu name and Query. Click on Duplicate and Give a new name. Apply and Save. Only trouble with this approach is that if we copy the menu the Entry_Sequence is not copied as-is Oracle gives it its own sequence though the order of the Menu remains the same. That is if the Entry Sequence is 10,20, 30 etc it changes to 1,2,3... 

How to create a new address style for Location addresses. SOLUTION To add an address style: In System Administrator > Application > Flexfield > Descriptive > Segments 1. Enter Oracle Human Resources in the application field. 2. Enter Personal Address Information or Location Address in the title field as appropriate. 3. Run the query. 4. Uncheck the Freeze Flexfield Definition check box. Note: Read the warning. 5. Choose New from the File menu. 6. Enter the country code in the code and name fields. 7. Enter a description and select the Segments button. 8. Define the segments. Note: You can only use the columns provided by Oracle HR for your segments. 9. Save your work. Note: Make sure any new segments are enabled. You can choose whether segments are displayed or not. 10. Check the Freeze Flexfield Definition check box. 11. Choose the Compile button. When compilation is complete, exit your current login session. Then log in again to see your updat...

This post describes how to use the attribute mapping method in Oracle Advanced Pricing to implement a complex contract pricing rule Recently I came across the following pricing requirement that seemed to be tricky at first glance: - Use price breaks based on a weight of an item as defined in a DFF.  An item from Inventory is assigned to a contract line and has a quantity of 1 with a UOM of Each Each item has a break price (either by item category or the item number) based on the weight. E.g., price is $1000 < 5000 tons and $1500 if weight is between 5001 and 9999 tons and $2000 if > 10000 tons. The Advanced Pricing allows you to hook up your SQL code to drive pricing. The attribute mapping feature of  Oracle Advanced Pricing  helped us to implement the above pricing rules by adding a few lines of SQL code. First, we cannot use the standard price break functionality to achieve this since standard price break uses volume or quantity as basis. We followed...

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...

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...

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...

  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...

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. ...