How and when costing will be done for material transactions? Once inventory transactions are completed then records will be inserted into MTL_MATERIAL_TRANSACTIONS table and can… Read More »How costing is performed on Inventory Material Transactions
A Sales Order can get into backorder state after performing Pick Release on a Sales Order but there are many reasons for a Sales Order… Read More »11 Reasons for a Sales Order to get Backordered!
Record History is one of the excellent feature implemented by Oracle to track the data changes made by the users. Today in this article I… Read More »FAQ on Tracking Data Changes with Record History (WHO Columns)
Here is the Query to list Months and Years. I developed this query to prepare a LOV for Credit Card Expiration date. 1 2 3… Read More »Oracle SQL Query to list Months and Years
What is the purpose of Workflow Background Process Workflow Background Process is a concurrent program which is run for processing deferred activities, timed out activities,… Read More »Useful Information about Workflow Background Process Concurrent Program
When ever a user account(FND User) is created , it is created as user in Workflow Directory Services (WF DS) table WF_LOCAL_ROLES with user_flag as… Read More »Information about Users and Responsibilities in Oracle Workflow Directory Service
Recently I have encountered this situation where few of the user were not able to see their Responsibilities on their home page after applying an… Read More »No Responsibilities Visible to User on Self Service Home Page
I faced this issue on Oracle Apps R12.1.2 where in a user is not receiving email notifications. To confirm whether the problem exists or not… Read More »Workflow Email Notifications not working for a particular user
Query to find Oracle Apps Login URL SELECT home_url FROM icx_parameters;SELECT home_url FROM icx_parameters; Query to find Oracle Apps Instance Version SELECT release_name FROM fnd_product_groups;SELECT… Read More »Some Useful Queries to know Information about your Oracle Instance
To know what is FNDLOAD Utility? and how to use it?, do read this article Here are the FNDLOAD Scripts to Migrate 15 different AOL… Read More »FNDLOAD Scripts to Migrate AOL Entities