Here is the query to find out the status of Inventory Accounting Periods from back end: SELECT ood.organization_id "Organization ID" , ood.organization_code "Organization Code" ,… Read More »SQL Query to find Status of Inventory Accounting Periods
Here is the query to find out the status of GL and PO Accounting Periods from back end: SELECT sob.name "Set of Books" , fnd.product_code… Read More »SQL Query to find Status of GL and PO Accounting Periods
This is yet another post for Oracle Apps beginners! Difference 1 Value sets can be attached to parameters of a concurrent program or to a… Read More »Difference between Valuesets and Lookups
This is a common question for a every fresher. To help them, here in this post I have summarized in few points which I am… Read More »What is the role of a Technical Consultant in Support and Implementation Project?
Usually this error occurs when the End activity node is not set to ‘End’ which is by default in ‘Normal’ state. Here are the steps… Read More »Workflow Error: Process must contain at least one end activity
Usually this error occurs when the start activity node is not set to start which is by default in ‘Normal’ state. Here are the steps… Read More »Workflow Error: Process must contain a start activity with no ‘in’ transitions
A database link is a path through which a remote user in another database can connect to any other database. Once created the database link… Read More »DB Link in Oracle SQL
Oracle has provided a WFXLoad utility to download Business Event definitions from a database in to a flat XML file. WFXLoad utility works with adjava… Read More »How to migrate Business Events and their Subscriptions
JDR_UTILS is a PL/SQL package which has procedures and functions to query OA Framework personalizations/customizations present in OA Framework metadata in the MDS repository. Here… Read More »All about JDR_UTILS – An API to explore OAF metadata
While working on interfaces we face some requirements like submitting a concurrent program sequentially one after the other. In some scenarios we need to submit… Read More »How to make a Concurrent Program WAIT untill completion of another Concurrent Program execution?