Oracle Application Blog

Personalization at Adjustment/Sales order/Credit Memo application form

This component can be used, for requirement related to personalization where we want to restrict the user to create RMA/Adjustment/Credit memo if certain(user defined) conditions are not met. Personalization at Transaction/Adjustment…

Create AR Transaction/Invoice adjustment(API)

Scope: To apply the adjustment in AR Invoice. (eg. To make AR Invoice amount roundoff). Before RoundOff adjustment API. Applying Adjustment through API. —++———————————-Code—————–++————————- DECLARE up_adj_rec         …

Opening Modal Dialog page using JavaScript

In APEX, when there is a requirement for opening pages dynamically JavaScript must be used. Normal pages can be easily opened in JavaScript’s by mentioning the URL using window.location, but…

Hiding Hidden column cells in IR using CSS

Select List Pagination in APEX IG

One main disadvantage of APEX Interactive Grid is the pagination. IG default pagination doesn’t have the option as classic Select List Pagination, instead it has page by page selection with…

Refresh IG on Region Display Selector Activation

Interactive Grid region within the region display selector must be refreshed every time on click/activation of the region display selector. This can be achieved by using the below code there…

Displaying Processing Spinners in APEX AJAX Process

When a process is called in APEX page without page submission (AJAX Process), user will have no visual feedback that something is happening. For example if an AJAX (apex.server.process) “EMP_INSERT”…

Building Dynamic Regions in Oracle APEX using APEX API

Modifying region queries/source dynamically can be done easily, whereas building regions dynamically can be done only using APEX API. Using the below code, a static region and a chart region…

Oracle EBS Active Users/Employee Details and their Active responsibilities find Query

SELECT fu.user_name,      PAPF.FIRST_NAME||PAPF.LAST_NAME Employee_Name,      fu.EMAIL_ADDRESS User_Attached_Email,      papf.email_address Emp_attached_eamil,       frv.responsibility_name,       frv.responsibility_key,       TO_CHAR (furgd.start_date, ‘DD-MON-YYYY’) “User_Resp_START_DATE”,       TO_CHAR (furgd.end_date, ‘DD-MON-YYYY’) “User_resp_END_DATE”,       fu.start_date User_start_date,       fu.end_date User_End_date,       frv.start_date resp_start_date,       frv.End_date resp_End_date,       PAPF.effective_start_date Emp_start_date,       PAPF.EFFECTIVE_END_DATE Emp_end_date    FROM apps.fnd_user fu,  apps.fnd_user_resp_groups_direct furgd,  apps.fnd_responsibility_vl frv,   APPS.PER_ALL_PEOPLE_F PAPFWHERE fu.user_id                     = furgd.user_idAND furgd.responsibility_id          = frv.responsibility_idand upper(frv.RESPONSIBILITY_NAME)…

Positive Pay Templates

A positive pay file is a security measure in the form of a document that the deploying company sends to its payment system or bank to inform it of payments made by check.  In Oracle EBS R12, Oracle has introduced Oracle Payments as a new module that is comprised of funds capture (receipt of funds electronically from customers) and funds disbursement (payment of funds owed to suppliers)  Within the Oracle Payment Administrator function, there is a seeded positive pay file format that is available to be associated with a payment process profile. However, most of the time, Oracle users have to end up modifying the Positive Pay File format to match up to their Bank’s specifications.  To Download the seeded Positive Pay File Template follow the below navigation Navigate: Payables Responsibility –> SetUp –> Payment –> Payment Administrator Go to XML Publisher Format Templates and search for Positive Pay File Download the attached rtf file and then customize the template. And go to the XML Publisher Format Templates and create new template. Now Navigate : Payables Responsibility –> SetUp –> Payment –> Payment Administrator Formats Create “Disbursement Positive Pay File” as shown below To Assign the template: Navigate: Payables Responsibility –> SetUp –> Payment –> Payment Administrator Go to Payment Process Profiles and search for the Payment Process profile Now add the customized template name in the Positive pay –> Format You are now ready to submit your Positive Pay program. This is done by running the “Positive Pay File with Additional Parameters” program which can be scheduled to run nightly at a given time. You can also opt to transmit the positive pay file immediately upon completion of a Payment Process Request. Be sure to provide both the Format and the Bank Account for which you are running the Positive Pay program. -Gayathri