Knowledge management
We meticulously document the recipes and intricacies that we uncover. who masters the intricacies masters the world.
PL/SQL
Useful Links
- Time interval aggregation
- Time with milliseconds
- Export of RU-objects from OeBS
- Extracting the second record of a group into a separate field
- Pseudorandom data generation
- Importing an XML document into a table using the DBMS_XMLSAVE package
- Concatenation without using wm_concat
- Cursor with parameters
- Parsing a string with delimiters
- Retrieving DDL of an object from a linked database
- Example of using PIVOT, UNPIVOT
- Viewing sessions blocking GTT
- Viewing current locks
- Simple array of arbitrary length
- Calculation of the financial indicator IRR (Internal Rate of Return)
- Roman numerals
- Oracle system tables and views
- Creating a temporary table with an object-type column
- Creating a variable in the CLIENTCONTEXT context
- Creating a variable in a custom context
- Deleting full duplicates
- Generating a field from a sequence of numbers
- Language settings for an instance
- Foreign key references for a table
- Predefined Inquiry Directives
Useful Links
Oracle Workflow
OAF
- Inserting links into notifications
- Dynamic message creation
- Commits in WF API
- Open notifications for the current user
- Post-processing of notification responses
- Predefined message attributes
- Programmatic creation of attributes
- Pushing a process forward
- Working with attributes
- Creating a child process
- Creating and launching a process
- Creating and deleting ad-hoc roles
- Notification response API
OAF
- Unconditional page redirection
- Calling a DB procedure
- Dynamic creation of View Object
- Using attributes from different levels of VO in bean attributes
- Converting a string to an oracle.jbo.domain.Date object
- Wrapping VO with constraints
- Exception handling
- Clearing the VO dataset (iterator)
- Clearing the VO dataset (method)
- Clearing VO when using retainAM=Y
- Page redraw with hashmap
- Finding a record in VO
- Building master-detail in a table component
- Programmatically changing the title of a webbean
- Recursive creation of hGrid levels
- Centering column content (hGrid)
- Centering column content (table)
- Formatting using the Formatter interface
- hGrid not redrawing upon data filtering
- invokeMethod with full parameters
- Switcher working within hGrid
Oracle ADF
Oracle XML Publisher
OeBS R12 Miscellaneous
- Element visibility based on a checkbox
- JavaServer Faces page lifecycle
- Closing a popup window when clicking any button
- Opening a popup window upon navigating to a page
- Clearing bind variables by ViewCriteria
- Retrieving the ID of the selected item in Choice
- Forcing an update of the selected item in valueChangeListener
- Solution for "Cannot convert date of type java.sql.Timestamp to class oracle.jbo.domain.Timestamp"
- GET request from VO attributes
Oracle XML Publisher
- Cell/row attribute
- Grouping
- Column merging
- Row merging
- Initial setup of an XSL template
- Text wrapping with automatic row height adjustment
- Conditional operator, loop operator
OeBS R12 Miscellaneous
Articles
ceo@thomsonslegacy.com
We customize Oracle e-Business Suite R12 modules with Oracle Applications Framework and providing Oracle ADF based solutions
We customize Oracle e-Business Suite R12 modules with Oracle Applications Framework and providing Oracle ADF based solutions
© Thomsonslegacy.com, 2025.
If you publish the materials of the site, the reference to the source is obligatory. The site uses cookies.