ERPstuff - Oracle EBS Community

Dear All,

I am new for the Oracle Apps. Please clarify the following points:-

1. I have created the PO-Default invoice in invoice workbench and asset clearing account used in distribution level. Now in this scenario, which book needs to be run for the posting to Fixed Assests. How to identify the books for posting to FA based on invoice distribution level account.

2. While creation PO-Default invoice, i have given one PO number in inovice workbench level. Now, how to see that PO number in Payables module.

3.I have searched the functionality of Delete mass addition program but not available in this site. So that, i requested for the exact functionality of Delete Mass Additions Program. Which entries will be delete while running this program.

4. Unfortunately, i am deleted the Assets in Asset work bench using Delete Icon(on tool bar). Is it possible to see that deleted icon in backend.

Thanks & Regards,

Madhu

Hi Madhu,

1.) Conditions For Asset Invoice Line Distributions To Be Imported
For the mass additions create process to import an invoice line distribution to Oracle Assets, these specific conditions must be met:

The line is charged to an account set up as an Asset account
The account is set up for an existing asset category as either the asset clearing account or the CIP clearing account
The Track As Asset check box is checked. (It is automatically checked if the account is an Asset account)
The invoice is approved
The invoice line distribution is posted to Oracle General Ledger from Payables
The general ledger date on the invoice line distribution is on or before the date you specify for the create program
Your installation of Payables must be tied to the same general ledger set of books as the corporate book for which you want to create mass additions
When you transfer the Assets from payables to FA, the transfer program has a parameter, which states the Target Asset Book name. Also in the distriubtions form you will have the asset book name. In R12, asset book and category can be selected at the line level itself ....


2.) The Po number would be available if you can click the match button at the invoice workbench, and click Find. The form will display the details of PO or receipt that is matched against this invoice.

3) Mass Addition Delete, will remove the Data lying in the interface table. FA interface table consists of assets that are trasferred from Payables, Projects and other modules if any, after processing these data, assets are created in the base tables, however a copy of the processed or rejected data stays in the interface table, which can be purged by running this program.

4) Assets Deleted cannot be tracked, since there is no record available in the database. Also rememember, you can delete an asset which is created in the current open period and no depereciation is run for the current period. You cannot delete prior period assets.
May be run standard reports and check whether there is any disturbance in the asset number sequence, that would help you in identifying the missing asset.

Regards,
Karthikeyan

Hi Karthikeyan,

Thanks for Your Reply. But, i have small doubt regarding on below ponts:-

2. Match Button disabled. What is the reason for disabled, in which scenario this Match button will disable.

I have checked in setup level also

setup->payables

Allow Final Matching is Marked
Allow distribution level matching is Marked
Allow matching account override is Unmarked
Transfer PO descriptive flexfield information is Marked.

3. I will agree with you. DELETE MASS ADDITION Program will delete the entires in FA_MASS_ADDTION Table which are in split and delete status. But in my condition POSTED entries also deleted. In which scenario, this posted entires will delete.

4. What are the standard reports for checking missed Asset numbers.

Thanks in advance.

Madhu

Hi Madhu,

2.) I am not sure about the circumstances under which a Match button will be disabled. Please check metalink for any mention of the same.

3.) Delete Mass addition program will delete items which are already processed and assets got created in the Asset module. The Queue status which would be picked up for deletion are:
a) SPLIT b) POSTED c) DELETE . When the transactions are posted to the base tables, there is no point in having those information in the Interface table any more .....
Please check FA User Guide for confirmation.

4) I dont see a straight forward standard report available to find missing asset numbers. Would suggest you to run Asset Register report, take the output to excel, perform sort / filter to find the missing sequences ....

Regards,
Karthikeyan

Hi Karthikeyan,

What is the reason for POSTED Entries will delete while running DELETE MASS ADDITION Program. I have searched in FA user guide. But i can't understand the functionality of DELETE MASS ADDITION Program.

Please let me know, what is the exact functionality of DELETE MASS ADDITION Program.

Regards,

Madhu

Dear Madhu,

Let me rephrase the question, Why you dont want to delete entries with Queue status as POSTED through Delete Mass Addition program?

A transaction in payables, which has come to Mass addition INTERFACE table, will have the initial status as NEW, later once posted to the FA base tables, the Queue status in the Mass addition INTERFACE table will get changed to POSTED.
Once the transaction is processed and posted to the base tables, we dont need the same data lying in the interface table ... There is no purpose ...
Remember, Delete mass additions deletes data from FA interface table and not Base tables ... There is no difference to the performance of FA module by deleting the Mass Additions Interface table.

I have gathered the information from FA user guide ... Please be patient in reading through the user guide, its available there ...
Closing this thread ...

Regards,
Karthikeyan