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…
Read MoreWhen 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”…
Read MoreModifying 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…
Read MoreSELECT 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)…
Read MoreA 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
Read More1. Go to Integrated SOA Gateway –> Integration Repository The below page will open. 2. Click on the Search button. 3. Provide the Business Entity field with “Employee” and then click on Go 4. Now click on HR_EMPLOYEE_API which is highlited in the below screen shot. 5. Now go to “Rest Web Service” tab. You can see the “Rest Service Status” field as “Not Deployed”. 6. Now select the Service Operations which you want to deploy, Provide the “Service Alias” field with the Alias name and then click on “Deploy” button present at the bottom of the page. 7. Then the “Rest Service Status” field changes to “Deployed” as shown in the below screen shot. 8. Now we need to give grants to application users for this deployed API. For that go to “Grants” tab. 9. Select the Object for which you want to provide grants and click on “Create Grant” button. We can provide grants to Specific User, Group of Users or for All the Users. 10. We will select “Group of Users” and select the responsibility in the “Grantee Name” and click on “Create Grant” button. 11. Once the Grants are created go to “Rest Web Service” tab and click on the link “View WADL”. An XML will open where we can find the xsd link and the Resource Base link which can be used to connect to MAF application. -Gayathri
Read MoreDECLARE l_jtf_person_id NUMBER; /*Assign Value*/ l_jtf_user_id NUMBER; …
Read MoreDECLARE l_jtf_person_id NUMBER; /*Assign Value*/ lc_resource_id jtf_rs_resource_extns.resource_id%TYPE; ln_role_id …
Read MoreDECLARE l_agent_id NUMBER; l_employee_number VARCHAR2 (20); l_buyer_rowid VARCHAR2 (100); BEGIN BEGIN SELECT person_id …
Read MoreSELECT glc.segment1 || ‘-‘ || apps.gl_flexfields_pkg.get_description_sql …
Read More