Oracle iExpense Report Tables with Policy Violation Details
Below are queries for Oracle iExpense to find out the Policy violation detail for iExpense reports. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 […]
End Date Responsibility from Oracle for List of Users
First create a temp table to hold user responsibilities to be inactivated. 1 2 3 4 CREATE TABLE xxcb_user_resp ( user_name VARCHAR2(240), resp_name VARCHAR2(240) ) Then insert record into temp tables, you may prepare these […]
Payroll Journal Entries
Payroll journal entries are used to record the compensation paid to employees. These entries are then incorporated into an entity’s financial statements through the general ledger. The key types of payroll journal entries are: Initial […]
How to open a new instance of Excel (2010) by default when opening a file
If you have ever worked with multiple workbooks in Excel, you know that it can sometimes cause issues if all of the workbooks are open in the same instance of Excel. For example, if you […]
Field Types
Workday Field Types 1: M Multi Instance 1:1 Single Instance Currency Boolean Date Numeric Text
Hello Word Project
Hello Word Project Workday Launch the new assembly project wizard.
Multiple Reporting Currencies FAQ
FA Multiple Reporting Currencies FAQ 1. When converting assets from a legacy system into an MRC enabled Depreciation Book, what exchange rate is used to convert the assets? A: When converting assets from a legacy […]
Important Accounting Dates for Fixed Assets
Important Accounting Dates for Fixed Assets There are three critical dates for each individual fixed asset. These dates establish when the asset was acquired, placed in service, and the start of depreciation. These three dates […]
Fixed Asset Tables R12 & Fusion Cloud
FA_ADDITIONS_B FA_ADDITIONS_B contains descriptive information to help identify your assets. When adding an asset, Oracle Assets inserts a row into this table and into the FA_ASSET_HISTORY table. When changing the asset information stored in this […]
Remaining Life Of an Asset in R12
A) Remaining Life Of an Asset Based on Sysdate 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 […]
Enterprise Resource Planning and Integrations BlogSpot 