Problem: a project is being developed today. It requires that when the slave block is saved, the field data of the master block changes and is saved to the database. Originally, it was assigned a value from the pre-insert trigger of the block. The interface data has changed but is not saved to the data table. However, the data remains unchanged during the re-query!
Analysis: when the form data changes and is saved in Oracle EBS, the entire form is executed, and the execution sequence of the block is executed sequentially according to the order in the form. If the main block is placed on the slave block, as a result, the main block is executed before it is executed. When it is executed to the slave block, the main block will not be executed!
Solution:
1. Write the insert, update, delete, and other triggers of the Master/Slave block.ProgramUnit
2. Use Oracle EBs to perform block operations directly, but make some settings for it.
2.1 set the console window of the entire form
2.2 adjust the position of the Master/Slave Block