Uploadin Fixed Assest through ADI

[yknev]

Dear all,

After uploading fixed assets through ADI to Oracle Fixed assest(11.5.10.2). How to identify the ADI Fixed assests(uploading through ADI) and Normal fixed assests(creating fixed assests in front end) in backend. What is the main difference in FA_MASS_ADDITIONS table.

[karthikeyanp1981]

The source will be different ....
For assets uploaded, it will be Spreadsheet
For assets transferred from Payables, it will be Payables ....
Also, asset created in the Fixed Asset module directly will be hitting the base tables directly and will not take the mass additions process .....
You can identify based on the source field ..

[yknev]

Dear Karthikeyan,

Thanks for given information, but i want exact difference in FA_MASS_ADDITIONS Table. Can u give me that difference.

[admin]

What kind of difference you are expecting? tks

[yknev]

In FA_MASS_ADDITIONS table, FEEDER_SYSTEM_NAME display the Oracle Payables it means, the assest comes from AP.

I want exact difference of ADI assest in FA_MASS_ADDITIONS table like above example.

[yknev]

Hello Karithkeyan,

How to identify the Feeder system assets in Asset work bench. After transfering from FA_MASS_ADDITION table.

Without comparing to FA_MASS_ADDITION table. because this table is interface table.

Regards,

yknev.

[karthikeyanp1981]

Dear yknev,

FA_ASSET_INVOICES is a table where you have the Column FEEDER_SYSTEM_NAME , if the value is Spreadsheet then asset is uploaded to Oracle Assets directly through ADI.

Regards,
Karthikeyan