OPM Batch – Release and Unrelease
OPM Batch Release : The Release_Batch API checks for the validity of the batch validity rule, and ingredient reservations to create transactions. It also checks for unexploded phantoms, except for…
Read MoreOracle Flow…
Oracle Flow Builder The Oracle Flow Builder application is a keyword-driven component based testing framework for testing Oracle E-Business Suite applications. Oracle Flow Builder starter kit includes 2100+ components and 200 flows for testing Oracle E-Business Suite. The Oracle Flow Builder application consists of the followings: 1. Home 2. Component 3. Component Set 4. Flows 5. Notifications…
Read MoreOracle Test Manager
Oracle Test Manager Oracle Test Manager is an easy to use tool that allows you to organize and manage your overall testing process. It provides a single unified platform for sharing information among team members. Oracle Test Manager has the following features and advantages for integrated requirements management and defect tracking for both manual and automated tests: 1.Requirements Management…
Read MoreReport Carousel in APEX 5 UT [ Dynamic Content ]
Report Carousel in APEX 5 UT [ Dynamic Content ] Overview: 1. Purpose. 2. Benefits. 3. Steps to pass URL in a new window. 4. Browser Related Issues & Solutions. 5. Sample screen shots. 6. Conclusion. 1. Purpose: This document describes how to dynamically moves your data from the report in oracle apex 5. When you add a region to your page with a couple of sub-regions and you give the parent region the “Carousel Container” template it turns the regions into a carousel, so you can flip between regions. I applied the same functionality but than on dynamic content. So I build a report template that would be shown as carousel. 2. Benefits: Ø Can able to move your Data in a report. Ø Don’t need to go for old jquery sliders. Ø In-build Apex 5 Feature but needs modifications in region & report templates level. In Our Apex 5 Internal Application we used this component in Home > Technology News. 3. Steps to create a carousel report:…
Read MoreNotification Message Bar design change in Oracle APEX 4.2 using CSS
Objective: To change the “Notification Message Bar” design throughout the Oracle Application Express 4.2 application. Requirement: Customer has asked us to change the default “Notification Message Bar”, because which is…
Read MoreHighlight Tabular Form Rows on addition from Pop-up
To Highlight Tabular Form Rows on addition from Pop-up: 1. Paste the following code in the dynamic action: On Refresh of region …
Read MoreSet Interactive Report Filter with URL Parameters
Interactive Reports are very powerful, the end user can set filters, highlighting, add computed columns, do control breaks or groupings and much more. As a Developer you might sometimes have…
Read MoreBilling Process in Brazil
The billing process in Brazil has the following steps as there are localizations and also the government involved in approving the sequence numbers for the AR transactions. 1. …
Read MoreEmployee Creation in Oracle
Employee creation in Oracle involves the following steps and APIs 1. Create Person Hr_employee_api..create_employee 2. Create Phone Hr_phone_api. create_or_update_phone 3. Rehire…
Read MoreCreating Custom Value Sets and inserting to base tables through API
Step1: Create custom valuesets in source instance. Use the below API’s to move the value sets to the target instance. Step2: The custom value sets can be passed to the below API’s to insert data to Oracle standard tables fnd_flex_valuesets Ø fnd_flex_val_api.create_valueset_independent f Ø fnd_flex_val_api.create_valueset_dependent Ø fnd_flex_val_api.create_valueset_table Ø fnd_flex_val_api.create_valueset_special Ø fnd_flex_val_api.create_valueset_none Step3: Sample script with description to upload the Independent/Dependent/Table Value sets are explained below Independent Value Set ——————————- DECLARE value_set_name VARCHAR2 (200); description VARCHAR2 (200); security_available VARCHAR2 (200); enable_longlist VARCHAR2 (200); format_type VARCHAR2 (200); maximum_size NUMBER; PRECISION NUMBER; numbers_only VARCHAR2 (200); uppercase_only VARCHAR2 (200); right_justify_zero_fill VARCHAR2 (200); min_value VARCHAR2 (200); max_value VARCHAR2 (200); v_session_mode VARCHAR2 (20) := ‘customer_data’; x VARCHAR2 (200); v_msg VARCHAR2 (2000); BEGIN fnd_flex_val_api.set_session_mode (v_session_mode); value_set_name := ‘CUST_VAL_SET_DEMO’;…
Read More