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, […]
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 28 29 30 31 32 33 34 35 […]
In Oracle EBS R12 supplier web page, there are Address Book and Contact Directory that contain phone, fax and email information. A) To gather phone, fax, and email in Address Book we can use this […]
Importing Supplier Bank Account through Interface Tables in R12 The data to be imported is to be inserted in the interface tables first. After inserting the data in the interface tables, the ‘Supplier Open […]
To find the tables involved in storing the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance. […]
To check the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance. XLA_EVENTS […]
Enterprise Resource Planning and Integrations BlogSpot 