This sql query will be useful to extract the approval limits that are changed for any employee’s job/assignments supervisor change SQL Query SELECT pbg.name business_group_name, papf.employee_number, papf.person_id, cur.effective_start_date new_assignment_effective_date, papf.attribute30…
Read MoreThis sql query will help to get the payment status of the requisition , PO , Invoice and its payment status SELECT DISTINCT prh.segment1 req_number, prh.authorization_status req_status ph.segment1 po_number ai.invoice_num,…
Read MoreThis post will help you to understand, how effectively you can amend the “Colombian Withholding Tax type certificate footer information” There is a standard setup to setup the footer information…
Read MoreThe requirement is to update/attach a new Bill To Location to existing supplier sites. The below script can be used to update the Bill To Location for the existing supplier…
Read MoreThis error occurred when we install Oracle EBS R12.1 on oracle cloud. CAUSES OF ISSUE The http port number and instance public ip is blocked by the vcn network. There…
Read MoreOne of the index table FND_CONCURRENT_REQUESTS_N9’s block is corrupted. Causes of issue: Abnormal server down Steps to solve this issue: 1.Find table name of corrupted block SELECT k.owner, k.segment_type, k.segment_name,…
Read MoreThe below are the steps to follow to develop a basic Custom form in EBS. Download the Resource folder from the server and place in local directory. Right Click on…
Read MoreWhen the tax profile is missing for a customer, we cannot edit the customer profile details from the Customer dashboard. So to identify such customers where we may face the…
Read MoreIntroduction This blog explains to get the On hand quantity if a item in inventory for a specific date #Code# SELECT SUM (TRANSACTION_QUANTITY) TARGET_QTY FROM MTL_ONHAND_QTY_COST_V MOQV WHERE MOQV.ORGANIZATION_ID =…
Read MoreCloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv where ch.id = cab.document_id and cab.article_version_id = cv.article_version_id and cv.article_id = caa.article_id
Read More