Fixed Assets

July 1, 2017 Oracle Fixed assets (FA) Profile Options

Configurations-FAFixed AssetsOracle Functional

Oracle Fixed assets (FA) Profile Options

Account Generator: Purge Runtime Data

Always set this profile option to Yes to ensure that Oracle Workflow has finished generating accounting flexfield code combinations.

Temporarily set this option to No at the user level if you are debugging the account generator. Running the account generator with this option set to No fills up the workflow tables and slows performance

FA: Allow Swiss Special Assets

Controls whether you can use the Swiss insurance calculation method.

If this profile option is set, when you add insurance details on the Fixed Asset Insurance window, you can check the Special Swiss Assets check box, which signifies that this asset will use the Swiss insurance calculation method.

FA: Archive Table Sizing Factor

This profile option controls the space allotted for the temporary tables created when you archive and purge a book.

The sizing factor specifies how many storage kilobytes to reserve for the initial extent. The default value is 100 kilobytes.

Update this option if you are archiving a large number of records for a fiscal year.

FA: Cache Sizing Factor

This profile option controls the database information retained in the concurrent program for performance improvement. The range is 0 to 25.

FA: Deprn Single

Controls the caching buffer used when you run depreciation. You can set the buffer to either No (20) or Yes (1).

If you set FA: Deprn Single to No, the cache is reset after every 20 assets. If you set FA: Deprn Single to Yes, the cache is reset after every asset.

FA: Generate Expense Account

Allows you to generate the depreciation expense account based on Workflow rules.

When you set this profile option to Yes, Generate Accounts reads the profile option and generates the expense account using Workflow rules. If you do not set this profile option or you set it to No, Generate Accounts uses the expense account entered for an asset in the Assignments window.

FA: Large Rollback Segment Name

This profile option indicates the rollback segment name that Oracle Assets uses for programs requiring large rollback space.

If you do not specify a large rollback segment, Oracle Assets uses the first available rollback segment.

FA: Number Mass Addition Parallel Requests

Controls the number of requests the Mass Additions Post program will run in parallel. When you run the program, Oracle Assets spawns a parent process with several child processes.

Enter a number between 1 and 20 to specify the maximum number of parallel requests you want to allow. The parent process is not included in this number.

FA: Number of Parallel Requests

This profile option controls the number of requests that Oracle Assets programs can run in parallel.

Enter a number between 1 and 20 to specify the maximum number of parallel requests that you want to allow.

FA: Print Debug

This option indicates whether debug tracing messages are printed in concurrent program log files. Support uses these messages to identify a problem with the code.

FA: Print Timing Diagnostics

This option indicates whether timing diagnostic messages are printed in concurrent program log files. Support. uses these messages to identify a problem with the code.

FA: Security Profile

Restricts access to the organizations defined in the security profile. This option is seeded at the site level with the view–all security profile created for the Startup Business Group.

FA: Default DPIS to Invoice Date

Enables you to use the Future Transactions feature by allowing the default date–placed–in–service to be the invoice date, even when the invoice date is in a future accounting period. If you set this profile option to Yes, Oracle Assets defaults the date–placed–in–service to the invoice date for future transactions. If you set this profile option to No, Oracle Assets does not default the date–placed–in–service to the invoice dates, and you cannot use the Future Transactions feature.

FA: Mass Copy All Cost Adjustments

Allows the Mass Copy program to copy all cost adjustments, even when the un-revalued cost is different in the corporate book and the associated tax books.

June 25, 2017 APP-OFA-48723 You cannot delete setup data from a secured responsibility.

Errors/Workarounds-FAFixed AssetsOracle Functional

ERROR

APP-OFA-48723 You cannot delete setup data from a secured responsibility. The data may already be in use by assets or books that you do not have access to. To delete setup data please use a non-secured responsibility.

SOLUTION

This Error is normally Produced when you try to delete an Unused/Wrong Asset Category from any Secured Responsibility

Step 1. Connect to System Administrator responsibility

Step 2. Navigate to Profile > System

Step 3. Query for Profile FA:Security with any FA responsibility.

Step 4. You could temporary remove the profile value in order to delete the wrong Asset category and then reset the profile back.

June 22, 2017 Oracle Application Implementation Methodology (AIM) Document List

Accounts PayablesAccounts ReceivablesCash ManagementFixed AssetsGeneral LedgerOracle Functional

Oracle Application Implementation Methodology (AIM) Document List

1.Business Process Architecture (BP)

BP.010 Define Business and Process Strategy
BP.020 Catalog and Analyze Potential Changes
BP.030 Determine Data Gathering Requirements
BP.040 Develop Current Process Model
BP.050 Review Leading Practices
BP.060 Develop High-Level Process Vision
BP.070 Develop High-Level Process Design
BP.080 Develop Future Process Model
BP.090 Document Business Procedure

2. Business Requirements Definition (RD)

RD.010 Identify Current Financial and Operating Structure
RD.020 Conduct Current Business Baseline
RD.030 Establish Process and Mapping Summary
RD.040 Gather Business Volumes and Metrics
RD.050 Gather Business Requirements
RD.060 Determine Audit and Control Requirements
RD.070 Identify Business Availability Requirements
RD.080 Identify Reporting and Information Access Requirements

3. Business Requirements Mapping

BR.010 Analyze High-Level Gaps
BR.020 Prepare mapping environment
BR.030 Map Business requirements
BR.040 Map Business Data
BR.050 Conduct Integration Fit Analysis
BR.060 Create Information Model
BR.070 Create Reporting Fit Analysis
BR.080 Test Business Solutions
BR.090 Confirm Integrated Business Solutions
BR.100 Define Applications Setup
BR.110 Define security Profiles

4. Application and Technical Architecture (TA)

TA.010 Define Architecture Requirements and Strategy
TA.020 Identify Current Technical Architecture
TA.030 Develop Preliminary Conceptual Architecture
TA.040 Define Application Architecture
TA.050 Define System Availability Strategy
TA.060 Define Reporting and Information Access Strategy
TA.070 Revise Conceptual Architecture
TA.080 Define Application Security Architecture
TA.090 Define Application and Database Server Architecture
TA.100 Define and Propose Architecture Subsystems
TA.110 Define System Capacity Plan
TA.120 Define Platform and Network Architecture
TA.130 Define Application Deployment Plan
TA.140 Assess Performance Risks
TA.150 Define System Management Procedures

5. Module Design and Build (MD)

MD.010 Define Application Extension Strategy
MD.020 Define and estimate application extensions
MD.030 Define design standards
MD.040 Define Build Standards
MD.050 Create Application extensions functional design
MD.060 Design Database extensions
MD.070 Create Application extensions technical design
MD.080 Review functional and Technical designs
MD.090 Prepare Development environment
MD.100 Create Database extensions
MD.110 Create Application extension modules
MD.120 Create Installation routines

6. Data Conversion (CV)

CV.010 Define data conversion requirements and strategy
CV.020 Define Conversion standards
CV.030 Prepare conversion environment
CV.040 Perform conversion data mapping
CV.050 Define manual conversion procedures
CV.060 Design conversion programs
CV.070 Prepare conversion test plans
CV.080 Develop conversion programs
CV.090 Perform conversion unit tests
CV.100 Perform conversion business objects
CV.110 Perform conversion validation tests
CV.120 Install conversion programs
CV.130 Convert and verify data

7. Documentation (DO)

DO.010 Define documentation requirements and strategy
DO.020 Define Documentation standards and procedures
DO.030 Prepare glossary
DO.040 Prepare documentation environment
DO.050 Produce documentation prototypes and templates
DO.060 Publish user reference manual
DO.070 Publish user guide
DO.080 Publish technical reference manual
DO.090 Publish system management guide

8. Business System Testing (TE)

TE.010 Define testing requirements and strategy
TE.020 Develop unit test script
TE.030 Develop link test script
TE.040 Develop system test script
TE.050 Develop systems integration test script
TE.060 Prepare testing environments
TE.070 Perform unit test
TE.080 Perform link test
TE.090 perform installation test
TE.100 Prepare key users for testing
TE.110 Perform system test
TE.120 Perform systems integration test
TE.130 Perform Acceptance test

9. PERFORMANCE TESTING (PT)

PT.010 – Define Performance Testing Strategy
PT.020 – Identify Performance Test Scenarios
PT.030 – Identify Performance Test Transaction
PT.040 – Create Performance Test Scripts
PT.050 – Design Performance Test Transaction Programs
PT.060 – Design Performance Test Data
PT.070 – Design Test Database Load Programs
PT.080 – Create Performance Test TransactionPrograms
PT.090 – Create Test Database Load Programs
PT.100 – Construct Performance Test Database
PT.110 – Prepare Performance Test Environment
PT.120 – Execute Performance Test

10. Adoption and Learning (AP)

AP.010 – Define Executive Project Strategy
AP.020 – Conduct Initial Project Team Orientation
AP.030 – Develop Project Team Learning Plan
AP.040 – Prepare Project Team Learning Environment
AP.050 – Conduct Project Team Learning Events
AP.060 – Develop Business Unit Managers’Readiness Plan
AP.070 – Develop Project Readiness Roadmap
AP.080 – Develop and Execute CommunicationCampaign
AP.090 – Develop Managers’ Readiness Plan
AP.100 – Identify Business Process Impact onOrganization
AP.110 – Align Human Performance SupportSystems
AP.120 – Align Information Technology Groups
AP.130 – Conduct User Learning Needs Analysis
AP.140 – Develop User Learning Plan
AP.150 – Develop User Learningware
AP.160 – Prepare User Learning Environment
AP.170 – Conduct User Learning Events
AP.180 – Conduct Effectiveness Assessment

11. Production Migration (PM)

PM.010 – Define Transition Strategy
PM.020 – Design Production Support Infrastructure
PM.030 – Develop Transition and Contingency Plan
PM.040 – Prepare Production Environment
PM.050 – Set Up Applications
PM.060 – Implement Production Support Infrastructure
PM.070 – Verify Production Readiness
PM.080 – Begin Production
PM.090 – Measure System Performance
PM.100 – Maintain System
PM.110 – Refine Production System
PM.120 – Decommission Former Systems
PM.130 – Propose Future Business Direction
PM.140 – Propose Future Technical Direction

June 20, 2017 APP-OFA-47333: You Cannot Perform this transaction

Errors/Workarounds-FAFixed AssetsOracle Functional

ERROR

APP-OFA-47333: You Cannot Perform this transaction because the asset is fully retired. Choose a book in which you have not yet retired the asset, or reinstate the asset, and then perform the transaction. If you wish to cancel or undo the retirement, Please query it first.

SOLUTION

Step 1. Navigate to Inquiry > Transaction History.

Step 2. Enter the Book & Asset Number.

Step 3. Press the Find button.

Step 4. Click the Transaction type field for the Retired Asset.

Step 5. Note the Reference Number.

Step 6. Go to the Asset Workbench and query the Asset.

Step 7. Click the Retirements button.

Step 8. As the Retirements screen is displayed:

a. Press F11 to query or select Query>Enter on the menu bar.

b. Enter the Reference Number noted above.

c. Press CTRL F11 to perform the query or select Query>Run from the menu bar.

Step 9. As information appears on the screen, verify if it is correct and press the Reinstate button.

Step 10. Run the Calculate Gains and Losses program.

(more…)