Ask the Experts - 38
I am currently working on the peopletools version 8.22 and application version 8.43.489.
I have one requirement for the prompt on the Bankcode field.
Currently, the bank code field is prompted based on the company of the employee. It needs to be changed as per below requirements.
Bank code should be prompted based on the current location of the employee.Also Prompt should also display the list of bank codes which are associated to the company of the employee and which doesn’t have location codes associated to it at the setup level. Also Prompt should also display the list of bank codes which are associated to the employee’s country and which doesn’t have company or location associated to it at the setup level.
I have tried the same to achive the same by using dynamic views but there i was not able to do it on the all above three conditions.
I have tried to use record.field.sqltext on the field for which dynamic view is specified but i am getting error “Invalid Property”.
How can we get the single view runtime validating all the conditions.?
Thanks for posting your question!
Consider using UNION to validate all the conditions mentioned in the requirements.