MASS ADDITIONS CREATE CANNOT CREATE ASSETS FOR INVOICES WITH EXPENSED ACCOUNTS_模块 mass additions post 因错误而终止-优快云博客

Problem Description
-------------------
You are in Oracle Assets Release 11 and running FAMACR:Mass Additions Create,
from Oracle Payables. You are trying to create mass addition lines from invoices
with expensed accounts and the expensed lines are not transferring to the Fixed
Assets interface table (FA_MASS_ADDITIONS).

You have already checked the following:
1) Category is set up with Capitalized unchecked.
2) The Distribution line on the invoice is charged to an expense account.
3) Track as asset is checked.
4) The invoice is approved.
5) The invoice is posted to General Ledger.
6) The GL Date on the invoice line distribution is on or before the
date specified on the Mass Additions Create parameters.

Mass Additions Create will only create mass addition lines under certain
circumstances. Please check that you have invoice lines that satisfy the
following criteria.

Conditions for ASSET Invoice Line Distributions to be Imported:

a) The line is charged to an account set up as an Asset account.

b) The account is set up for an existing Asset Category as either the Asset
Clearing Account or the CIP Clearing Account.

c) The Track as Asset check box is checked. (It is automatically checked
if the account is an Asset account).

d) The invoice is approved.

e) The invoice line distribution is posted to Oracle General Ledger from Payables.

f) The General Ledger date on the invoice line distribution is on or before
the date you specify for the FAMACR program.

g) If you use the multiple organizations feature, your Payables operating unit
must be tied to the same General Ledger Set of Books as the Corporate book
for which you want to run FAMACR.

Conditions for EXPENSED Invoice Line Distributions to be Imported :

a) The invoice line distribution is charged to an Expense account.

b) The Track As Asset box is manually checked.

c) The invoice is approved.

d) The invoice line distribution is posted to Oracle General Ledger from Oracle Payables.

e) The General Ledger date on the invoice line distribution is on or before
the date you specify for the FAMACR program.

f) Your installation of Payables must be tied to the same General Ledger Set
of Books as the Corporate book for which you want to run FAMACR.

To be picked up, the following settings are required against the line in the
ap_invoice_distributions_all table:

assets_tracking_flag = 'Y'
asset_additions_flag = 'U' (U = Untested, Y = Accepted, N = Rejected)
posted_flag = 'Y'
accounting_date = ? (must be <= to the date entered when running the FAMACR process)

The following script can be run to check the relevant flag settings for lines
that have not come through to Oracle Assets:

SQL> Select apid.accounting_date, apid.assets_tracking_flag,
apid.assets_addition_flag, apid.posted_flag, apid.set_of_books_id,
glcc.chart_of_accounts_id, glcc.account_type, apid.invoice_id
from ap_invoice_distributions_all apid, gl_code_combinations glcc
where invoice_id = ????;