La receta para implementar la funcionalidad de folders en formas creadas para Oracle Applications. Esto permite el mostrar/ocultar columnas de un layout tabular asi como cambiar la posición, tamaño y etiquetas de las mismas.
Esto lo publiqué como un knol y está en inglés, si hay alguna duda me avisan. Para ver el artículo completo dar click en ¨Continuar Leyendo¨.
Si no puedes ver el contenido, favor de dirigirte a la siguiente url: http://knol.google.com/k/cuauhtemoc-amox-cornelio/quick-guide-on-database-objects/153594c4goidl/21?collectionId=153594c4goidl.11&position=15
In order to reach a wider audience, from now on, posts will written be mostly in English. I Know sometimes is really difficult to find information in Spanish, but that should be a motivation to learn English instead of giving up or complaining about the lack of help on the web. Still, those who now me know where to reach me and can always discuss Oracle in our mother language and curse on it, as that's one particular topic where Spanish is way better than English.
Parallel to this blog, I've been also maintaining a knol. Being the consolidation need another reason to decide what language to keep writing on. From now on I'll be writing on the know, as I like better that interface for writing tutorials and how-to's. Articles will be embedded here also individually. In the meantime, here is a list of all the posts I've written so far.
If the list doesn't appear (seems to have issues with Safari), you can view it at http://knol.google.com/k/cuauhtemoc-amox-cornelio/a-m-o-x-o-r-a-c-l-e/153594c4goidl/11#
Algo que no me ha parecido en cuanto al comportamiento de Oracle Workflow es el referente a que cuando se recompila algún procedimiento almacenado que es referenciado por el mismo, sea una actividad o atributo tipo documento, el workflow truena con errores de que el estado del package es inconsistente, o no existe, y a diferencia de una sesión de pl/sql, no se soluciona con reintentar el llamado o si se está utilizando la aplicación, cambiarse de responsabilidad.
El problema requiere lo siguiente para solucionarlo (Nota 761638.1) , lo cual no me agrada en lo absoluto:
When a package is compiled, all copies in the shared pool are flagged as invalid. The error ORA-04061 in the error stack is caused because the notification mailer is reading an old version of the package stored in memory.
1. Please bring down the concurrent managers, forms server, apache server, etc....on the middle tier. - It is recommended that $COMMON_TOP/admin/scripts/SID/adstpall.sh apps/apps or equivalent be used.
2. Enter adadmin - Recompile the APPS schema - take note of invalid objects prior - and then thereafter -to ensure no new invalid objects are created.
3. Bring the instance back up - and retest this problem at hand.- Ensure the notification mailer is bounced completely when restarting the instance
4. Retest the problem by creating a new requisition - confirm that the approval is flowing properly.
For the requisitions which are still in error, please login as the System Administrator - and utilize the RETRY option that will be available in the notifications which were sent identifying the error.
