Calling UiPath Bot using Oracle Apex
Technologies and Tools Used The following technologies have been used to achieve the expected output. JavaScript Oracle Apex Uipath Use Case Assume that we have created an Uipath Bot…
Read MoreCREATE A NEW PARTITION IN RUNNING ORACLE LINUX SERVER
Description: Already we have created partition while installed the operating system. But after installation, we need a new one partition means we have to do some configuration in it. So…
Read MoreQuery to get Accounting issue invoice details
select org_id, customer_trx_id, sum(tax) tax, sum(rev) rev, sum(rec) rec, sum(tax)+sum(rev) acutal_rec from ( select org_id, customer_trx_id, case when account_class=’TAX’ then sum(amount) else 0 end tax, case when account_class=’REV’ then sum(amount)…
Read MoreQuery to get the AR Netting details
select * from (select fnar.batch_id, fnar.customer_trx_id, rct.bill_to_customer_id cust_acct_id, rct.bill_to_site_use_id cust_site_use_id, fnar.ar_txn_rank, nvl(fnar.netted_amt,0) as netted_amt, fnb.batch_currency as reckoning_currency, rct.trx_number, rct.invoice_currency_code as transaction_currency, rctt.description as transaction_type, hp.party_name as cust_acct_name, hca.account_number as cust_acct_number,…
Read MoreQuery to get Data Accesses of Users – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…
Read MoreQuery to get HR Contingent Worker – Oracle EBS to Fusion
Introduction: This blog has the SQL query that can be used to pull the HR Contingent Worker details per country for EBS to Cloud data migration. SQL Query : SELECT …
Read MoreEmployee Recall Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…
Read MoreQuery to get Lease assets – Oracle EBS to Fusion
Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query: SELECT fb.book_type_code…
Read MoreOracle Service Contract Cycle in Oracle EBS R12
oracle-service-contract-cycle-in-oracle-ebs-r12
Read MoreAutomatic Modifier is Not Applying to Service Contract
automatic-modifier-is-not-applying-to-service-contract
Read More