ERPstuff - Oracle EBS Community

I have setup all new Business group with GL,AP,FA and INV

I have created a invoice and posted it to GL. When i am running 'Mass Additions Create' program none of the invoice lines are getting transfered to FA. In Invoice distribition lines asset accounting is selected and also Asset tracking is enabled. Can you please help me to know if I have missed any basic setups of FA.

Regards,
Shashi.

[8D][:X][:D]

1.Create an Invoice.
2. Go to Distributions a) Select Asset or CIP CLEARING ACCOUNT
b) See that Asset Tracked option is enabled.
3.Validate and Create Accounting the Invoice.
4.Submit Payables Transfer to Gl.
5. Accounting Entry Asset Clearing A/c DR
Liability A/c Cr
6.Submit Mass Additions Create Programm
7. From Payables Submit Create Mass Addition Program to review
Whether Invoice is Transferred to FA (optional)
8. Go to FA
Mass Additions-- Prepare Mass Additions
9 Review the Imported Asset and Change the Status to Post.
10. Submit Post Mass Additions Program.
11. Review the Asset in the AssetWork Bench.
12. When you Submit the Create Journal Entries to gl

Accounting Entry
ASSET COST A/C DR
ASSET CLEARING A/C CR.

[:p][:D]

HI Eshwar,

Thanks for the reply, I have done exactly same. I have selected the assets account in the distribution lines and and also checked the track as asset. After transfering and posting to GL I ran mass additions program, View log of the program shows Zero records updated. so i could not proceed further on it.
Invoice lines have not transfer to FA. Mass additions > prepare Mass Addition will not show any records related to the invoice. I guess may be i have missed some setup related profile options or steps.

Regards,
Shashi.

Is there any error pointed out in mass addition create request log file ?
verify if u have specified CIP or clearing account at invoice distribution level ?

if your entries are transfered to GL then distributin should be transfer to FA but make it sure correct CIP/Clearing account is assigned.

thanks,

Hi Aman,

I have used clearing account and there in no specfic erorr message on log file.

=========== Mass Additions create Viewlog=============
Parameters:
Book Type Code: KR BOOKS
Acctg_date: 2009/04/30 00:00:00

Discount to Expense: N
Primary Accounting Method Accrual
AX is NOT used
Request id: 2752744
User id: 1007973
Login id: 2513326

Sob id: 1609
COA id: 52550
GL Acc Seg: 2
Default DPIS enabled: 0
Default DPIS Date:2009/01/31 00:00:00
Include Non Rec Tax in Dist:
Inventory Org Id: 5155

Updating AID records to N which EIB sends to FA
No of Records Updated : 0
Processing INSERT_FAMA....
Asset Type : 1=CIP
: 2=ASSET
Account: 2929
Asset Type: 2
No of Records Inserted: 0
Total Capitalised Records Inserted: 0

Updating AP Lines brought over to FA to Y
No of Records Updated : 0

Processing INS_EXPENSE....
Total Expensed Records Inserted: 0
Updating AP Lines brought over to FA to Y
No of Records Updated : 0

Updating Posted AP Asset Lines to N
AX not used CIP exist
No of Records Updated : 0

Updating Posted Non-asset AP Lines to N
No of Records Updated : 0

Grand Total of Records Inserted: 0
==========Viewlog=================

Regards,
Shashi.

HI Shashi,

Your log file state that u used Asset account instead of CIP.

Plz check below log as
Asset Type : 1=CIP
: 2=ASSET
Account: 2929
Asset Type: 2

verify and correct it.

If it is correct then verify FA setups like FA Book and clearing account mapping in FA setup and plz read metalink note: 77473.1

thanks,

Hi Shashi

Check Asset Clearing or CIP clearing account in your Asset category. If that code combination is not there it will not import distribution lines.

Let me know the result

Regards
Oracleapps1983