On Hand Quantity in R12 TABLE Detail

Find On Hand Quantity in R12

R12 Tables To Find the On hand Quantity

on hand Quantity --> quantity from mtl_onhand_quantities_details
Allocated Quantity --> mtl_material_transactions_temp
Reserved Quantity --> mtl_reservations

Hope this Information will help you to develop simple SQL Scripts ...

How to Open Multiple Oracle Instance in Windows

How to Open Multiple Oracle Instance in Windows :

Go to IE in desktop

Right Click and select properties.

In Target add space –nomerge after iexplore.exe"

Like below and it works.

"C:\Program Files (x86)\Internet Explorer\iexplore.exe" -nomerge

OPM Process Execution Tables R12

OPM PROCESS EXECUTION TABLES R12

• GME_BATCH_HEADER
• GME_BATCH_HEADER_MIG
• GME_BATCH_HISTORY
• GME_BATCH_MAPPING_MIG
• GME_BATCH_SALES_ORDERS
• GME_BATCH_STEPS
• GME_BATCH_STEPS_MIG
• GME_BATCH_STEP_ACTIVITIES
• GME_BATCH_STEP_ACTIV_MIG
• GME_BATCH_STEP_CHARGES
• GME_BATCH_STEP_CHARGES_MIG
• GME_BATCH_STEP_DEPENDENCIES
• GME_BATCH_STEP_DEP_MIG
• GME_BATCH_STEP_ITEMS
• GME_BATCH_STEP_ITEMS_MIG
• GME_BATCH_STEP_RESOURCES
• GME_BATCH_STEP_RESOURCES_MIG
• GME_BATCH_STEP_RSRC_SUMMARY
• GME_BATCH_STEP_TRANSFERS
• GME_BATCH_STEP_TRANSFERS_MIG
• GME_BATCH_TXNS_MIG
• GME_ERES_GTMP
• GME_EXCEPTIONS_GTMP
• GME_GANTT_DOCUMENT_FILTER
• GME_INVENTORY_TXNS_GTMP
• GME_LAB_BATCH_LOTS
• GME_MATERIAL_DETAILS
• GME_MATERIAL_DETAILS_MIG
• GME_MATERIAL_DISPENSING_GTMP
• GME_MIGRATION_CONTROL
• GME_PARAMETERS
• GME_PENDING_PRODUCT_LOTS
• GME_PROCESS_PARAMETERS
• GME_PROCESS_PARAMETERS_MIG
• GME_RESOURCE_TXNS
• GME_RESOURCE_TXNS_GTMP
• GME_RESOURCE_TXNS_MIG
• GME_RESOURCE_TXNS_SUMMARY
• GME_SCALE_DETAIL
• GME_TEMP_EXCEPTIONS
• GME_TEXT_HEADER
• GME_TEXT__TL
• GME_TRANSACTION_PAIRS
• GME_UNALLOCATED_ITEMS_GTMP

OPM Inventory Tables R12

OPM INVENTORY TABLE R12

• BISOPM_ONHANDSALE_SUM
• BIS_OPM_PROD_SUM
• GMI_AUTO_ALLOCATION_BATCH
• GMI_CATEGORY_SETS
• GMI_CLOS_WAREHOUSES
• GMI_DISCRETE_TRANSFERS
• GMI_DISCRETE_TRANSFER_LINES
• GMI_DISCRETE_TRANSFER_LOTS
• GMI_ITEMS_XML_INTERFACE
• GMI_ITEM_CATEGORIES
• GMI_ITEM_CONV_AUDIT
• GMI_ITEM_CONV_AUDIT_DETAILS
• GMI_ITEM_ORGANIZATIONS
• GMI_LOTS_CONV_XML_INTERFACE
• GMI_LOTS_XML_INTERFACE
• GMI_LOT_TRACE
• GMI_MASSTRANS_CTL
• GMI_MIGRATION_PARAMETERS
• GMI_OBSOLETE_ITEM_COLUMNS
• GMI_QUANTITY_XML_INTERFACE
• GMI_SUBLOT_GENERATE
• GMI_TRAN_TMP
• IC_ADJS_JNL
• IC_ALLC_CLS
• IC_ALOT_PRM
• IC_CLDR_DTL
• IC_CLDR_HDR
• IC_CLDR_HDR_B
• IC_CLDR_HDR_TL
• IC_COMD_CDS
• IC_COST_CLS
• IC_CRUL_CLS
• IC_CTMS_CLS
• IC_CYCL_ADT
• IC_CYCL_DTL
• IC_CYCL_ERR
• IC_CYCL_HDR
• IC_CYCL_MSC
• IC_DECM_MST
• IC_FRGT_CLS
• IC_GLED_CLS
• IC_INVN_CLS
• IC_INVN_TYP
• IC_ITEM_CDT
• IC_ITEM_CNV
• IC_ITEM_CPG
• IC_ITEM_HIERARCHY
• IC_ITEM_MST
• IC_ITEM_MST_B
• IC_ITEM_MST_B_MIG
• IC_ITEM_MST_TL
• IC_ITEM_WHS
• IC_JRNL_MST
• IC_LOCT_INV
• IC_LOCT_MST
• IC_LOTS_CPG
• IC_LOTS_MST
• IC_LOTS_MST_MIG
• IC_LOTS_STS
• IC_PERD_BAL
• IC_PHYS_CNT
• IC_PHYS_ERR
• IC_PKGS_MST
• IC_PLNT_INV
• IC_PRCE_CLS
• IC_PRCH_CLS
• IC_PURG_PRM
• IC_RANK_MST
• IC_SALE_CLS
• IC_SHIP_CLS
• IC_STAT_RPT
• IC_STOR_CLS
• IC_SUMM_INV
• IC_TAXN_ASC
• IC_TAXN_CLS
• IC_TEXT_HDR
• IC_TEXT_TBL_TL
• IC_TRAN_ARC
• IC_TRAN_CMP
• IC_TRAN_PND
• IC_TXN_REQUEST_HEADERS
• IC_TXN_REQUEST_LINES
• IC_WHSE_INV
• IC_WHSE_MST
• IC_WHSE_REL
• IC_WHSE_STS
• IC_XFER_MST
• IN_ADDR_MST
• IN_CTRY_MST
• IN_ITEM_MST
• IN_REGN_MST
• IN_STAT_CTL
• IN_STAT_DTL
• IN_STAT_HDR
• IN_STAT_MSG
• IN_TEXT_HDR
• IN_TEXT_TBL_TL
• IN_TOFD_MST
• SY_WF_ITEM_ROLES

Work Flow Mailer Send Mail from the Cloned Instance

Do you find that ,

YOur Work Flow mailer is trigerring Mail often when you clone your Instance and you are unable to test the New stuff using work Flow Mailer


Here is the solution for the Work flow mailer to stop sending older mails in the Test Instance

UPDATE WF_NOTIFICATIONS

SET STATUS = 'CLOSED'

where status ='OPEN';

UPDATE WF_NOTIFICATIONS

SET MAIL_STATUS = 'SENT'

where status ='OPEN';

commit; 

Simple , but very Effective steps to Contrl your work flow mailer , sending old mails


Check  this Steps too:

Applicatioin Manager -- > Application Dashboard ->


Application System-- > Dev--> service Components --> Component Details

Set override Address : Dev: Work Flow Notification Mailer

Enter the Over Ride Address : *******. Mail .Com


Update the scripts:

update fnd_svc_comp_param_vals fscpv
set fscpv.PARAMETER_VALUE = '<override email address>'
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');

If this is Entered he/She will receive all the notification mails which has beed triggred in the DEv or UAT

Step 1Login to "Workflow Administrator Web Applications"


Step 2
Ensure that Notification Mailer is running, and then click on icon as below


Step 3
Click on "View Details"




Step 4.
Click on "Set Override Address"




Step 5.
Finally you can change the email address here. Please read the instructions in red carefully.

Unable to View the Assigned Responsibility

Unable to View the Assigned responsibility Even after the End date is removed from the USER


Run the Concurrent Program

Synchronize WF LOCAL tables

Workflow Directory Services User/Role

If still you find this issue is not resolved , then pls go head and Run the Script in the Putty

exec wf_maintenance.ValidateUserRoles(p_BatchSize => 1000, p_check_dangling => FALSE, p_check_missing_ura => TRUE, p_UpdateWho => FALSE);

Go to respon Funtional Administrator > Home > Core Services > Caching Framework > Global Configuaration > Clear All Cache

This should work

Disable diagnostics/examine/personalization Password

How to disable prompting the password for diagnostics/examine/personalization for forms ?

To disable prompting the apps password for diagnostics and examine/personalizations at form level



Set the value as Yes to the profile option
 "Utilities: Diagnostics" at any level


Utilities: Diagnostics = YES


Debug Profile Value , to Debg the Concurrent Program OM and Inventory

Hi Maria,


The Pick Selection Triggered and i have attached the Log files for your reference ,

Debug Profile values has been set as follows

OM: Debug Level - set to 5
INV: Debug Level - set to 10
WSH: Debug Enabled - set to Yes
WSH: Debug Level - set to Statement

Set it to User Level , So that It will not Impact system performance