How to Change Category for an Asset in Oracle EBS R12 or R11 Using API?

FA_API_FA_RECLASS_PUB.DO_RECLASS API may be used to change asset category for one or multiple assets.

Structure of API is

FA_RECLASS_PUB.do_reclass (

-- std parameters

                              p_api_version                                    => l_api_version,

                              p_init_msg_list                                   => l_msg_list,

                              p_commit                                          => l_commit_flag,

                              p_validation_level                              => l_validation_level,

                              p_calling_fn                                       => l_calling_fn,

                              x_return_status                                  => l_return_status,

                              x_msg_count                                     => l_msg_count,

                              x_msg_data                                       => l_msg_data,

              -- api parameters

                              px_trans_rec                                     => l_trans_rec,

                              px_asset_hdr_rec                             => l_asset_hdr_rec,

                              px_asset_cat_rec_new                      => l_asset_cat_rec_new,

                              p_recl_opt_rec                                 => l_recl_opt_rec

                                                       );

Get API used in this video from FA_RECLASS_PUB.DO_RECLASS

 

Demo 

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to Change Life Years Field for an Asset in Oracle EBS R12 or R11 Using API?

FA_API_FA_ADJUSTMENT_PUB.DO_ADJUSTMENT API may be used to process changes to existing fixed assets when number of records is very high.

Using this API you may change different information (fields) in both releases R11 or R12. The main difference between releases is that in R12 you do not need below parameter which is required for R11.

px_inv_rate_tbl => l_inv_rate_tbl

In this video I'm using API to change Life Years twice field showing how asset looks in Application before first API run, after first and second run. All API runs are visible into Transaction History window.
To download API used please click on FA_API_FA_ADJUSTMENT_PUB.DO_ADJUSTMENT

Demo


If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to setup and use Depreciation Override in Oracle EBS Fixed Assets in R12?

"Depreciation Override allows you to optionally override the depreciation amounts calculated by Oracle Assets. Using this feature, you can manually override the calculated default depreciation amounts for standalone and group assets.

Before running depreciation or performing adjustments, you must provide the necessary information in the Depreciation Override window or the FA_DEPRN_OVERRIDE table, and indicate whether the override data is for depreciation or adjustments. When running depreciation, the system will upload and use the depreciation amounts provided in the interface table.

Prerequisite: Set the profile option FA: Enable Depreciation Override to Yes.

Note: For MRC-enabled books, you do not need to provide the override amounts for the reporting currency books. The system will derive the reporting currency values based on the ratio of asset cost in the reporting currency to asset cost in the ledger currency." Oracle Assets User Guide - Release 12.1 Part Number E13586-04

In this video I walk trough below scenarios:
- compare monthly depreciation before and after override
- correct/modify override depreciation value
- close month and make sure depreciation value is same with one before override (This is true only if depreciation is calculated cost / life in months; if depreciation is calculated Net Book Value / remaining life in months depreciation value will be different).

 Demo


If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How to update Supplier information using API in Oracle EBS R12?

Is any way to run a supplier mass update from backend?

I bet this question was raised many time to E-Business Suite support team few months after go live. More over when data was migrated from a legacy system and cleaning activity was completed under time pressure.
Answer is yes, it’s possible to run a mass update as Oracle EBS provides APIs for supplier master data and also for supplier site level.

The API name is AP_VENDOR_PUB_PKG
· Create_Vendor
· Update_Vendor
· Create_Vendor_Site
· Update_Vendor_Site
· Create_Vendor_Contact
· Update_Vendor_Contact
· Update_Address_Assignments_DFF

In this video you can see the way AP_VENDOR_PUB_PKG.Update_Vendor may be used to update below fields:

Supplier type

Quantity Received Exception

Terms Date Basis and Pay Group

Inactive Date

Demo
 
If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address