In Material Requisition screen, how can we know who creates the MR, User NOT the Department?
Page 1 / 1
Setting up history logs can help you to get the relevant details
The History functionality provides a way of logging all the interesting transactions in the database. It can be set to detect changes such as inserts, updates or deletes on the table level and then log the chosen attributes.
To Setup the history logging click on Setup History Log in Solution Manager / Monitoring / History and enable insert/update options. It should help you track the changes and the executed by persons for future records.
If you have not setup this, you’ll not be able to track the changes for past records.
The History functionality provides a way of logging all the interesting transactions in the database. It can be set to detect changes such as inserts, updates or deletes on the table level and then log the chosen attributes.
To Setup the history logging click on Setup History Log in Solution Manager / Monitoring / History and enable insert/update options. It should help you track the changes and the executed by persons for future records.
If you have not setup this, you’ll not be able to track the changes for past records.
In case the History Log is not setup and you still want to find out the user who created the Requisition, simply use the below method.
Navigate to SQL Query Tool and enter below SQL Statement
press Execute.
(replace x with the Requisition no)
For Long term:
For long term use, it is possible to create a read only Custom Field with the above SQL to show this information in the screen itself.
Follow below steps to add Created by to your Material Requisition Screen.
Navigate to Custom Fields and create a new Custom Field for LU MaterialRequisition.
Mark Searchable if you want to search using who created them.
Who created will right be there:
(Make sure you add the new field to layout using Properties)
In this example we use v.order_no are pass it to the query as
Navigate to SQL Query Tool and enter below SQL Statement
code:
SELECT created_by_user_id FROM MATERIAL_REQUISITION WHERE order_no = 'x'
press Execute.
(replace x with the Requisition no)
For Long term:
For long term use, it is possible to create a read only Custom Field with the above SQL to show this information in the screen itself.
Follow below steps to add Created by to your Material Requisition Screen.
Navigate to Custom Fields and create a new Custom Field for LU MaterialRequisition.
Mark Searchable if you want to search using who created them.
Who created will right be there:
(Make sure you add the new field to layout using Properties)
In this example we use v.order_no are pass it to the query as
code:
SELECT created_by_user_id FROM MATERIAL_REQUISITION WHERE order_no = :order_no
Thank you Danuka and Shadow for the solutions given. They are very informative and helpful.
Does anyone know why the created by user is not a standard column here or in many other places?
Hi,
I have tried the code in APPS 9 and the
created_by_user_ID
is not in Material_Requisition as a field?
Hi Matthew,
I’m afraid created_by_user_ID is not available in Applications 9 track.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.