No records are returned from reports/forms based on synonyms in R12
Recently did the R12.1.3
upgrade from 11i. All the custom reports and forms which were using views were
replaced with synonyms available in R12. These reports and forms are registered to the custom application.The client is not using MOAC feature.However when we query the form no
records are displayed and same is the case when the report is submitted.
Just for an example the underlying synonym is AR_PAYMENT_SCHEDULES.
However if we add below code in pre-form trigger or before report trigger then records are displayed and for report had to set the OU mode at concurrent program definition.
Just for an example the underlying synonym is AR_PAYMENT_SCHEDULES.
However if we add below code in pre-form trigger or before report trigger then records are displayed and for report had to set the OU mode at concurrent program definition.
0