My Portfolio

SELECT a.asset_number,  b.life_in_months LIFE_IN_BOOKS,  m.asset_number,  m.attribute1 LIFE_IN_MASS_ADD FROM fa_additions a,  fa_books b,  fa_mass_additions m WHERE a.asset_id = b.asset_id AND a.asset_number = m.asset_number AND b.book_type_code LIKE 'BOOK NAME' --- pass the book AND m.attribute1 IS NOT NULL once you get , you need to take count SELECT COUNT(*) FROM fa_additions a,  fa_books b,  fa_mass_additions m WHERE a.asset_id = b.asset_id AND a.asset_number = m.asset_number AND b.book_type_code LIKE 'BOOK NAME' --- pass the book AND m.attribute1 IS NOT NULL and finally here is your scripts for Update UPDATE fa_books b SET life_in_months = ( SELECT m.attribute1 FROM fa_mass_additions m, fa_additions a WHERE a.asset_id = b.asset_id AND a.asset_number = m.asset_number AND m.book_type_code LIKE 'BOOK NAME' --- pass the book AND m.attribute1 IS NOT NULL) WHERE b.book_type_code LIKE 'BOOK NAME' --- pass the book

Make a DFF Non Editable by   Mr.KK How to make a DFF field Non Editable: Go to the DFF Definition screen for the particular context value Select the Particular DFF Attribute Open the Valueset attached to it In the value set “Edit information”, provide the following values in “Event Edit” & “Event Validate” FND SQL “BEGIN NULL; END;”       Check the screen shots for more information:

How To Create Value Sets Where One Segment Is Dependent On The Previous Segment Selection May 20, 2010   shivmohan purohit   Oracle Functional $FLEX$ ,  dependent value set ,  value set             1 Votes How to create value sets so that one segment is dependent on the previous segment selection? Example of $FLEX$ Syntax Here is an example of  using :$FLEX$.Value_Set_Name to set up value sets where one  segment depends on a prior segment that itself depends on a prior segment ("cascading dependencies"). Assume you have a three-segment flexfield where the first segment is car manufacturer, the second segment is car model, and the third segment is car color. You could limit your third segment’s values to only include car colors that are available for the car specified in the first two segments. Your three value sets might be defined as follows: Segment Name Manufacturer  Value Set Name Car_Maker_Name_Value_Set  Va...

Symptoms : When attempting to run FAMAPT: Mass Additions Post the following error occurs: ERROR Error: Incorrect Asset Type and Category combination for &CATEGORY_ID. Mass Addition ID: ##### ==> ** Failed ** -- Steps To Reproduce: The issue can be reproduced at will with the following steps: 1. Run Create mass addition to send mass addition from AP to FA 2. In prepare mass addition form , update required fields and set status to POST 3.Submit Mass Additions Post Cause: The issue is caused by the following setup: The category assigned to this mass addition has 'Capitalize' checkbox checked therefore it cannot be used for an Expensed asset. Solution: 1. Navigate to setup > Asset System > Categories 2. Query the categories having Capitalize checkbox Unchecked or if one does not exist , define a new one 3. Navigate to Mass additions > Prepare mass addition Query the failing mass addition at POST status and change the category to a correct one 4. Rerun Post Mass Addi...

The best practice to handle fixed asset items and to eliminate the confusion of other types of items is to follow the below procedure: 1. Define a FA item for each asset category you have, for example, let's say we have two asset categories (Computers and Equipment), then we'll define the following items:           Item Code: FA00001, Item Description: Computers           Item Code: FA00002, Item Description: Equipment 2. Assign expense item for FA00001 with Asset Clearing Account attached to Computers Asset Category (Purchasing Tab) 3. Assign Asset Category for FA00001 with Computers Asset Category (Purchasing Tab) Now, let's say we want to purchase a Dell laptop: 1. Create PO and enter Item FA00001, You will notice that Description will be defaulted to "Computers" 2. Change the description to "Dell laptop" (You have to enable the "Allow Description Update" in purchasing tab") 3. You will notice t...

If you are running Asset mass additions program & AP Invoice you've created is not added to Assets, here are the few things you need to check:  1.         Invoice should be an Approved Invoice. 2.         Invoice line distribution is posted to General Ledger from Payables. To post the AP Invoice Line Distributions to GL, run t he program: Payables Transfer to General Ledger 3.         The general ledger date on the invoice line distribution is on or before the date you specify for the create program 4.         Make sure that Invoice is not already posted to Asset. Check the ASSET_ADDITION_FLAG in AP_INVOICE_DISTRIBUTIONS_ALL table. If this flag is ‘U’ invoice distribution is not added to Assets yet. If it is “Y” Invoice distribution is already added to assets.   5.         Invoice line should be charg...

Process Outline –>FA Mass Addition This is brief process outline for Mass addition program in Oracle. 1.Asset Invoice Creation within AP For assets to be transferred to Assets, it must be approved and posted in the GL and charged the distribution to a clearing account that is already assigned to an asset category or charge directly to the asset cost account. The track as asset flag will be automatically checked if the accounts have been set up as Asset within the GL. Invoice can be posted either to the asset clearing account or directly to the asset cost account. Having a clearing account provides more control particularly if an asset does not get added in the correct period. That would therefore make the reconciliation between GL and FA easier. Typical steps are herewith: 1. Navigate to the Submit a New Request Window and select REQUEST SET. 2. Select the Mass Additions Create Request Set. This set contains two programs: Mass Additions Create Mass Additions Create Report 2.Mass Add...

Item Cross References in Oracle Apps R12     This post talks about the Front end navigations related to Item Cross References. How to create a cross reference type? Which form is used to assign the Item cross reference type and Items? How to define cross reference name for an item? Is there a standard report to show the list of cross references? 1.       How to create a cross reference type? Cross Reference  : This form can be used to capture the reference information pertaining to an item, like drawing number, vendor part number, etc. This is available at  Inventory >> Items >> Cross References                        In this form, user can define the list of cross references applicable for the Items. This list will be available at the Item master.              ...

In this post, i tried to create a Fixed asset via standard Oracle API  FA_ADDITION_PUB.DO_ADDITION . I tested the script in Oracle Apps R12. Hope this helps.  Script: set serveroutput on ; DECLARE    l_trans_rec                FA_API_TYPES . trans_rec_type ;    l_dist_trans_rec           FA_API_TYPES . trans_rec_type ;    l_asset_hdr_rec            FA_API_TYPES . asset_hdr_rec_type ;    l_asset_desc_rec           FA_API_TYPES . asset_desc_rec_type ;    l_asset_cat_rec            FA_API_TYPES . asset_cat_rec_type ;    l_asset_type_rec           FA_API_TYPES . asset_type_rec_type ;  ...