A day in the life of an Oracle Applications Consultant

Tuesday, June 29, 2004

Tips on Loading On-Hand Inventory at Go-Live

Tips on Loading On-Hand Balances into Oracle Inventory

The generally accepted method for transferring on-hand inventory from a legacy system to Oracle Inventory at ‘go-live’ is to enter a miscellaneous receipt transaction into the desired subinventory.  This can be done manually using the form, by means of the Transaction Interface (simulating a ‘miscellaneous receipt’ transaction),  or via a Dataloader. 

When loading initial on-hand balances into Inventory, the material valuation account of the receiving subinventory will be debited.  The credit must be entered by the user (since this is a ‘miscellaneous receipt’ transaction).  If general ledger balances are going to be brought over from a legacy system, then generally the credit account is the same as the debit account, giving a zero net value for the transaction, thus not changing the total GL value of on-hand inventory brought over from the legacy system. 

Oracle’s Cost Manager uses the item cost to establish the value of the various debits and credits that it creates when costing a transaction.  The method in which the item’s cost is established depends on the costing method selected for the inventory organization.  If the organization is using standard cost, then the item’s cost must either be entered when the record is first created, or updated using a pending cost and the Standard Cost Update.  When the item master record is saved, a zero cost is automatically entered for the item unless the standard cost is entered during the item creation process.  If items are being created via the Item Open Interface, then a value for the frozen standard cost can be entered when using the ‘Create’ option.  Note that the interface does not allow entry of a standard cost when using the ‘Update’ option.  If items are loaded without a frozen cost and not updated, then they will be valued at zero and any GL charges resulting from a transaction will also be valued at zero. 

In an average cost organization, the cost of an item is not static.  It changes continuously with every receipt into inventory via a weighted average cost recalculation.  It is not necessary to predefine a frozen standard cost prior to loading inventory. 

So the on-hand load process will vary depending on the organization’s costing method.  If using standard cost, create the items in the Item Master and then verify that they have a frozen standard cost other than zero.  If using average cost, establish the current average cost by entering the average cost from the legacy system into the cost field in the Miscellaneous Receipt transaction line.  (In a standard cost system, this field is grayed out.)  Note that if no cost is entered into the transaction line, the resulting cost in Inventory will be zero and this will cause the current average cost in future transactions to be too low.

How to clear the Oracle Jinitiator Cache

This post talks about Jinitiator cache and the need to clear it on a periodic basis.

Today I was reminded about the necessity to clear your Jinitiator cache on a periodic basis. I was creating a worksheet in Oracle PSB and having selected the option to “Budget by Position”, when I tried to specify the data extract in the next field I received a rather bizarre error message - field does not understand operation. A quick check on Metalink revealed doc id. 248973.999 which suggested that I clear the Jinitiator cache. I checked the cache folder and found that it had a about 45MB worth of files - obviously it hadn’t been cleared in some time!!

My understanding of the Jinitiator cache is that it’s pretty much like the windows temp directory in that it needs to be cleared periodically. I thought it would be useful to highlight how to clear the cache files as well as remind users that this activity should be performed on a periodic basis as it may lead to obscure errors. I’ve also created a new category for Jinitiator for future posts specifically related to Jinitiator.

The first way to clear the Jinitiator cache is to simply delete all the files found in the cache directory. The cache directory is normally found on c:\program files\oracle\jinitiator 1.x.x\jcache. The second alternative is via the control panel, the steps are as follows: -

  1. Go to Start -> Settings -> Control Panel
  2. Double click on ‘JInitiator 1.x.x’
  3. Select Cache TAB from ‘JInitiator Control Panel’
  4. Click the Clear JAR Cache Button.

For an overview, setup and troubleshooting guide to Jinitiator for Oracle’s E-Business Suite 11.5.x (11i) refer to Metalink note 162488.1

For an overview, setup and troubleshooting guide to Jinitiator for Oracle’s E-Business Suite 10.7NCA and 11.0.x refer to Metalink note 206485.1

Saturday, June 26, 2004

Implementing a major re-organization

This post contains information about guidelines for implementing a major re-organization.

I found this presentation on the New England Oracle Applications User Group site. The presentation was prepared by Kiran Mundy for OAUG spring 2004 conference.The abstract of the presentation reads “A Company Reorganization changed our company structure from a simple geographical hierarchy to a matrix organization where service organizations were organized by technical specialty and the client sector organizations were organized by Customer Category. Projects would be owned by the Client Sector Orgs and employees by the service orgs. Management needed to be able to view division P&L’s by either the service or Client Sector organization. This paper describes our solution and how we implemented the re-org in 3 months at year-end” I had a look at the presentation and thought that it might be useful for anyone implementing a major change in the organization structure.

New Oracle Projects and Manufacturing contributor

This post contains details of a new author who has joined OracleAppsBlog and will be blogging under the Manufacturing and Projects Categories

Nancy Beck, a Developer working for AAR Corp, is joining OracleAppsBlog and will be writing under the Projects and Manufacturing Categories. Nancy has over six years experience with Oracle as a manufacturing implementation consultant for Oracle E-Business suite, starting with 10.7 and ending with 11.5.9. You can read Nancy’s membership profile here or if you’re a member you can e-mail Nancy via the profile e-mail console.

I wanted to welcome Nancy to the Blog and introduce her to all the other members. Thanks in advance for all your future contributions, I am sure your experience will add some interesting content to the blog cool smile

Friday, June 25, 2004

Oracle Advanced Pricing Module

This post contains details of a new author who has joined OracleAppsBlog and will be blogging under the Advanced Pricing Category

Suvabrata Biswas, an Oracle Applications Consultant who runs a consulting company based out of Houston Texas, is joining OracleAppsBlog and will be blogging under the Advanced Pricing Category. This category didn’t exist before so I have added it.

Suv has broad functional experience in Advanced Pricing, Bills of Materials, Assemble to Order, Quality, Engineering, Inventory, Work in Process, Procurement, Cost Management, Enterprise Asset Management, Order Management, Planning and MultiOrg. He also has broad technical experience with Oracle Application’s technical architecture, Oracle tools and operating systems such as Unix and NT. You should also check out his companies site. You can read Suv’s membership profile here or if you’re a member you can e-mail Suv via the profile e-mail console.

Welcome to OracleAppsBlog and we look forward to your contributions grin

Page 1 of 7 pages  1 2 3 >  Last ›