ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle Assets Additions API

Oracle Assets Additions API

原创 Linux操作系统 作者:blueshine07 时间:2012-06-28 11:08:33 0 删除 编辑

Oracle Assets Additions API

Subject:
Oracle Assets Additions API Documentation Supplement, Jan 2003
 
Doc ID:
206473.1
Type:
REFERENCE
 
Modified Date :
21-APR-2005
Status:
PUBLISHED
You can use the Additions API to add assets directly via PL/SQL rather than through the normal Oracle Assets interfaces. The Additions API uses the FA_ADDITION_PUB.DO_ADDITION procedure. You can use this API if you have a custom interface that makes it difficult to use with the existing asset additions interfaces in Oracle Assets.
Oracle Assets also allows you to add assets using any of the following methods:
o    QuickAdditions: You use the QuickAdditions process to quickly enter ordinary assets when you must enter them manually. You can enter minimal information in the QuickAdditions window, and the remaining asset information defaults from the asset category, book, and the date placed in service.
o    Detail Additions: You use the Detail Additions process to manuallyadd complex assets which the QuickAdditions process does not handle, for example, assets that have a salvage value or assets with more than one assignments.
o    Mass Additions: You use the Mass Additions process to add assets automatically from an external source. Create assets from one or more invoice distribution lines in Oracle Payables, CIP asset lines in Oracle Projects, asset information from another assets system, or information from any other feeder system using the interface.
CIP Assets
If you have checked the Allow CIP Assets check box on the Book Controls window of a tax book, when you add CIP assets using the Additions API, the API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book.
MRC
If you have set up Multiple Reporting Currencies (MRC), when you add assets using the Additions API, the API automatically copies the assets to the reporting books.
Passing Null Values
You must pass special values in order to null the values of BONUS_RULE, CEILING_NAME, or GROUP_ASSET_ID. If you pass a NULL value directly for these values, the API will automatically default to the value setup for the category. The table below shows the value that must be passed for the field value to be NULL.
Field
Value to Pass for NULL Field
BONUS_RULE
FND_API.G_MISS_CHAR
CEILING_NAME
FND_API.G_MISS_CHAR
GROUP_ASSET_ID
FND_API.G_MISS_NUM


 
See Also
Additions API Description
Sample Script. Using the Additions API via Invoices
Sample Script. Using the Additions API with No Invoices
Additions API Description
The Additions API procedure is called: FA_ADDITION_PUB.DO_ADDITION ().
The following table provides the arguments, types, value, and descriptions of the elements of the FA_ADDITION_PUB.DO_ADDITION procedure.
Each argument has a prefix of P, X, or PX. These prefixes mean the following:
o    P - indicates an In argument
o    X - indicates an Out argument
o    PX - indicates an argument that is both In and Out
Argument
Type
Value
Description
P_API_VERSION
NUMBER
Internal use only
Version of the API in use.
P_INIT_MSG_LIST
VARCHAR2(1)
FND_API.G_TRUE - Initialize the message stack
FND_API.G_FALSE - Do not initialize the message stack (Default)
Determines whether the messages stack should be initialized and cleared.
P_COMMIT
VARCHAR2(1)
FND_API.G_TRUE - Commit automatically
FND_API.G_FALSE - Do not commit automatically (Default)
Flag on whether to commit asset after processed.
P_VALIDATION_LEVEL
NUMBER
FND_API.G_VALID_
LEVEL_NONE - Lowest level of validation possible for a transaction
FND_API.G_VALID_
LEVEL_FULL - Highest level of validation possible for a transaction (Default)
Check on whether the API should do the validation for the asset.
X_RETURN_STATUS
VARCHAR2(1)
FND_API.G_RET_STS_ SUCCESS - Addition was a success
FND_API.G_RET_STS_ ERROR - Addition failed FND_API.G_RET_STS_ UNEXP_ERROR - Unexpected error
Determines whether or not the API completed successfully.
X_MSG_COUNT
NUMBER
 
Number of messages on the message stack.
X_MSG_DATA
VARCHAR2(1024)
 
Message stack.
P_CALLING_FN
VARCHAR2(30)
 
Function calling the API
PX_TRANS_REC
FA_API_TYPES.
TRANS_REC_TYPE
 
Describes the transaction taking place.
PX_DIST_TRANS_REC
FA_API_TYPES.
DIST_TRANS_REC_ TYPE
 
Describes the distribution of the transaction.
PX_ASSET_HDR_REC
FA_API_TYPES.
ASSET_HDR_REC_ TYPE
 
Unique identifiers of the asset being added.
PX_ASSET_DESC_REC
FA_API_TYPES.
ASSET_DESC_REC_ TYPE
 
Description of the asset.
PX_ASSET_TYPE_REC
FA_API_TYPES.
ASSET_TYPE_REC_ TYPE
 
Asset type of the asset.
PX_ASSET_CAT_REC
FA_API_TYPES.
ASSET_CAT_REC_ TYPE
 
Category information of the asset.
PX_ASSET_HIERARCHY_REC
FA_API_TYPES.
ASSET_HIERARCHY_REC_TYPE
 
Hierarchy information of the asset.
PX_ASSET_FIN_REC
FA_API_TYPES.
ASSET_FIN_REC_ TYPE
 
Financial information of the asset.
PX_ASSET_DEPRN_REC
FA_API_TYPES.
ASSET_DEPRN_
REC_TYPE
 
Depreciation information of the asset.
PX_ASSET_DIST_TBL
FA_API_TYPES.
ASSET_DIST_TBL_
TYPE
 
Distribution information of the asset.
PX_INV_TBL
FA_API_TYPES.
INV_TBL_TYPE
 
Invoices for the asset.
PX_INV_RATE_TBL
FA_API_TYPES.
INV_RATE_TBL_
TYPE
 
Table of rates for the invoices for the asset for MRC.
Table 1 - 1. (Page 2 of 2)


 
TRANS_REC_TYPE Transaction Structure
The TRANS_REC_TYPE transaction structure contains information about the transaction, such as the transaction header ID and the transaction type code. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
TRANSACTION_HEADER_
ID
Internal use only
NUMBER(15)
Optional OUT parameter
TRANSACTION_DATE_
ENTERED
Optional
DATE
Must be the same as the date placed in service, which it defaults to.
TRANSACTION_NAME
Optional
VARCHAR2(20)
Description of the transaction.
MASS_REFERENCE_ID
Optional
NUMBER(15)
Identifies concurrent request that invoked the mass transaction.
TRANSACTION_SUBTYPE
Optional
 
VARCHAR2(9)
AMORTIZED - Amortize NBV addition
NULL - Regular addition
AMORTIZATION_START_
DATE
Optional
DATE
Amortization start date
CALLING_INTERFACE
Optional
VARCHAR2(30)
Defaults to CUSTOM
DESC_FLEX
Optional
DESC_FLEX_
REC
Descriptive flexfield segment
WHO_INFO
Required
STANDARD_
WHO_REC
Standard Who columns
 


 
ASSET_HDR_REC_TYPE Asset Structure
The ASSET_HDR_REC_TYPE asset structure contains unique identification information for a given asset, such as the asset ID and book type code. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
ASSET_ID
Internal use only for addition to Corporate book. Required for addition to tax book for asset already existing in Corporate book.

For a tax addition, only the TRANS_REC_TYPE and the ASSET_HDR_REC_TYPE attributes are needed. The values in the other structures such as ASSET_DESC_REC_TYPE, ASSET_FIN_REC_TYPE, ASSET_TYPE_REC_TYPE, ASSET_CAT_REC_TYPE, etc, will default form. the values of the Corporate book,
NUMBER(15)
Optional OUT parameter
BOOK_TYPE_CODE
Required
VARCHAR2(15)
Book name
 


 
ASSET_DESC_REC_TYPE Asset Structure
The ASSET_DESC_REC_TYPE asset structure contains descriptive information about the asset, such as the tag number, serial number, and manufacturer name. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
ASSET_NUMBER
Optional
VARCHAR2(15)
Defaults to asset_id. Optional OUT parameter.
DESCRIPTION
Required
VARCHAR2(80)
Description of the asset.
TAG_NUMBER
Optional
VARCHAR2(15)
Tag number of the asset.
SERIAL_NUMBER
Optional
VARCHAR2(35)
Serial number of the asset.
ASSET_KEY_CCID
Optional
NUMBER(15)
Identifies an asset key flexfield combination for the asset.
PARENT_ASSET_ID
Optional
NUMBER(15)
Identifies a parent asset for subcomponents.
STATUS
Optional
VARCHAR2(150)
Describes the status of the asset. (CRL Assets only)
MANUFACTURER_NAME
Optional
VARCHAR2(30)
Name of the manufacturer.
MODEL_NUMBER
Optional
VARCHAR2(40)
Model number of the asset.
WARRANTY_ID
Optional
NUMBER(15)
Warranty identification number.
LEASE_ID
Optional
NUMBER(15)
Lease identification number.
IN_USE_FLAG
Optional
VARCHAR2(3)
Indicates whether the asset is in use.
YES - In use (default)
NO - Not in use
INVENTORIAL
Optional
VARCHAR2(3)
YES - Include in physical inventory
NO - Do not include in physical inventory
Defaults to value in category
PROPERTY_TYPE_CODE
Optional
VARCHAR2(10)
Indicates the property type. Defaults to value in category
PROPERTY_1245_1250_
CODE
Optional
VARCHAR2(4)
1245 - Personal
1250 - Real
Defaults to value in category
OWNED_LEASED
Optional
VARCHAR2(15)
OWNED - Owned (Default)
LEASED - Leased
Defaults to value in category
NEW_USED
Optional
VARCHAR2(4)
NEW - New (Default)
USED - Used
CURRENT_UNITS
Required
NUMBER
Current number of units for the asset.
LEASE_DESC_FLEX
Optional
DESC_FLEX_
REC_TYPE
Lease descriptive flexfield segments.
GLOBAL_DESC_FLEX
Optional
DESC_FLEX_
REC_TYPE
Global descriptive flexfield segments.
Table 1 - 2. (Page 2 of 2)


 
ASSET_TYPE_REC_TYPE Asset Structure
The ASSET_TYPE_REC_TYPE asset structure contains information about the asset type: CIP, capitalized, or expensed. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
ASSET_TYPE
Required
VARCHAR2(15)
CAPITALIZED - Capitalized asset (default)
CIP - CIP asset
EXPENSED - Expensed asset
 


 
ASSET_CAT_REC_TYPE Asset Structure
The ASSET_CAT_REC_TYPE asset structure contains information about the asset category, such as the category ID and the category descriptive flexfield. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
CATEGORY_ID
Required
NUMBER(15)
Identifies whether the asset is CIP, Capitalized, or Expensed.
CATEGORY_DESC_FLEX
Optional
DESC_FLEX_
REC_TYPE
Category descriptive flexfield segments.
Table 1 - 3. (Page 1 of 1)


 
ASSET_HIERARCHY_REC_TYPE Asset Structure
The ASSET_HIERARCHY_REC_TYPE asset structure contains information about whether the asset belongs to an asset hierarchy. This asset structure applies only to CRL Assets. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
PARENT_HIERARCHY_ID
Optional
NUMBER(15)
Identifies the hierarchy to which the asset belongs. (CRL assets)
Table 1 - 4. (Page 1 of 1)


 
ASSET_FIN_REC_TYPE Asset Structure
The ASSET_FIN_REC_TYPE asset structure contains financial information for a given asset. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
DATE_PLACED_IN_
SERVICE
Required (if no invoices were populated)
DATE
Date the asset was placed in service.
DEPRN_METHOD_CODE
Optional
VARCHAR2(12)
The name of the depreciation menthod. Defaults to value in category
LIFE_IN_MONTHS
Optional
NUMBER(4)
Life of the asset in total months. Defaults to value in category
COST
Required (if no invoices were populated)
NUMBER
Current cost of the asset.
ORIGINAL_COST
Optional
NUMBER
Original cost of the asset. Defaults to cost.
SALVAGE_VALUE
Optional
NUMBER
Asset salvage value. Defaults to value in category
PRORATE_CONVENTION_
CODE
Optional
VARCHAR2(10)
Depreciation prorate convention. Defaults to value in category
DEPRECIATE_FLAG
Required
 
VARCHAR2(3)
Indicates whether the asset is depreciating. YES - Asset is depreciating
NO - Asset is not depreciating
ITC_AMOUNT_ID
Optional
NUMBER(15)
Identifies the ITC rate.
BASIC_RATE
Optional
NUMBER
Defaults to value in category
ADJUSTED_RATE
Optional
NUMBER
Defaults to value in category
BONUS_RULE
Optional
NUMBER
Bonus rule for an asset. Defaults to value in category. If a defualt value is defined, and you want the value to be NULL, you must pass FND_API.G_MISS_CHAR to the Addition API.
CEILING_NAME
Optional
VARCHAR2(30)
Identifies a deprecation ceiling to be used in calculating deprecation. Defaults to value in category. If a defualt value is defined, and you want the value to be NULL, you must pass FND_API.G_MISS_CHAR to the Addition API.
PRODUCTION_CAPACITY
Optional
NUMBER
Capacity of a units of production asset. Defaults to value in category
UNIT_OF_MEASURE
Optional
VARCHAR2(25)
Unit of measure of a units of production asset. Defaults to value in category.
REVAL_CEILING
Optional
NUMBER
Upper limit for revaluing asset cost.
UNREVALUED_COST
Optional
NUMBER
Cost without regard to any revaluation.
SHORT_FISCAL_YEAR_
FLAG
Optional
 
VARCHAR2(3)
YES - Asset is in a short fiscal year
NO - Asset is not in a short fiscal year
CONVERSION_DATE
Optional
DATE
Date short tax year asset added to the acquiring company.
ORIG_DEPRN_START_DATE
Optional
DATE
Date short tax year asset begin depreciating in the acquired company's books.
GROUP_ASSET_ID
Optional
NUMBER(15)
Group asset identification number. (CRL Asset). If a defualt value is defined, and you want the value to be NULL, you must pass FND_API.G_MISS_NUM to the Addition API.
GLOBAL_ATTRIBUTE1-20
Optional
VARCHAR2(150)
Reserved for country specific functionality.
GLOBAL_ATTRIBUTE_
CATEGORY
Optional
VARCHAR2(30)
Reserved for country specific functionality.
Table 1 - 5. (Page 3 of 3)


 
ASSET_DEPRN_REC_TYPE Asset Structure
The ASSET_DEPRN_REC_TYPE asset structure contains depreciation information for a given asset. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
YTD_DEPRN
Optional
NUMBER
Year-to-date depreciation expense.
DEPRN_RESERVE
Optional
NUMBER
Total depreciation taken since the beginning of the asset's life.
REVAL_DEPRN_RESERVE
Optional
NUMBER
For a period in which this asset was revalued: The value is the change in net book value due to revaluation of asset cost, and sometimes also the revaluation of depreciation reserve.
For all other periods: The value is the revaluation reserve amount after depreciation is run.
Table 1 - 6. (Page 1 of 1)


 
ASSET_DIST_REC_TYPE Asset Structure
The ASSET_DIST_REC_TYPE asset structure contains information that represents a single source or destination distribution line. All the ASSET_DIST_REC_TYPE records comprising a single transfer transaction are contained in the ASSET_DIST_TBL_TYPE table. At least one source line and at least one destination line are required for each transfer transaction. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
UNITS_ASSIGNED
Required
NUMBER
Number of units assigned to the distribution.
ASSIGNED_TO
Optional
NUMBER(15)
Employee identification number.
EXPENSE_CCID
Required
NUMBER(15)
Depreciation expense account identification number.
LOCATION_CCID
Required
NUMBER(15)
Location flexfield identification number.
Table 1 - 7. (Page 1 of 1)


 
INV_REC_TYPE Invoice Structure
The INV_REC_TYPE invoice structure contains invoice information for a single invoice associated with an asset. The INV_TBL_TYPE is a table of INV_REC_TYPE records. These records contain all invoices that have been applied to the asset. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
FIXED_ASSETS_COST
Required (only when the record is populated)
NUMBER
Cost of asset in Oracle Assets.
PO_VENDOR_ID
Optional
NUMBER(15)
Supplier identification number.
PO_NUMBER
Optional
VARCHAR2(20)
Purchase order number.
INVOICE_NUMBER
Optional
VARCHAR2(50)
Invoice number.
PAYABLES_BATCH_NAME
Optional
VARCHAR2(50)
Name of the payables batch that contained this invoice.
PAYABLES_CODE_
COMBINATION_ID
Optional
NUMBER(15)
Clearing account number to which this line was posted in accounts payable.
FEEDER_SYSTEM_NAME
Optional
VARCHAR2(40)
Name of the feeder system that created the FA_MASS_ADDITIONS row.
CREATE_BATCH_DATE
Optional
DATE
Date the mass additions batch was created for this row.
CREATE_BATCH_ID
Optional
NUMBER(15)
Mass additions create request identification number for this row.
INVOICE_DATE
Optional
DATE
Invoice date from accounts payable.
PAYABLES_COST
Optional
NUMBER
Invoice cost from accounts payable.
POST_BATCH_ID
Optional
NUMBER(15)
Mass Additions Post request identification number for this row.
INVOICE_ID
Optional
NUMBER(15)
Invoice identification number.
AP_DISTRIBUTION_LINE_
NUMBER
Optional
NUMBER(15)
Distribution line identification number.
PAYABLES_UNITS
Optional
NUMBER
Units from AP_INVOICE_ DISTRIBUTIONS row.
DESCRIPTION
Optional
VARCHAR2(80)
Invoice line description.
DELETED_FLAG
Optional
VARCHAR2(3)
Indicates whether this row has been deleted in the CIP Adjustments form. Defaults to NO, which it should be for all addition transactions.
PROJECT_ASSET_LINE_ID
Optional
NUMBER(15)
Identifier of the summarized asst cost line transferred from Oracle Projects to create this line.
PROJECT_ID
Optional
NUMBER(15)
Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.
TASK_ID
Optional
NUMBER(15)
Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is populated only if the costs were summarized by task.
ATTRIBUTE1
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE2
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE3
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE4
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE5
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE6
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE7
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE8
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE9
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE10
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE11
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE12
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE13
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE14
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE15
Optional
VARCHAR2(150)
Descriptive flexfield segment.
ATTRIBUTE_CATEGORY_
CODE
Optional
VARCHAR2(30)
Descriptive flexfield structure defining column.
INV_INDICATOR
Required (only when this record is populated and using MRC and INV_RATE_REC)
NUMBER
Join to INV_RATE_REC. YTD_DEPRN NUMBER Year-to-date deprecation expense.
YTD_DEPRN
Optional
NUMBER
Year-to-date deprecation expense.
DEPRN_RESERVE
Optional
NUMBER
Total deprecation taken since beginning of asset life.
BONUS_YTD_DEPRN
Optional
NUMBER
Bonus year-to-date depreciation expense.
BONUS_DEPRN_RESERVE
Optional
NUMBER
Total bonus depreciation taken since beginning of asset life.
REVAL_AMORTIZATION_
BASIS
Optional
NUMBER
Revaluation reserve used in calculating amortization of revaluation reserve. Value is updated only when the asset is revalued or has an amortized adjustment.
REVAL_YTD_DEPRN
Optional
NUMBER
Year-to-date deprecation expense due to revaluation.
REVAL_DEPRN_RESERVE
Optional
NUMBER
For a period in which this asset was revalued: Change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve.
For all other periods: Revaluation reserve amount after depreciation run.
Table 1 - 8. (Page 4 of 4)


 
INV_RATE_REC_TYPE Invoice Structure
The INV_RATE_REC_TYPE invoice structure contains rate information for an invoice. Each INV_RATE_REC_TYPE record contains one conversion rate. The INV_RATE_TBL_TYPE is a table of INV_RATE_REC_TYPE records. This table is used by MRC reporting books to determine the conversion rates for an asset. The following table shows type and value information for each argument.
Argument
Required / Optional
Type
Value
INV_INDICATOR
Optional - When using MRC, this value and record should generally be populated. If it is not populated, the daily rate is derived based on the transaction date.
NUMBER
Join to INV_REC.
SET_OF_BOOKS_ID
Required - Required when using MRC, and only needed when the record is populated.
NUMBER(15)
Set of books identification number for GL set of books.
EXCHANGE_RATE
Required - Required when using MRC, and only needed when the record is populated.
NUMBER
Exchange rate for the currency.
Table 1 - 9. (Page 1 of 1)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25103190/viewspace-734035/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 键弹性域开发
请登录后发表评论 登录
全部评论

注册时间:2011-08-26

  • 博文量
    55
  • 访问量
    149634