FA Application Program Interfaces

Tags:

fa2 technical2 create new tag

Introduction

Here is a list of Application Program Interfaces (APIs) that can be used to convert data or make bulk transactions for Oracle Assets. These APIs can be used to automate many common FA transactions and still maintain the integrity of the FA application's logic, validation, and processing constraints. The APIs can be used as an alternate to using forms-based data entry.

Generally, you must use the PL/SQL programming language to use these APIs. You must also prepare and organize a source (usually a table or file from another system) for these transactions. In the appendices of the Release 12 FA Users Guide, there are sample scripts that illustrate how to use PL/SQL and the API to perform transactions.

List of APIs

Note that the appendix reference refers to the Oracle documentation in the Release 12 FA Users Guide (file name = 120faug.pdf). In these appendices, Oracle provides a detailed description for each API argument

• Common Structures (appendix F)
  • TRANS_REC_TYPE -asset transaction information
  • ASSET_HDR_REC_TYPE - unique header information about each asset
  • ASSET_DESC_REC_TYPE - descriptive information about an asset
  • ASSET_TYPE_REC_TYPE - indicates if the asset is of type CIP, group, capitalized, or expensed
  • ASSET_CAT_REC_TYPE - information about asset category
  • ASSET_HIERARCHY_REC_TYPE - information used if the asset is in a hierarchy
  • ASSET_FIN_REC_TYPE - financial information about the asset
  • ASSET_DEPRN_REC_TYPE - depreciation information about an asset
  • ASSET_DIST_REC_TYPE - account or source distribution line information
  • INV_TRANS_REC_TYPE - invoice transaction information for an AP invoice
  • INV_REC_TYPE - invoice information for an AP invoice
  • INV_RATE_REC_TYPE - currency exchange rate information for an AP invoice
  • ASSET_RETIRE_REC_TYPE - retirement information
  • ASSET_RETIRE_DET_REC_TYPE - detailed retirement information
  • ASSET_HR_ATTR_REC_TYPE - information about the hierarchy attributes of an asset
  • ASSET_HR_OPTIONS_REC_TYPE - information about changes to hierarchy options
  • SUBCOMP_REC_TYPE - refers to child assets that belong to a parent (sub-components)
  • PERIOD_REC_TYPE -information about depreciation periods
  • RECLASS_OPTIONS_REC_TYPE - refers to reclass options that may change during a reclass transaction
  • GROUP_RECLASS_OPTIONS_REC_TYPE - reclass option information for grouped asset reclassifications
  • UNPLANNED_DEPRN_REC_TYPE - contains unplanned depreciation information
  • STANDARD_WHO_REC_TYPE - information about the user making the transaction
  • DESC_FLEX_REC_TYPE - contains descriptive flexfield information
• FA_RETIREMENT_PUB.DO_RETIREMENT - retirement transactions(appendix R)
• FA_RETIREMENT_PUB.UNDO_RETIREMENT -retirement transactions (appendix R)
• FA_RETIREMENT_ADJUSTMENT_PUB.DO_RETIREMENT_ADJUSTMENT - enter the cost of removal and proceeds of sale directly to the group asset (appendix P)
• FA_ASSET_DESC_PUB.UPDATE_RETIREMENT_DESC - perform select changes to an existing retirement (appendix Q)
• FA_RETIREMENT_PUB.DO_REINSTATEMENT - reinstate previous retirements (appendix R)
• FA_RETIREMENT_PUB.UNDO_REINSTATEMENT - undo a previous reinstatement (appendix R)
• FA_ADDITION_PUB.DO_ADDITION - add assets (used by mass additions)(appendix G)
• FA_ADJUSTMENT_PUB.DO_ADJUSTMENT -process adjustments (appendix H)
• FA_TRANSFER_PUB.DO_TRANSFER - make transfers similar to the asset workbench or mass transfers functions (appendix V)
• FA_INV_XFR_PUB.DO_TRANSFER - Invoice transfer from Oracle AP (appendix K)
• FA_RECLASS_PUB.DO_RECLASS - perform reclassification similar to workbench and mass change reclassifications (appendix N)
• FA_UNPLANNED_PUB.DO_UNPLANNED - perform unplanned depreciation transactions (appendix X)
• FA_DEPRN_ROLLBACK_PUB.DO_ROLLBACK - perform rollback depreciation (appendix T)
• FA_ASSET_DESC_PUB.UPDATE_DESC -update descriptive information about an asset (appendix I)
• FA_UNIT_ADJ_PUB.DO_UNIT_ADJUSTMENT - perform unit adjustments (appendix W)
• FA_REVALUATION_PUB.DO_REVAL - revaluation of assets directly (rather than mass revaluation) (appendix S)
• FA_CIP_PUB.DO_CAPITALIZATION - capitalize an asset (appendix J)
• FA_CIP_PUB.DO_REVERSE - reverse capitalization of an asset (appendix J)
• FA_DELETION_PUB.DO_DELETE - asset deletion (only available when the asset is not yet processed in subledger accounting) (appendix L)
• FA_ASSET_DESC_PUB.UPDATE_INVOICE_DESC - change AP invoice description information within Oracle FA (appendix M)
• FA_RESERVE_TRANSFER_PUB.DO_RESERV_TRANSFER- perform transfer of accumulated depreciation from one group asset to another (appendix O)
• FA_TAX_RSV_ADJ_PUB.DO_TAX_RSV_ADJ - perform adjustments similar to the tax workbench (appendix U)

Comments

Links

• Related: OracleAssets, FA12AssetsAssetWorkbench, FA12TaxTaxWorkbench, FA12MassAdditionsPostMassAdditions

This Topic Is Referenced By These Topics:
Related Links: WebStatistics

Was This Topic Useful to You?

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Somewhat Useful (5) Very Useful (4) Not Useful (3)

Collaborating Authors and Reviewers: -- TWikiGuest - 20 May 2012