Report Builder Components
Report Builder Components 1. Data Model 2. Layout Model 3. Object Navigator 4. Report Triggers 5. Parameter Form 6. Program Units 7. Attached Libraries Data Model The Report Editor’s Data…
Read MoreAIM Document Specifications
AIM Document Specifications: 1. Business Process Architecture (BP) 2. Business Requirements Definition (RD) 3. Business Requirements Mapping 4. Application and Technical Architecture (TA) BP.010 Define Business and Process Strategy BP.020…
Read MoreHow to find error messages while doing Oracle workflow activities from backend.
Finding error messages while doing workflow activities from backend. Approach: Find a workflow internal name Query the workflow table with…
Read MoreSetting Timeout for a Notification in Oracle Workflow
Requirement: Timeout period should be 48 hours for a notification. Approach: 1. Go to particular Notification Label 2. Select the properties 3. Select the Node tab 4. Change the Timeout …
Read MoreDisplaying subtotal and grand total based on the group column in BI Publisher Template
For Example Display the sub total values based on Account code and show grand total end of the report. The report has only one group (G_ACCT) and group columns like …
Read MoreImplementing Search Functionality using LOV during query in Oracle Forms
Requirement : Enable ‘Execure-Query’ using an LOV field (non-database items) . Approach: When user clicks on CTRL+F11 we need set dynamic where clause. Normally for database fields Oracle standard feature…
Read MoreParsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms
In some cases, we get a comma separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…
Read MoreHow to change a LOV query Using Forms Personalization
We can change the LOV query using form personalization. Sample provided below (Payment form). Requirement: We have to change the “type” field lov query for populating the custom values. To…
Read MoreMTL Material Transactions Interface
Solution : This blog explains the technical approach for creating an automated interface to accept user supplied material transactions from External Systems and to import these transactions to Oracle as…
Read MoreDaily Exchange Currency Rates Interface
Solution : URL will be passed as parameter where we can identify the currency rate conversion amount. FROM_CURRENCY , TO_CURRENCY and the date for when it has to be run…
Read More