Project Accounting
Project Accounting
Costing
Items not costed
The output of the labor cost distribution cost distribution shows the error as Missing Cost Rate. This happens for Sub-Contractors when they do not have a Cost Rate setup. For employees the costing is based on the Job Grade but for Sub-contractors the costing is based on the Cost Rate setup. All Sub-contractors should have a Cost Rate set up.
Labor Cost Distribution Program does not pick up items
When giving a PA Date for the Cost distribution program, the date always has to be a Friday, if otherwise, the process will not pick up any items. This is applicable even if the week is a split week, i.e., the month end falls in midweek and the costing needs to be done for that month.
Items wrongly costed
The costing for employees is based on the business rule that ‘Maximum available hours per person per week unless the total hours that are billable are greater than the available hours’. This implies that the Costing for Billable Tasks will be as per the Cost Rate and any non-billable cost will be pro-rated as per the billable time entered and the maximum available hours.
E.g.
If an employee has coded 40 hours on billable task and 10 hours on non-billable task, then the non-billable time will be zero-costed (assuming that the maximum available hours for the week is 40)
If an employee has coded 30 hours on billable task and 15 hours on non-billable task, then the 15 hours on non-billable will be pro-rated for 10 hours. This will result in the Cost Rate for these items being less than the Standard Cost Rate.
Signal-11 error when running the Distribute Labor Cost program
This happens sometimes when the number of items that are being picked for distribution is very high. To avoid this, run the cost distribution in batches for one week at a time or one project at a time.
Reversed Time Items zero costed
The original items are cost distributed and the Project burden shows the correct value but the reversed items shows zero cost.
This happens when the items are reversed before they are cost distributed. Hence the reversed items will be zero-costed, as there is no cost rate attached to the original items. To rectify this, negative items have to be created through pre-approved expenditure batch, then before costing this batch has to be reversed. Finally, the cost should be distributed. This will correct the cost and also the hours charged so that the URVE is not affected.
Expense Report / Supplier Invoice items not costed
Expense Report / Supplier Invoice items are already costed when they are imported into PA. But when these items are adjusted i.e. transferred or reversed, the adjusted items will not be cost distributed. To do this, the Distribute Expense Report Cost process or the Distribute Supplier Invoice Adjustment Costs should be executed.
Agreements, Funding and Budgets
Budget cannot be baselined - Funding not equal to budget
The Funding amount is not the same as the budget. Specify the correct amount as in funding. Also, the budget should be at the same level as the funding, e.g. if the funding is at project level then the budget should also be at project level or if the funding is at task level then the budget should also be at task level
Also, sometimes when a funding line is created and then deleted, the budget amount will not match the funds. In these cases, the funding lines will have to be checked in the database and the amount equal to funding will have to be entered in the budget.
Note: When the Project start or end date is changed, the budget has to be re-baselined.
Revenue Generation
Items are not picked up for revenue
The time and expense items coded to a Billable task will only be picked up for Revenue Generation. All items coded to Non-Billable Task will not generate revenue. The billable flag for an item can be checked in the expenditure inquiry screen by choosing the Billable_Flag field from Show Field in the Folder Menu. This has to be checked for the item to be eligible for revenue generation.
The items have to be Cost distributed before they can generate revenue.
Also, the item date should be before the “accrue through date” when the generate revenue process is executed.
Events are not generated
The event date should be before the “accrue through date” when the generate revenue process is executed.
No Funding
An agreement and funding are not created for this project. Before generating revenue for a project, an agreement and funding have to be created and an approved revenue budget should be baselined.
Revenue has reached hard limit
Revenue generation is based on the agreement. If the agreement has a hard limit defined (the hard limit check box will be ticked), then revenue cannot be generated beyond the amount specified. To rectify this, either remove the hard limit or increase the funding.
Invoice Generation
No active event or expenditure items
The time and expense items coded to a Billable task will only be picked up for Invoice Generation. All items coded to Non-Billable Task will not be picked up for invoicing. The billable flag for an item can be checked in the expenditure inquiry screen by choosing the Billable_Flag field from Show Field in the Folder Menu.
The items have to be Cost distributed before they can generate revenue.
Also, the item date should be before the “bill through date” when the generate invoice process is executed.
For an event, the event date should be before the “ bill through date “ and should not have a bill hold.
Project not picked up when the Invoices are generated for a Range of Projects
When generating invoices for a range of projects, a project will not be picked for invoicing if the “next billing date” is after the current date. This can be checked in the Project Options -> Billing Set up -> Billing Assignments.
Interfacing Cost to GL
No Open Period
The GL period to which the items belong is not open in GL. Open the period and run the interface program again.
Interfacing Revenue to GL
No Open Period
The GL period to which the revenue lines belong is not open in GL. Open the period and run the interface program again.
Interfacing Invoices to AR
No Output Tax Code
The Tax Code in the Invoice lines is not available. Attach a tax code to the invoice lines and then run the interface program again.
No Open Period
The GL period to which the invoice lines belong is not open in GL and/or AR. Open the period and run the interface program again.
Interfacing Expense Report / Supplier Invoice Adjustments from and to AP
Project Status does not allow transactions
The project to which an expense item belongs should be ACTIVE. All items charged to Project, which is CLOSED or PENDING CLOSE would not be picked up by the interface program. To interface these items to PA, the project statuses have to be changed to ACTIVE and then the interface program needs to be run.
Transaction Exceptions
No Open Period
The GL Period in which the cost or revenue items belong might be closed. In case of invoices, the GL Period and / or the AR Period might be closed.
Costing Exceptions
Undefined
The journal import for the cost items is not done. The journal import in GL should be executed and then the tieback labor cost from GL program in PA has to be executed.
Revenue Exceptions
Undefined
The journal import for the revenue items is not done. The journal import in GL should be executed and then the tieback revenue from GL program in PA has to be executed.
Invoicing Exceptions
New Line not Processed in PA
The supplier invoice or expense reports in AP have not been interfaced to PA. To get these invoices / expense reports into PA, they have to approved and accounted and then the interface program in PA has to be executed.
No Assignment
The employee who has created an expense report might have been end dated. Hence these items will not be interfaced to PA from AP. To rectify this error, change the Supplier Type in AP of the employee from employee to supplier and then run the interface supplier invoice interface program.
Reports
The Project related reports – PDR, PCR and WIP & AR Reports will not pick a project if a Project Manager or Account Manager is not attached to the report.
The project related reports – PDR, PCR and WIP & AR Reports will pick data as per the GL Date of the Expenditure Items and not as per the Expenditure Item Date. Hence the reports might not match with the extract taken from Expenditure Inquiry screen if the item date has a different GL Date.
The Emailing program will not run for Internal Projects. The reports will be emailed to the concerned employee only if the person is set up as the Project / Account Manager / Project Controller of the Project.
Costing
Items not costed
The output of the labor cost distribution cost distribution shows the error as Missing Cost Rate. This happens for Sub-Contractors when they do not have a Cost Rate setup. For employees the costing is based on the Job Grade but for Sub-contractors the costing is based on the Cost Rate setup. All Sub-contractors should have a Cost Rate set up.
Labor Cost Distribution Program does not pick up items
When giving a PA Date for the Cost distribution program, the date always has to be a Friday, if otherwise, the process will not pick up any items. This is applicable even if the week is a split week, i.e., the month end falls in midweek and the costing needs to be done for that month.
Items wrongly costed
The costing for employees is based on the business rule that ‘Maximum available hours per person per week unless the total hours that are billable are greater than the available hours’. This implies that the Costing for Billable Tasks will be as per the Cost Rate and any non-billable cost will be pro-rated as per the billable time entered and the maximum available hours.
E.g.
If an employee has coded 40 hours on billable task and 10 hours on non-billable task, then the non-billable time will be zero-costed (assuming that the maximum available hours for the week is 40)
If an employee has coded 30 hours on billable task and 15 hours on non-billable task, then the 15 hours on non-billable will be pro-rated for 10 hours. This will result in the Cost Rate for these items being less than the Standard Cost Rate.
Signal-11 error when running the Distribute Labor Cost program
This happens sometimes when the number of items that are being picked for distribution is very high. To avoid this, run the cost distribution in batches for one week at a time or one project at a time.
Reversed Time Items zero costed
The original items are cost distributed and the Project burden shows the correct value but the reversed items shows zero cost.
This happens when the items are reversed before they are cost distributed. Hence the reversed items will be zero-costed, as there is no cost rate attached to the original items. To rectify this, negative items have to be created through pre-approved expenditure batch, then before costing this batch has to be reversed. Finally, the cost should be distributed. This will correct the cost and also the hours charged so that the URVE is not affected.
Expense Report / Supplier Invoice items not costed
Expense Report / Supplier Invoice items are already costed when they are imported into PA. But when these items are adjusted i.e. transferred or reversed, the adjusted items will not be cost distributed. To do this, the Distribute Expense Report Cost process or the Distribute Supplier Invoice Adjustment Costs should be executed.
Agreements, Funding and Budgets
Budget cannot be baselined - Funding not equal to budget
The Funding amount is not the same as the budget. Specify the correct amount as in funding. Also, the budget should be at the same level as the funding, e.g. if the funding is at project level then the budget should also be at project level or if the funding is at task level then the budget should also be at task level
Also, sometimes when a funding line is created and then deleted, the budget amount will not match the funds. In these cases, the funding lines will have to be checked in the database and the amount equal to funding will have to be entered in the budget.
Note: When the Project start or end date is changed, the budget has to be re-baselined.Revenue Generation
Items are not picked up for revenue
The time and expense items coded to a Billable task will only be picked up for Revenue Generation. All items coded to Non-Billable Task will not generate revenue. The billable flag for an item can be checked in the expenditure inquiry screen by choosing the Billable_Flag field from Show Field in the Folder Menu. This has to be checked for the item to be eligible for revenue generation.
The items have to be Cost distributed before they can generate revenue.
Also, the item date should be before the “accrue through date” when the generate revenue process is executed.
Events are not generated
The event date should be before the “accrue through date” when the generate revenue process is executed.
No Funding
An agreement and funding are not created for this project. Before generating revenue for a project, an agreement and funding have to be created and an approved revenue budget should be baselined.
Revenue has reached hard limit
Revenue generation is based on the agreement. If the agreement has a hard limit defined (the hard limit check box will be ticked), then revenue cannot be generated beyond the amount specified. To rectify this, either remove the hard limit or increase the funding.
Invoice Generation
No active event or expenditure items
The time and expense items coded to a Billable task will only be picked up for Invoice Generation. All items coded to Non-Billable Task will not be picked up for invoicing. The billable flag for an item can be checked in the expenditure inquiry screen by choosing the Billable_Flag field from Show Field in the Folder Menu.
The items have to be Cost distributed before they can generate revenue.
Also, the item date should be before the “bill through date” when the generate invoice process is executed.
For an event, the event date should be before the “ bill through date “ and should not have a bill hold.
Project not picked up when the Invoices are generated for a Range of Projects
When generating invoices for a range of projects, a project will not be picked for invoicing if the “next billing date” is after the current date. This can be checked in the Project Options -> Billing Set up -> Billing Assignments.
Interfacing Cost to GL
No Open Period
The GL period to which the items belong is not open in GL. Open the period and run the interface program again.
Interfacing Revenue to GL
No Open Period
The GL period to which the revenue lines belong is not open in GL. Open the period and run the interface program again.
Interfacing Invoices to AR
No Output Tax Code
The Tax Code in the Invoice lines is not available. Attach a tax code to the invoice lines and then run the interface program again.
No Open Period
The GL period to which the invoice lines belong is not open in GL and/or AR. Open the period and run the interface program again.
Interfacing Expense Report / Supplier Invoice Adjustments from and to AP
Project Status does not allow transactions
The project to which an expense item belongs should be ACTIVE. All items charged to Project, which is CLOSED or PENDING CLOSE would not be picked up by the interface program. To interface these items to PA, the project statuses have to be changed to ACTIVE and then the interface program needs to be run.
Transaction Exceptions
No Open Period
The GL Period in which the cost or revenue items belong might be closed. In case of invoices, the GL Period and / or the AR Period might be closed.
Costing Exceptions
Undefined
The journal import for the cost items is not done. The journal import in GL should be executed and then the tieback labor cost from GL program in PA has to be executed.
Revenue Exceptions
Undefined
The journal import for the revenue items is not done. The journal import in GL should be executed and then the tieback revenue from GL program in PA has to be executed.
Invoicing Exceptions
New Line not Processed in PA
The supplier invoice or expense reports in AP have not been interfaced to PA. To get these invoices / expense reports into PA, they have to approved and accounted and then the interface program in PA has to be executed.
No Assignment
The employee who has created an expense report might have been end dated. Hence these items will not be interfaced to PA from AP. To rectify this error, change the Supplier Type in AP of the employee from employee to supplier and then run the interface supplier invoice interface program.
Reports
The Project related reports – PDR, PCR and WIP & AR Reports will not pick a project if a Project Manager or Account Manager is not attached to the report.
The project related reports – PDR, PCR and WIP & AR Reports will pick data as per the GL Date of the Expenditure Items and not as per the Expenditure Item Date. Hence the reports might not match with the extract taken from Expenditure Inquiry screen if the item date has a different GL Date.
The Emailing program will not run for Internal Projects. The reports will be emailed to the concerned employee only if the person is set up as the Project / Account Manager / Project Controller of the Project.
ITime
ITime
Timecard Issues
Timecard Status shows SUBMITTED and not APPROVED
This issue happens in two cases –
An Oracle Bug in iTime Workflow that makes the Timecards to be stuck in the Approval process. A TAR has been raised with Oracle and resolution expected from them.
The Timecard is Submitted by the Secretary / Personal Assistant on behalf of the Sub-Contractor. In this case the Approval process gets stuck if the Sub-Contractor does not have a Renaissance userid. To rectify this, userids need to be created for All Sub-Contractor
A lot of timecards get stuck in the Approval Process since the Sub-Contractor is not created as a user and hence the need for manually pushing these timecards. To avoid this, it is imperative that the userid is created for Sub-Contractors also.
Timecard not imported
The Timecard might be in SUBMITTED or WORKING status. The Transaction Import will pick up only those timecards, which are APPROVED.
Missing Timecard Report showing the employee’s name even though the timecard was submitted
The Missing Timecard report will show an employee’s name if any of his Timecard is in WORKING status not necessarily the latest one.
Project not appearing in the Drop down list
When a project does not appear in the dropdown list, it means that the project is closed / pending close or the project completion date is before the current date. This Project is hence not available for entering new transactions. Please contact the respective project controller / project manager to change the project start or end dates.
Error Messages when submitting timecard
End-of-File on Communication Channel
This error occurs when there is a problem in the connectivity. Try to submit after sometime and if still unable log an issue with the renaissance helpdesk. Please find below the screen shot for this error.
Transaction Control Violated
This error occurs when there is a Transaction Control on a particular Project / Task, which stops the employee from entering timecard to the project / task. The employee needs to check with the Project Manager / Project Controller if he / she is entitled to code to the Project / Task. Please find below the screen shot for this error
For the above-mentioned errors, the users are requested to check this before they log an issue with Renaissance AM.
Item dates do not fall with Active Dates of the Project / Tasks
The time charged to the Task / Project is not within the active dates of the projects. Please contact your project controller / project manager to change the project start or end dates.
End-of-file on Communication Channel
Transaction Control Violation
Timecard Issues
Timecard Status shows SUBMITTED and not APPROVED
This issue happens in two cases –
An Oracle Bug in iTime Workflow that makes the Timecards to be stuck in the Approval process. A TAR has been raised with Oracle and resolution expected from them.
The Timecard is Submitted by the Secretary / Personal Assistant on behalf of the Sub-Contractor. In this case the Approval process gets stuck if the Sub-Contractor does not have a Renaissance userid. To rectify this, userids need to be created for All Sub-Contractor
A lot of timecards get stuck in the Approval Process since the Sub-Contractor is not created as a user and hence the need for manually pushing these timecards. To avoid this, it is imperative that the userid is created for Sub-Contractors also.
Timecard not imported
The Timecard might be in SUBMITTED or WORKING status. The Transaction Import will pick up only those timecards, which are APPROVED.
Missing Timecard Report showing the employee’s name even though the timecard was submitted
The Missing Timecard report will show an employee’s name if any of his Timecard is in WORKING status not necessarily the latest one.
Project not appearing in the Drop down list
When a project does not appear in the dropdown list, it means that the project is closed / pending close or the project completion date is before the current date. This Project is hence not available for entering new transactions. Please contact the respective project controller / project manager to change the project start or end dates.
Error Messages when submitting timecard
End-of-File on Communication Channel
This error occurs when there is a problem in the connectivity. Try to submit after sometime and if still unable log an issue with the renaissance helpdesk. Please find below the screen shot for this error.
Transaction Control Violated
This error occurs when there is a Transaction Control on a particular Project / Task, which stops the employee from entering timecard to the project / task. The employee needs to check with the Project Manager / Project Controller if he / she is entitled to code to the Project / Task. Please find below the screen shot for this error
For the above-mentioned errors, the users are requested to check this before they log an issue with Renaissance AM.
Item dates do not fall with Active Dates of the Project / Tasks
The time charged to the Task / Project is not within the active dates of the projects. Please contact your project controller / project manager to change the project start or end dates.
End-of-file on Communication Channel
Transaction Control Violation
FIXED ASSETS
FIXED ASSETS
1. What is unplanned depreciation?
Answer: Unplanned depreciation is a feature used primarily to comply with special
depreciation accounting rules in Germany and the Netherlands. However, you
also can use this feature to handle unusual accounting situations in which
you need to adjust the net book value and accumulated depreciation amounts
for an asset without affecting its cost. Oracle Assets immediately updates
the YTD and LTD depreciation and the net book value of the asset. The
unplanned depreciation expense you enter must not exceed the current net
book value (Cost - Salvage Value - Accumulated Depreciation) of the asset.
2. Can depreciation be suspended for a specified period of time?
Answer: Depreciation can be suspended at any time by changing the depreciate flag
on the book form to NO. Note that the total depreciation to be taken over
the life of the asset (including that incurred in periods the flag was set
to NO) will still be taken over the original life assigned to the asset. If
the asset was added with the depreciate flag set to NO, missed depreciation
will be caught up in the period the flag is changed to YES. If the asset
was added with the depreciate flag set to YES and the flag was later changed
to NO, the missed depreciation will be caught up in the last period of the
asset's ORIGINAL life; suspending depreciation will not extend the period
over which the asset is depreciated.
The Depreciate flag can also be set at the category level.
If you set the depreciate flag at the asset level, this will override the category
depreciate flag which is the default.
If the intention is to never have the asset Depreciate then the flag Depreciate
flag should be set to 'No' for the life of the asset or the asset can be entered
into the system fully reserved.
3. Can depreciation expense be manually input to override the system?
Answer: Depreciation reserve adjustments can be made to a TAX book. From Release
10.7, with unplanned depreciation you may manually override the depreciation
amount taken in the Corporate book. The depreciation amount cannot be
greater than the net book value of the asset.
4. How does the Depreciate When Placed In Service flag on my prorate
convention affect the calculation and allocation of depreciation?
Answer: With the exception of the method type Calculated Straight Line,
depreciation for the year is calculated based on the prorate date which maps
to a prorate period and rate on the prorate calendar. This total amount is
then allocated back to the individual periods in the year. If this flag is
set to NO, the years depreciation will be spread over the periods beginning
with the prorate date. If the flag is set to YES, the years depreciation
will be spread over the periods beginning with the date placed in service.
Note that total depreciation for the year remains unchanged, only
depreciation per period will differ.
When the method type Calculated Straight Line is used, this flag has no
effect. Yearly depreciation will be calculated as recoverable cost/life,
and allocated beginning with the prorate date.
5. GAAP defines two types of changes; changes in estimates which are to be
handled prospectively and errors which are to be retroactively corrected.
What Oracle functionality addresses these?
Answer: Expense an adjustment for correction of an error, amortize the adjustment
for a change in estimate.
6. How do I set up Oracle Assets to charge a half-month's depreciation in the
first and last periods of the assets life?
Answer: You must do the following:
a. Set up a prorate CALENDAR with semi-monthly periods. So your prorate
calendar will have 24 periods per fiscal year.
Example:
Period 1: Jan 01 - Jan 15
Period 2: Jan 16 - Jan 31
Period 3: Feb 01 - Feb 15
Period 4: Feb 16 - Feb 28
Period 5: Mar 01 - Mar 15 ...
b. Set up a prorate CONVENTION that maps the appropriate dates to the
middle of the month.
Example:
Jan 01 - Jan 31 map to Jan 16
Feb 01 - Feb 28 map to Feb 16
Mar 01 - Mar 31 map to Mar 16 ...
c. Assign your book to the appropriate prorate CALENDAR in the Book
Controls form. (You will also probably want it to depreciate EVENLY).
d. Set the default prorate convention to the appropriate mid-month
convention in the Default Depreciation Rules zone of the Asset
Categories form. You can also specify the prorate CONVENTION in the
Books window during the Detail Additions process.
Now when the depreciation program processes an asset whose date placed in
service is Jan 10, it will use the prorate convention to map that date to a
PRORATE DATE of Jan 16, and it will use the prorate date to map to
PRORATE PERIOD #2 in your prorate calendar. Thus, if you are running
depreciation for January (note that your DEPRECIATION CALENDAR can still
be monthly), you will get half a month's worth of depreciation for January.
*** It is not enough to set the prorate convention to a mid-month convention -
*** you must also set the prorate CALENDAR to be semi-monthly.
7. What is the difference between the new What-If feature and the old
depreciation projections functionality?
Answer: Using What-If Analysis, you can model depreciation scenarios for any number
of future periods based on depreciation attributes different from what you
have currently set up for the asset. Hence the name: What If Analysis.
Using Depreciation Projection, you can project depreciation expense based
on the asset's current depreciation method, life, etc.
Additionally, What-If Analysis is very flexible in allowing you to select a
subset of assets for analysis. Selection criteria include Range of Asset
Numbers, Range of Dates Placed in Service, Asset Category etc. For
Depreciation Projections, you must specify a BOOK and the program selects
all active assets for that book.
8. When I run depreciation I get the following error:
"Error: function fafbgcc returned failure (called from fadoflx) Getting
account CCID"
How do I correct this problem?
Answer: Set the profile options FA:PRINT_DEBUG and FA:DEPRN SINGLE to YES and
rerun depreciation. Make note of the asset number and distribution id.
Depreciation tries to build a code combination id (CCID) for one of the
following:
Asset Cost Account/CIP Cost Acct (Current Period Asset Clearing
Account)/CIP Clearing Acct (Current Period Adds) Depreciation Expense
Account (Prior Period Additions)
Check whether Allow Dynamic Inserts is being allowed for the Accounting
Flexfield (AFF).
Navigation:
Setup -> Financials -> Flexfields -> Segments -> Key
Query for Oracle General Ledger - Accounting Flexfield
If the Allow Dynamic Inserts box is not checked, unfreeze the flexfield
definition, check the box, refreeze and Compile. If it is already checked,
that means the combination generated is not valid. To find out what
combination is being generated, do the following:
Find out which category the asset belongs to by querying for the asset in
the Asset Workbench (Navigation: Assets -> Asset Workbench). Then query for
the asset category/book combination in the Asset Categories form
(Navigation: Setup -> Asset System -> Asset Categories). Using the Help ->
Tools -> Examine function from the menu, get the following information:
Account segment value for Asset Cost/Cost Clearing accounts
(or CIP Cost/CIP Clearing accounts if asset is CIP)
Code combination id (CCID) associated with these accounts
From the Book Controls form, you need to get the Default CCID for the
book utilizing Help -> Tools -> Examine method
(N)Setup -> Asset System -> Book Controls.
From the Inquiry/Financial Information form, you need to get the
distribution CCID for the asset utilizing the same method
(N)Inquiry -> Financial Information -> Assignments form.
Once you have the parameters, in Release 11 run the script faxagtst.sql
to see what combination is getting built and why it is failing.
For details on using faxagtst.sql, see Note 1062849.6
In Release 10.7, you will need to perform a Flexbuilder Test in the
application.
(N)Setup -> Financials -> Flexfields -> Flexbuilder -> Test
9. What depreciation methods are supported within Oracle Assets?
Answer: You may choose from the following:
Straight-line
Declining balance
Sum-of-year's digits
Units of production
ACRS and MACRS
Flat rate
Diminishing value
Bonus depreciation
In Release 11i, you will also be able to create formula-based methods
for depreciation.
10. When should I run the depreciation program?
Answer: For Release 10.7 and 11:
You should run depreciation when you are ready to close your depreciation
period. Depreciation cannot be rolled back once run. Since the depreciation
program closes the period, you should make sure that you entered all your
transactions for the current period. If you forget to enter a transaction in
the current period, you can enter a retroactive addition, transfer, or
retirement transaction in the following period. Oracle Assets will not
calculate adjustments to depreciation until you run depreciation again.
For Release 11i:
You can now run Depreciation as many times as you would like without closing
the period. When you are ready to close the period, on your final
Depreciation run, you would check the Close Period button on the form.
You have the capability in 11i to rollback depreciation. So if you run
Depreciation and you do not like the results, you can rollback Depreciation,
make your changes, and submit Depreciation again. Once the final Depreciation
has been run and the period is closed, you cannot rollback Depreciation for
the period. If you are closing the last period for a fiscal year, you cannot
enter a retroactive retirement for a period after the end of the year.
11. How often can I run depreciation?
Answer: For Release 10.7 and 11:
You can run depreciation only once per depreciation period. When you run
depreciation and close the period, you cannot reopen that period. You must
run depreciation for each corporate and tax book; Oracle Assets does not run
depreciation automatically for a tax book when you run depreciation for the
associated corporate book. Run Mass Copy to update your tax book prior to
running depreciation for the tax book.
For Release 11i:
You can run Depreciation as many times as you like. When you are ready to
close the period, on your last Depreciation run, check the Close Period
box on the Run Depreciation form.
12. What happens if I run depreciation when there are retirements or
reinstatements pending?
Answer:
When you submit depreciation, the process automatically runs the Calc
Gain/Loss (FARET) program to calculate gains and losses for any pending
retirements. You also can run FARET independently in order to reduce
depreciation processing time.
13. What is the difference between depreciation projections and depreciation?
Answer: Depreciation projections use a completely separate set of modules than the
Depreciation program. Depreciation projections do not take into account
adjustments entered in the current period, so any new retirements, transfers,
or adjustments will not effect the projection. Projections simply take a
snapshot of the asset at the start date of the projection and project
depreciation expense based on that information.
14. What happens if depreciation encounters an error? How do I proceed?
Answer: For Release 10.7 and 11:
If the depreciation program encounters an error, the program will stop and
perform a rollback to the previous commit. The program automatically resets
the DEPRN_RUNNING_FLAG to NO. If the error is straight forward, such as
Out of rollback segments, you can try to correct the error and then resubmit
the depreciation program. If the error is more serious, such as an operating
system error, you should contact Support before taking any further actions.
For Release 11i:
If the Depreciation program encounters and error, it will continue to
process all of the assets. The errored assets will appear in your logfile
so that you can fix them and resubmit Depreciation. Depreciation will then
only process the corrected assets.
15. What can I do to reduce processing time for the depreciation program?
Answer: Run Calc Gain/Loss several times throughout the period (this can be run
as often as you want). Then, when you finally run depreciation, the
Calc Gain/Loss program will process only the remaining retirements or
reinstatements. Ensure that your tables are not fragmented. Ask your
database administrator (DBA) to check for fragmentation problems. If
fragmentation exists, have the DBA export and reimport the tables, or
recreate them.
For Release 11 and 11i:
In addition to running Calculate Gains and Losses throughout the period,
run the Generate Accounts program before running Depreciation (N)Other
-> Requests -> Run. This will create the new code combinations needed so
that when you run Depreciation, the Generate Accounts program will not
detect any new asset with code combinations that need to be built, which
will greatly enhance overall performance.
For 11i customers, if the concurrent program (FAGDA) does not appear in the LOV
using Standard Report Submission (SRS) form, then please see Note 124955.1.
16. How does the depreciation program handle the end of a fiscal year?
Answer: At the end of a fiscal year, the depreciation program runs a short module
to prepare Oracle Assets for the next fiscal year. This module runs
automatically during the depreciation program. The fiscal years program
runs if the current period is the last period in the fiscal year. This
occurs when the period number of the current period = NUMBER_PER_FISCAL_YEAR
in the table FA_CALENDAR_TYPES. The fiscal years program checks if there are
rows defined for the next fiscal year in FA_DEPRN_PERIODS, FA_FISCAL_YEAR,
FA_CALENDAR_PERIODS, and FA_CONVENTIONS. If rows do not already
exist, the fiscal years program creates them.
For Release 11i:
Because of changes for the formula-based depreciation methods, you are now
required to create your fiscal year and calendars for the current fiscal
year + 1. Otherwise, you will be unable to run depreciation successfully.
17. What is the process flow for running Depreciation in 11i?
Answer:There have been several changes made by development to make the Depreciation/Create
Journals Process go much smoother for 11i. To take advantage of these changes, you must be on minipack H (2115788) and stand alone Patch 2130639.
In 11i, you may run Depreciation without closing the period. This allows you to check Depreciation
and make any necessary adjustments before closing the period.
The process should be:
1. Run Depreciation (without closing the period)
2. Run Create Journals
3. Review reports in FA and GL to determine if everything look correct
If everything is correct,
- Resubmit Depreciation (closing the period)
- Create Journals does not need to be ran again
If corrections are necessary,
- Rollback Journals
- Rollback Depreciation
- Make corrections
- Repeat steps 1-3.
With the application of the new code mentioned above, if you try to rollback
Depreciation without rolling back Create Journals, Rollback Depreciation will
error telling you that you need to rollback Create Journals.
18. What is the difference between the 'B' row and the 'D' row in the
FA_DEPRN_DETAIL table?
Answer:The 'B' (Books) row is added to the FA_DEPRN_DETAIL table when the asset is added
to Oracle Assets. There will only be one Books row per distribution in the
FA_DEPRN_DETAIL table. The 'D' (Depreciation) rows are added when Depreciation
is ran. There will be one row for each period and distribution that
Depreciation is ran for.
19. What is the Depreciation Adjustment account used for?
Answer:When you use the functionality of Tax Reserve Adjustment for the prior fiscal
of a Tax book the Depreciation Adjustment Account is used.
20. How can I add assets to a closed period (after Depreciation has been ran)?
Answer:Many types of transactions within Oracle Assets can be entered with
retro-active effective dates - (please consult the User Guide to see
if this is possible for the transactions you wanted to enter).
For the period accidentally closed in Assets, you can accrue for the
financial impact of these transactions using manual GL journals.
Oracle Assets will then catch up any financial impact of the transactions
when you Create Journal Entries for the next period. You can then reverse
out your accruals.
1. What is unplanned depreciation?
Answer: Unplanned depreciation is a feature used primarily to comply with special
depreciation accounting rules in Germany and the Netherlands. However, you
also can use this feature to handle unusual accounting situations in which
you need to adjust the net book value and accumulated depreciation amounts
for an asset without affecting its cost. Oracle Assets immediately updates
the YTD and LTD depreciation and the net book value of the asset. The
unplanned depreciation expense you enter must not exceed the current net
book value (Cost - Salvage Value - Accumulated Depreciation) of the asset.
2. Can depreciation be suspended for a specified period of time?
Answer: Depreciation can be suspended at any time by changing the depreciate flag
on the book form to NO. Note that the total depreciation to be taken over
the life of the asset (including that incurred in periods the flag was set
to NO) will still be taken over the original life assigned to the asset. If
the asset was added with the depreciate flag set to NO, missed depreciation
will be caught up in the period the flag is changed to YES. If the asset
was added with the depreciate flag set to YES and the flag was later changed
to NO, the missed depreciation will be caught up in the last period of the
asset's ORIGINAL life; suspending depreciation will not extend the period
over which the asset is depreciated.
The Depreciate flag can also be set at the category level.
If you set the depreciate flag at the asset level, this will override the category
depreciate flag which is the default.
If the intention is to never have the asset Depreciate then the flag Depreciate
flag should be set to 'No' for the life of the asset or the asset can be entered
into the system fully reserved.
3. Can depreciation expense be manually input to override the system?
Answer: Depreciation reserve adjustments can be made to a TAX book. From Release
10.7, with unplanned depreciation you may manually override the depreciation
amount taken in the Corporate book. The depreciation amount cannot be
greater than the net book value of the asset.
4. How does the Depreciate When Placed In Service flag on my prorate
convention affect the calculation and allocation of depreciation?
Answer: With the exception of the method type Calculated Straight Line,
depreciation for the year is calculated based on the prorate date which maps
to a prorate period and rate on the prorate calendar. This total amount is
then allocated back to the individual periods in the year. If this flag is
set to NO, the years depreciation will be spread over the periods beginning
with the prorate date. If the flag is set to YES, the years depreciation
will be spread over the periods beginning with the date placed in service.
Note that total depreciation for the year remains unchanged, only
depreciation per period will differ.
When the method type Calculated Straight Line is used, this flag has no
effect. Yearly depreciation will be calculated as recoverable cost/life,
and allocated beginning with the prorate date.
5. GAAP defines two types of changes; changes in estimates which are to be
handled prospectively and errors which are to be retroactively corrected.
What Oracle functionality addresses these?
Answer: Expense an adjustment for correction of an error, amortize the adjustment
for a change in estimate.
6. How do I set up Oracle Assets to charge a half-month's depreciation in the
first and last periods of the assets life?
Answer: You must do the following:
a. Set up a prorate CALENDAR with semi-monthly periods. So your prorate
calendar will have 24 periods per fiscal year.
Example:
Period 1: Jan 01 - Jan 15
Period 2: Jan 16 - Jan 31
Period 3: Feb 01 - Feb 15
Period 4: Feb 16 - Feb 28
Period 5: Mar 01 - Mar 15 ...
b. Set up a prorate CONVENTION that maps the appropriate dates to the
middle of the month.
Example:
Jan 01 - Jan 31 map to Jan 16
Feb 01 - Feb 28 map to Feb 16
Mar 01 - Mar 31 map to Mar 16 ...
c. Assign your book to the appropriate prorate CALENDAR in the Book
Controls form. (You will also probably want it to depreciate EVENLY).
d. Set the default prorate convention to the appropriate mid-month
convention in the Default Depreciation Rules zone of the Asset
Categories form. You can also specify the prorate CONVENTION in the
Books window during the Detail Additions process.
Now when the depreciation program processes an asset whose date placed in
service is Jan 10, it will use the prorate convention to map that date to a
PRORATE DATE of Jan 16, and it will use the prorate date to map to
PRORATE PERIOD #2 in your prorate calendar. Thus, if you are running
depreciation for January (note that your DEPRECIATION CALENDAR can still
be monthly), you will get half a month's worth of depreciation for January.
*** It is not enough to set the prorate convention to a mid-month convention -
*** you must also set the prorate CALENDAR to be semi-monthly.
7. What is the difference between the new What-If feature and the old
depreciation projections functionality?
Answer: Using What-If Analysis, you can model depreciation scenarios for any number
of future periods based on depreciation attributes different from what you
have currently set up for the asset. Hence the name: What If Analysis.
Using Depreciation Projection, you can project depreciation expense based
on the asset's current depreciation method, life, etc.
Additionally, What-If Analysis is very flexible in allowing you to select a
subset of assets for analysis. Selection criteria include Range of Asset
Numbers, Range of Dates Placed in Service, Asset Category etc. For
Depreciation Projections, you must specify a BOOK and the program selects
all active assets for that book.
8. When I run depreciation I get the following error:
"Error: function fafbgcc returned failure (called from fadoflx) Getting
account CCID"
How do I correct this problem?
Answer: Set the profile options FA:PRINT_DEBUG and FA:DEPRN SINGLE to YES and
rerun depreciation. Make note of the asset number and distribution id.
Depreciation tries to build a code combination id (CCID) for one of the
following:
Asset Cost Account/CIP Cost Acct (Current Period Asset Clearing
Account)/CIP Clearing Acct (Current Period Adds) Depreciation Expense
Account (Prior Period Additions)
Check whether Allow Dynamic Inserts is being allowed for the Accounting
Flexfield (AFF).
Navigation:
Setup -> Financials -> Flexfields -> Segments -> Key
Query for Oracle General Ledger - Accounting Flexfield
If the Allow Dynamic Inserts box is not checked, unfreeze the flexfield
definition, check the box, refreeze and Compile. If it is already checked,
that means the combination generated is not valid. To find out what
combination is being generated, do the following:
Find out which category the asset belongs to by querying for the asset in
the Asset Workbench (Navigation: Assets -> Asset Workbench). Then query for
the asset category/book combination in the Asset Categories form
(Navigation: Setup -> Asset System -> Asset Categories). Using the Help ->
Tools -> Examine function from the menu, get the following information:
Account segment value for Asset Cost/Cost Clearing accounts
(or CIP Cost/CIP Clearing accounts if asset is CIP)
Code combination id (CCID) associated with these accounts
From the Book Controls form, you need to get the Default CCID for the
book utilizing Help -> Tools -> Examine method
(N)Setup -> Asset System -> Book Controls.
From the Inquiry/Financial Information form, you need to get the
distribution CCID for the asset utilizing the same method
(N)Inquiry -> Financial Information -> Assignments form.
Once you have the parameters, in Release 11 run the script faxagtst.sql
to see what combination is getting built and why it is failing.
For details on using faxagtst.sql, see Note 1062849.6
In Release 10.7, you will need to perform a Flexbuilder Test in the
application.
(N)Setup -> Financials -> Flexfields -> Flexbuilder -> Test
9. What depreciation methods are supported within Oracle Assets?
Answer: You may choose from the following:
Straight-line
Declining balance
Sum-of-year's digits
Units of production
ACRS and MACRS
Flat rate
Diminishing value
Bonus depreciation
In Release 11i, you will also be able to create formula-based methods
for depreciation.
10. When should I run the depreciation program?
Answer: For Release 10.7 and 11:
You should run depreciation when you are ready to close your depreciation
period. Depreciation cannot be rolled back once run. Since the depreciation
program closes the period, you should make sure that you entered all your
transactions for the current period. If you forget to enter a transaction in
the current period, you can enter a retroactive addition, transfer, or
retirement transaction in the following period. Oracle Assets will not
calculate adjustments to depreciation until you run depreciation again.
For Release 11i:
You can now run Depreciation as many times as you would like without closing
the period. When you are ready to close the period, on your final
Depreciation run, you would check the Close Period button on the form.
You have the capability in 11i to rollback depreciation. So if you run
Depreciation and you do not like the results, you can rollback Depreciation,
make your changes, and submit Depreciation again. Once the final Depreciation
has been run and the period is closed, you cannot rollback Depreciation for
the period. If you are closing the last period for a fiscal year, you cannot
enter a retroactive retirement for a period after the end of the year.
11. How often can I run depreciation?
Answer: For Release 10.7 and 11:
You can run depreciation only once per depreciation period. When you run
depreciation and close the period, you cannot reopen that period. You must
run depreciation for each corporate and tax book; Oracle Assets does not run
depreciation automatically for a tax book when you run depreciation for the
associated corporate book. Run Mass Copy to update your tax book prior to
running depreciation for the tax book.
For Release 11i:
You can run Depreciation as many times as you like. When you are ready to
close the period, on your last Depreciation run, check the Close Period
box on the Run Depreciation form.
12. What happens if I run depreciation when there are retirements or
reinstatements pending?
Answer:
When you submit depreciation, the process automatically runs the Calc
Gain/Loss (FARET) program to calculate gains and losses for any pending
retirements. You also can run FARET independently in order to reduce
depreciation processing time.
13. What is the difference between depreciation projections and depreciation?
Answer: Depreciation projections use a completely separate set of modules than the
Depreciation program. Depreciation projections do not take into account
adjustments entered in the current period, so any new retirements, transfers,
or adjustments will not effect the projection. Projections simply take a
snapshot of the asset at the start date of the projection and project
depreciation expense based on that information.
14. What happens if depreciation encounters an error? How do I proceed?
Answer: For Release 10.7 and 11:
If the depreciation program encounters an error, the program will stop and
perform a rollback to the previous commit. The program automatically resets
the DEPRN_RUNNING_FLAG to NO. If the error is straight forward, such as
Out of rollback segments, you can try to correct the error and then resubmit
the depreciation program. If the error is more serious, such as an operating
system error, you should contact Support before taking any further actions.
For Release 11i:
If the Depreciation program encounters and error, it will continue to
process all of the assets. The errored assets will appear in your logfile
so that you can fix them and resubmit Depreciation. Depreciation will then
only process the corrected assets.
15. What can I do to reduce processing time for the depreciation program?
Answer: Run Calc Gain/Loss several times throughout the period (this can be run
as often as you want). Then, when you finally run depreciation, the
Calc Gain/Loss program will process only the remaining retirements or
reinstatements. Ensure that your tables are not fragmented. Ask your
database administrator (DBA) to check for fragmentation problems. If
fragmentation exists, have the DBA export and reimport the tables, or
recreate them.
For Release 11 and 11i:
In addition to running Calculate Gains and Losses throughout the period,
run the Generate Accounts program before running Depreciation (N)Other
-> Requests -> Run. This will create the new code combinations needed so
that when you run Depreciation, the Generate Accounts program will not
detect any new asset with code combinations that need to be built, which
will greatly enhance overall performance.
For 11i customers, if the concurrent program (FAGDA) does not appear in the LOV
using Standard Report Submission (SRS) form, then please see Note 124955.1.
16. How does the depreciation program handle the end of a fiscal year?
Answer: At the end of a fiscal year, the depreciation program runs a short module
to prepare Oracle Assets for the next fiscal year. This module runs
automatically during the depreciation program. The fiscal years program
runs if the current period is the last period in the fiscal year. This
occurs when the period number of the current period = NUMBER_PER_FISCAL_YEAR
in the table FA_CALENDAR_TYPES. The fiscal years program checks if there are
rows defined for the next fiscal year in FA_DEPRN_PERIODS, FA_FISCAL_YEAR,
FA_CALENDAR_PERIODS, and FA_CONVENTIONS. If rows do not already
exist, the fiscal years program creates them.
For Release 11i:
Because of changes for the formula-based depreciation methods, you are now
required to create your fiscal year and calendars for the current fiscal
year + 1. Otherwise, you will be unable to run depreciation successfully.
17. What is the process flow for running Depreciation in 11i?
Answer:There have been several changes made by development to make the Depreciation/Create
Journals Process go much smoother for 11i. To take advantage of these changes, you must be on minipack H (2115788) and stand alone Patch 2130639.
In 11i, you may run Depreciation without closing the period. This allows you to check Depreciation
and make any necessary adjustments before closing the period.
The process should be:
1. Run Depreciation (without closing the period)
2. Run Create Journals
3. Review reports in FA and GL to determine if everything look correct
If everything is correct,
- Resubmit Depreciation (closing the period)
- Create Journals does not need to be ran again
If corrections are necessary,
- Rollback Journals
- Rollback Depreciation
- Make corrections
- Repeat steps 1-3.
With the application of the new code mentioned above, if you try to rollback
Depreciation without rolling back Create Journals, Rollback Depreciation will
error telling you that you need to rollback Create Journals.
18. What is the difference between the 'B' row and the 'D' row in the
FA_DEPRN_DETAIL table?
Answer:The 'B' (Books) row is added to the FA_DEPRN_DETAIL table when the asset is added
to Oracle Assets. There will only be one Books row per distribution in the
FA_DEPRN_DETAIL table. The 'D' (Depreciation) rows are added when Depreciation
is ran. There will be one row for each period and distribution that
Depreciation is ran for.
19. What is the Depreciation Adjustment account used for?
Answer:When you use the functionality of Tax Reserve Adjustment for the prior fiscal
of a Tax book the Depreciation Adjustment Account is used.
20. How can I add assets to a closed period (after Depreciation has been ran)?
Answer:Many types of transactions within Oracle Assets can be entered with
retro-active effective dates - (please consult the User Guide to see
if this is possible for the transactions you wanted to enter).
For the period accidentally closed in Assets, you can accrue for the
financial impact of these transactions using manual GL journals.
Oracle Assets will then catch up any financial impact of the transactions
when you Create Journal Entries for the next period. You can then reverse
out your accruals.
Random Questions From Apps
Ans: Over lay is used in payable open interface where we would like to pass and overwrite certain value which is set to appear by default when data is inserted into the production tables.
2. What is rollup group
Ans: rollup group we define and attached with the parent segment in the accounting flexfield for summary total for which summary template is defined. This identify at what level and how the summing up should be computed for the level.
3. What way payment batch is different from other module batches.
Ans: It identifies the invoices for the payment automatically based on the criteria we specify in payment batch for the payments. 4. What is balancing segment in AR.Ans: The Account Generator ensures that Receivables substitutes the correct balancing segment values during various accounting activities against transactions and receipts.
Receivables uses the Account Generator to update the balancing segment values during various accounting activities against transactions and receipts. By matching the balancing segments for different accounting activities back to the original transaction or receipt, the Account Generator ensures that Receivables uses the correct balancing segment values during this substitution process. For example, if an invoice’s balancing segment that you assess finance charges for has a value of ’01’ and the balancing segment of your finance charges account is ’02’, when Receivables accrues finance charges for this invoice, the Account Generator automatically changes the balancing segment of the finance charges account to ’01’. The Account Generator in Receivables utilizes Oracle Workflow
5.What is deposit in AR? Have you used it?
Ans: It is a commitment type of transaction where in we take deposit from the customer and get into the agreement that we will make supply of certain goods and services for certain period of time.
7.What is flexfield qualifier in accounting flexfield.
Ans: Balancing Segment, Cost Center Segment, Natural Account Segment & Inter-company segment.
8.Which SRS is used for AR To GL Interface.
ANS: General ledger option is given in the menu option interfaces in AR.
9.What are required setup for AP.
Ans: Required setup in AP is as under
1. Install or upgrade payables
2. Select primary set of books
3. Use the system administrator responsibility to assign your set of books to a responsibility. (Profile Option)
4. Define financials options.
5. Define payables options.
6. Define payment terms.
7. Define banks, bank transmission details and bank accounts
8. Open payable accounting period
9. Set up Print Styles and Drivers for the supplier Mailing labels report
10.What are required setup for GL.
Ans: Required setup in GL is as under
1. Source (Required step with defaults)
2. Category (Required step with defaults)
3. System Control (Required step with defaults)
4. Profile Options (required)
5. Open Close Accounting Periods (required)
Before that set of books setup needs following:
1. Chart of Accounts (Accounting Flexfields) - (Required)
2. Define Period Types (Required step with defaults)
3. Define Calendar (Required)
4. Currency (Required step with defaults)
5. Set Of Book (Required)
6. Assign set of books to a Responsibility in Profile Option(Required)
7. Daily Conversion Rate Type (Required step with defaults)
11.How you will print user name of the person logged on to see the report.
ANS: SELECT FND_GLOBAL.USER_ID FROM DUAL; STORE IT IN A VARIABLE AND FIND IT IN THE FND_USER
select user_name from fnd_user where user_id = (select fnd_global.user_id from dual)
12.What is the table name for GL Interface. From here data goes to which tables.
ANS: GL_INTERFACE Table Updates GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES.
13.Can we insert journal name in the GL Interface table
Ans: There is no such column in GL interface table hence we cannot enter it.
14.Where Reference fields are found in GL production tables. What is its use.
Ans: Reference fields are found in GL_JE_LINES it is used to store reference of sub-ledger enables us to drill down from gl to subledger.
15.Where journal name will be stored in GL_INTERFACE TABLE, Name the column.
ANS: REFERENCE4 (Journal Entry name will go in this field)
16.How to set dependent and independent value set and how you will insert values for the segments having these value sets.
ANS: First define independent value set and then while defining dependent value set give reference of independent value set along with default value and description. At time of entering values, enter values for independent first and then while entering values for dependent it will first force you to select value of independent segment.
17.SRS Name for AP TO GL.
ANS: Payable Transfer to General Ledger.
18.Can you delete the records after the interface has uploaded the records in the GL interface table?
ANS: Yes we can delete and correct the records from the front end after importing data into GL_INTERFACE Table. Sub menu options as correct and delete are given under import menu option. We have to specify source name. Menu option is import under journal in GL.
19.Required parameter for PL/SQL Procedure registered in Oracle. What will happen if these are not included?
ANS: Retcode and Errbuf are two out parameters having varchar2 datatype that are required. Use errbuf to return any error messages, and retcode to return completion status. The parameter retcode returns 0 for success, 1 for success with warnings, and 2 for error. After your concurrent program runs, the concurrent manager writes the contents of both errbuf and retcode to the log file associated with your concurrent request. If we do not include these two parameters, it will give run time error.
20.How to judge the number of descriptive fields defined from the front end itself.
ANS: In front end we will find [] open close square bracket which indicate the presence of descriptive flexfield. In other words, dff appears on form as a single-character, unnamed field enclosed in brackets21.What is context field is all about.ANS: Context field is used to make descriptive flexfield segments context sensitive, so that segment that may or may not appear depending upon what other information is present in your form
22.What is use of custom.pll what triggers are fired to support the customization you do using custom.pll
Ans: WHEN-FORM-NAVIGATE
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
WHEN-VALIDATE-RECORD
SPECIALn (1 to 45)
ZOOM
EXPORT
KEY-fn (1 to 8)
23.What are various customer interface tables?
ANS: RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILE_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL
RA_CONTACT_PHONES_INT_ALL
24.Where invoices gets stored in payables
ANS: AP_INVOICES_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_TERMS_LINES
AP_BANK_ACCOUNTS_ALL
AP_BANK_BRANCHES
AP_INVOICE_PAYMENTS_ALL
25.What will happen if you will type select * from ap_invoices in the multi org setup.
Ans: No row selected because it is a view having where condition for ord_id to match with operating unit context that are extracted from client_info global variable at application run time. From sql prompt run Fnd_client_info.setup.org_context(org_id). It will set the operating unit context or run fnd_clinet_info.setup_client_info(resp_appl_id,resp_id,user_id, security_group_id)26.Why it does not show records and show records for ap_invoices_all where as both the table has got org_id columns.Ans: Because operating unit context is not set that is why ord_id can not retrieved to meet the where condition specified in the view. Set it up with followings,
Fnd_client_info.setup_client_info(resp_appl_id,appl_id,user_id) or
Fnd_client_info.set_org_context(org_id)
27.What mechanism or logic oracle apps have applied to drill down the records in AP from the GL module after the records are transferred from AP to GL.
ANS: Uses reference column (1-8) to store information about sub-ledger.
28. What is auto accounting?
ANS: It is a required setup before to enter any transaction in AR. We have to define code combinations for different transaction type such as revenue, receivables, bills receivables, charge back, deposit and guarantee to default
29. What is major risk you find in Project? How to mitigate it.
ANS: Resource is a major risk in oracle apps projects. To mitigate it we need to have resource in reserve right from the beginning of the project.30. What are CR.010 all about?ANS: It is a Project Management Plan Document.
31. How you maintain time sheet.
ANS: Time sheet is maintained in WM.020 In MS Project format.
Please ignore if Questions are repeated.
No comments:
Post a Comment