How to terminate instance number in Install Base
Using below script we can terminate instance number in Install Base. UPDATE csi_item_instances SET active_end_date = SYSDATE WHERE instance_id = l_instance_id;
Read MoreQuery to handle with zero if no onhand quantities in Inventory or onhand is NULL
Objective: Query to handle with zero if no onhand quantities in Inventory or onhand is NULL SQL: Select NVL(MAX(COUNT(moq.TRANSACTION_QUANTITY)),0) –MAX(NVL(SUM(moq.TRANSACTION_QUANTITY),0)) from mtl_onhand_quantities moq, MTL_ITEM_LOCATIONS_KFV mil, mtl_system_items_b msib where moq.LOCATOR_ID…
Read MoreIf else xdoxslt function syntax -RTF
The normal behavior of if-else condition looks like If <contion> then <value> –for true condition else <value> end in RTF it can be achieved using following syntax <?xdoxslt:ifelse(condition,true,false)?> Example <?xdoxslt:ifelse(ADDRESS1=SENDOR_NAME,’’,ADDRESS1)?>
Read MoreEmployee Supplier Prepayment Account details extract query
/*Query to get the Prepayment Account details of the Employee Suppliers */ SELECT * FROM ( SELECT DISTINCT pbg.name business_group_name, papf.employee_number, papf.full_name employee_name, gcck.concatenated_segments prepayment_account_site_level, hou.name opperating_unit_name, apssa.vendor_site_code, fu.user_name last_updated_user…
Read MoreHow to add custom/fields PO XML generation
In this blog, We will see how can we add the custom XML segments/fields that can be extended in PO XML output. PO_CUSTOM_XMLGEN_PKG package is the place where the business…
Read MorePO XML Views in Oracle
In Oracle Purchasing, The PO Output for Communication program is responsible for sending the PO copies to vendors with respect to the communication details captured. During the call of this…
Read MoreRecurring GL Journals extract query
In Oracle Financials, We have a provision to create a recurring journal in GL application. This blog will helping in extracting that journals. SELECT b.name batch, b.description batch_description, ( SELECT…
Read MoreAME Rule changes audit queries
In Oracle E-Biz applications Approvals Management Engine(AME) is widely used for approvals in Purchasing,HR modules. Especially an audit enabled systems, We need to capture the changes in the real-time systems.…
Read MoreApps listener fails to start on cloned instance with TNS-12533
Apps listener fails to start on cloned R12.1.3 instance with the following error. Cause: This error occurs when a host names in the tcp.invited_nodes list is invalid Solution: Remove invalid…
Read MoreAPP-FND-01542: This Applications Server is not authorized to access this database.
By default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read More