Employee Category(PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY) in Employee Assignment Form in Oracle APPS

PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY values coming from HR_LOOKUPS.LOOKUP_TYPE = 'EMP_CAT'

SELECT * FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'EMP_CAT' AND enabled_flag = 'Y' AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE) AND NVL (end_date_active, SYSDATE)

Revenue Analyst in Oracle Fusion

Revenue Analyst manages and implements revenue adjustments, revenue recognition, revenue accounting, creation and processing of revenue documents, and the inquiry of revenue documents and adjustments. 

It also manages the defining of open and closed periods and transferring entries to the GL(General Ledger).

Accounts Receivable Specialist in Oracle Fusion

Accounts Receivable Specialist manages and implements all customer related payment activities, including receiving customer payments and electronic remittance advice, performing cash handling activities, processing customer payments, and applying payments to customer accounts.

Accounts Receivable Manager in Oracle Fusion

Account Receivable Manager manages all accounts receivable activities. It also includes below activities:

• Defining policy and controls
• Establishing processes and procedures, resolving issues
• Monitoring and analyzing accounts receivable balances 
• Creating reports 
• Business Intelligence.

Query to get Next Month First Day for a given Date in Oracle

SELECT TRUNC (ADD_MONTHS (SYSDATE, 1), 'MON'), TO_CHAR (TRUNC (ADD_MONTHS (SYSDATE, 1), 'MON'), 'DD-MON-RRRR')  FROM DUAL

Assets by Cash Generating Unit Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Assets by Cash Generating Unit Report:

• Lists all assets by cash generating unit. 
• The report extracts the details of all of the asset impairment transactions, such as asset number, cash generating unit, cost, net book value, accumulated impairment reserve, and year-to-date impairments from Oracle Fusion Assets.

Hypothetical Depreciation Analysis Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Hypothetical Depreciation Analysis Report:

• Lists depreciation projections for hypothetical assets based on the specified depreciation parameters.

Property Tax Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Property Tax Report:

• Lists the assets at a particular location as of the specified cutoff date. 
• This information is used for property tax forms. 
• The report is sorted by and groups totals for each balancing segment, location, asset account, and year acquired.

Revaluation Reserve Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Summary Report; 

• Lists asset level revaluation reserve account balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Revaluation Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Detail Report:

• Lists asset revaluation reserve account balances for a specified period for an asset level. 
• The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Reserve Summary in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Summary Report:

• Lists reserve account summary balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment and reserve account.

Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Detail Report:

• Lists asset level asset reserve account balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

CIP Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

CIP Summary Report: 

• Lists CIP cost account summary balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment and CIP cost account.

CIP Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

CIP Detail Report:

• Lists asset-level construction-in-process (CIP) cost account balances for the specified periods.
• The report is sorted by and groups totals for each balancing segment, CIP cost account, and cost center.

Journal Entry Reserve Ledger in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Journal Entry Reserve Ledger:

• Lists asset depreciation amounts for the specified period. 
• The report is sorted by and groups totals for each balancing segment, expense account, reserve account, and cost center.

Cost Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Summary Report:

• Lists asset cost account summary balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment and asset cost account.

Cost Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Detail Report:

• Lists asset-level asset cost account balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment, asset cost account, and cost 
•  center.

Cost Clearing Reconciliation in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Clearing Reconciliation: 

• Report Lists all asset additions and cost adjustments performed during the specified period for which accounting entries are created for cost clearing accounts. 
• The report is sorted by and groups totals for each transaction type, balancing segment, and clearing account.

Post Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Post Mass Additions Report

• Lists all the asset additions and cost adjustments processed by the Post Mass Additions process.
• The report is sorted by transaction type.

Delete Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Delete Mass Additions Report:

• Lists all the mass addition lines in the Delete queue that are ready to be processed by the Delete Mass Additions process.

Create Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Create Mass Additions Report: 

• Lists all invoice and discount lines processed by the Create Mass Additions process. 
• The report is sorted by and groups totals for each foreign currency, balancing segment, asset clearing account, and cost center.
• This report is usually run from Payables.

Asset Impairment Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Impairment Report: 

• Lists the impact of impairment transactions. 
• Displays the cost, new net book value, net selling price, value in use, and impairment loss amount for  all of the impaired assets in the given book and depreciation period. 
• The report is sorted by the asset number.
• The report shows totals for the current net book value, net selling price, values in use, impairment loss, and new net book value.

 

Asset Category Change Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Category Change Report: 

• Lists all of the assets for which the asset category is changed during the specified period. 
• The report is sorted by and groups totals for each balancing segment, asset account, and asset number.

Cost Adjustments by Source Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Adjustments by Source Report:

• Lists all the asset cost adjustments made during the specified periods. 
• The report shows the details of associated invoice lines. 
• The report sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number.

Cost Adjustment Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Adjustment Report:

• Lists all of the asset cost adjustments made during the specified periods. 
• The report is sorted by and groups totals for each balancing segment, asset type, asset cost account, and cost center.

CIP Capitalization Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

CIP Capitalization Report:

• Lists all of the construction-in-process (CIP) assets capitalized during the specified periods. 
• The report is sorted by and groups totals for each balancing segment, CIP cost account, cost center, and asset cost account.

Asset Transfers Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Transfers Report:

• Lists all asset transfers performed during the specified period. 
• The report is sorted by asset number.

Asset Transaction History Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Transaction History Report:

• Lists all transactions performed on selected assets. 
• The report is sorted by asset number.

Asset Retirements Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Retirements Report:

• Lists all of the asset retirements performed during the specified periods. 
• The report is sorted by and groups totals for each balancing segment, asset type, asset account, and cost center.

Additions by Source Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Additions by Source Report:

• Lists all the assets added or capitalized during the specified periods. 
• The report shows the details of associated invoice lines. 
• The report sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number

Asset Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Additions Report:

• Lists all of the assets added or capitalized during the specified periods. 
• The report is sorted by and groups totals for each balancing segment, asset type, asset account, cost center, and reserve account.

Group Asset Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Group Asset Summary Report 

• Lists the group asset balances for the specified fiscal year and is used to comply with Indian income tax requirements.

• Sorted by and prints totals for each fiscal year and asset category.

Group Asset Listing in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Group Asset Listing 

• Lists the group asset balances for the specified fiscal year and is used to comply with Canadian capital cost allowance requirements.

• Sorted by and groups totals for each fiscal year and asset category.

Group Asset Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Group Asset Detail Report 

• Lists the group and its member asset balances for the specified fiscal year and is used to comply with Indian income tax requirements.

• Sorted by and groups totals for each fiscal year and asset category.

Revaluation Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Detail Report 

• Lists asset revaluation reserve account balances for a specified period for an asset level.

• Sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Revaluation Reserve Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Summary Report 

• Lists asset level revaluation reserve account balances for the specified periods.

• Sorted by and groups totals for each balancing segment, reserve account, and cost center.

Reserve Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Summary Report 

• Lists reserve account summary balances for the specified periods.

• Sorted by and groups totals for each balancing segment and reserve account.

Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Detail Report 

• Lists asset level asset reserve account balances for the specified periods.

• Sorted by and groups totals for each balancing segment, reserve account, and cost center.

CIP Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

CIP Summary Report 

• Lists CIP cost account summary balances for the specified periods.

• Sorted by and groups totals for each balancing segment and CIP cost account.

CIP Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

CIP Detail Report 

• Lists asset level CIP cost account balances for the specified periods.

• Sorted by and groups totals for each balancing segment, CIP cost account, and cost center.

Journal Entry Reserve Ledger in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Journal Entry Reserve Ledger 

• Lists asset depreciation amounts for the specified period.

• Sorted by and groups totals for each balancing segment, expense account, reserve account, and cost center.

Cost Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Summary Report 

• Lists asset cost account summary balances for the specified periods.

• Sorted by and groups totals for each balancing segment and asset cost account.

Cost Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Detail Report 

• Lists asset level asset cost account balances for the specified periods.

• Sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Cost Clearing Reconciliation Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Clearing Reconciliation Report 

• Lists all asset additions and cost adjustments performed during the specified period for which accounting entries are created for cost clearing accounts.

• Sorted by and groups totals for each transaction type, balancing segment, and clearing account.

Post Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Post Mass Additions Report 

• Lists all the asset additions and cost adjustments processed by the Post Mass Additions process.

• Sorted by transaction type.

• Generated every time the Post Mass Additions process is run.

Delete Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Delete Mass Additions Report 

This report lists all the mass addition lines in the Delete queue that are ready to be processed by the Delete Mass Additions process.

Create Mass Additions Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Create Mass Additions Report:

• Lists all invoice and discount lines processed by the last run of the Create Mass Additions process.

• Sorted by and groups totals for each foreign currency, balancing segment, asset clearing account, and cost center.

• Generated every time the Create Mass Additions process is run.

Asset Impairment Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Impairment Report 

• Lists the impact of impairment transactions.

• Displays cost, new net book value, net selling price, value in use, and impairment loss amount for all the impaired assets in the given book and depreciation period.

• Sorted by asset number.

Asset Category Change Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Asset Category Change Report 

• Lists all the assets for which the asset category is changed during the specified period.

• Sorted by and groups totals for each balancing segment, asset account, and asset number.

Cost Adjustments by Source Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Cost Adjustments by Source Report 

• Lists all the asset cost adjustments made during the specified periods.

• Shows the details of associated invoice lines.

• Sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number.