CallableStatement: Calling PL/SQL Procedure from OAF
We need to use a Callable Statement to call either a function or a procedure from OAF. Here are the steps to call a PL/SQL… Read More »CallableStatement: Calling PL/SQL Procedure from OAF
Shailender Thallam
RowSetIterator in OAF: Usage of Row Set Iterator to Traverse VO Rows
RowSetIterator It is the interface for Row Set Iterator. A Row Iterator is an iterator over a collection of View rows or Entity rows. Usage… Read More »RowSetIterator in OAF: Usage of Row Set Iterator to Traverse VO Rows
OPM Quality: API to create Samples and Add Test Results to Samples
Here is an API approach to create Samples from backend and add Test results to Samples. Firstly we need to create Sample using API gmd_samples_pub.create_samples… Read More »OPM Quality: API to create Samples and Add Test Results to Samples
OPM Quality – Query to List Test Codes Information
/********************************************************* *PURPOSE: Query to List Test Codes Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gqtb.test_id, gqtb.test_code, gqtt.test_desc, gqtb.test_class, gtmb.test_method_code, lkp1.meaning data_type, gqtb.test_unit, lkp2.meaning priority… Read More »OPM Quality – Query to List Test Codes Information
OPM Quality – Query to List Specification and Tests Information
/********************************************************* *PURPOSE: Query to List Specification and Tests Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gsb.spec_id, gsb.spec_name, gsb.spec_vers version, gs.meaning spec_status, lkp1.meaning spec_type, msi.segment1… Read More »OPM Quality – Query to List Specification and Tests Information
OPM Quality – Query to List Samples Information
/********************************************************* *PURPOSE: Query to List Samples Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gs.sample_no, sample_desc, gs.organization_id, msi.segment1 item_number, msi.description , gs.sampling_event_id , gs.step_no ,… Read More »OPM Quality – Query to List Samples Information
How to Close Approval or Response Required based Notifications from backend?
Earlier we have seen how to close FYI based notification. Here in this article lets see how to close Approval/Response based notification from backend. Since… Read More »How to Close Approval or Response Required based Notifications from backend?
How to Generate Debug Logging for Custom Extensions
It would be tiresome for most of us to debug issues especially in extensions when we have no clue of flow of process execution and… Read More »How to Generate Debug Logging for Custom Extensions
Steps To Clear Cache Using Functional Administrator for OA Pages
Why do we need to clear Cache? Clearing Cache makes the OA engine to refresh the middle tire cache by reloading the configurable or session… Read More »Steps To Clear Cache Using Functional Administrator for OA Pages
What is the role of a Functional Consultant in Support and Implementation Project?
Who is a Functional Consultant? A role of functional consultant involves in understanding the client’s business process, requirements and mapping to the Oracle EBS system… Read More »What is the role of a Functional Consultant in Support and Implementation Project?