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 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 […]
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 […]
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 […]
Goal How does the Invoices Workbench (APXINWKB) determine the validation status of an invoice? The validation status of an invoice is displayed at invoice header level, but this information is not stored in the corresponding table AP_INVOICES_ALL […]
In the past I have worked as Migration lead and now I am working as conversion lead for one of the ERP implementation project. As having worked on both(migration/conversion) this is an effort to put […]
Geography Name Referencing Process – TCA in R12 1. What is the purpose of Geography Name Referencing Process? The purpose of Geography Name Referencing process is to validate address elements in location tables, such as […]
Workday Studio Connection To Tenant Open Workday Studio and Connect to tenant Note: Do not use complete URL, only use your tenant name Connect to gms Select Workday → Connections then select “Add”. Enter tenant […]
1) Payment Method Code at Supplier Level 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT supp.segment1 supplier_num, paym.payment_method_code FROM ap_suppliers supp, iby_external_payees_all payee, iby_ext_party_pmt_mthds paym WHERE supp.party_id = […]
Step 1) Find SID and Serial Number for Concurrent Job 1 2 3 4 5 6 7 8 9 10 11 SELECT a.request_id, d.sid, d.serial# ,d.osuser, d.process , c.SPID ,d.inst_id FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, […]
Enterprise Resource Planning and Integrations BlogSpot 