Skip to main content

Posts

Bank, Bank Branches and Accounts in Oracle R12

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

How to fix SQL developer still loading issue in Mac

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

How to use Oracle Applications 12.X on Mac

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

How to Copy Menu in Oracle Applications

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

Address Styles in Oracle Apps

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

Price breaks based on Weight?

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

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