Introduction This Query will help to Extract the Credit Memo Data in Oracle Apps. SQL Query: SELECT CASE rcta.interface_header_context WHEN ‘CLAIM’ THEN ‘TRADE MANAGEMENT’ WHEN ‘ORDER ENTRY’ THEN ‘Order Entry…
Read MoreIntroduction This Query will help to Fetch PO Receipt Details Data in Oracle Apps. SQL Query: SELECT pv.vendor_name, poh.ship_to_location, poh.bill_to_location, DECODE (plla.match_option, ‘P’, ‘PO’, ‘R’, ‘Receipt’, ”) line_status, UPPER (poh.status)…
Read MoreIntroduction This Query will help to Fetch the Item Master Extract Report Data in Oracle Apps. SQL Query: SELECT DISTINCT (SELECT organization_code FROM mtl_parameters WHERE organization_id = msi.organization_id AND ROWNUM…
Read MoreIntroduction This Query will help to Fetch the On hand Inventory by Revision Report Data in Oracle Apps. SQL Query: /* Formatted on 2021/09/06 15:26 (Formatter Plus v4.8.8) */ SELECT…
Read MoreHow to change the Node Manager Log Level? Log Level for the Node Manager can be set in the “NodeManager.properties” file usually located under “WL_HOME\common\nodemanager” folder. “NodeManager.properties” file contains a…
Read MoreBy using following script we can get parameter value in page level. Based on value we can set rendered property for the fields as follows: public void processRequest(OAPageContext pageContext, OAWebBean…
Read MoreUsing 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 MoreObjective: 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 MoreThe 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 More/*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 More