Oracle Application Blog

Deploying “Create Employee” API as REST Service :

1. 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 More

Script to Import CRM Resource

DECLARE    l_jtf_person_id      NUMBER;                              /*Assign Value*/    l_jtf_user_id        NUMBER;     …

Read More

Script to Assign Salesrep Role in CRM

DECLARE    l_jtf_person_id   NUMBER;                                 /*Assign Value*/    lc_resource_id    jtf_rs_resource_extns.resource_id%TYPE;     ln_role_id       …

Read More

Script to add employee as buyer

DECLARE    l_agent_id          NUMBER;    l_employee_number   VARCHAR2 (20);    l_buyer_rowid       VARCHAR2 (100); BEGIN    BEGIN       SELECT person_id        …

Read More

Query to retrieve GL Journal Import

SELECT        glc.segment1        || ‘-‘        || apps.gl_flexfields_pkg.get_description_sql                              …

Read More

Dynamic Approver List for AME

Oracle has provided an API to get the dynamic list of approvers for AME. ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list. We need to pass the transaction type id and transaction number. Rransaction Id is available…

Read More

Project Accounting – Useful Queries

Project Basic Query: select proj.carrying_out_organization_name  project_organization,   proj.segment1  project_number,   proj.name  Project_Short_Name,   proj.city ,   proj.region,   proj.long_name project_long_name,   proj.start_date  transaction_start_date,   proj.target_finish_date  Target_Finish_Date,   proj.project_type ,  …

Read More

Insert Run Report in Excel for Apps

Insert Run Report Feature in ExcelforApps Insert Run functionality is used to return sum, count, max etc for the datapoint(columns) in E4A Report. The value will be returned in the…

Read More

How to Use Associative array in select statement as normal database table

Associative array in select statement as normal database table Step 1 First Create Associative Array Type TYPE  assoc_array_type  IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER; if required We can use…

Read More

File Moving and renaming using UNIX SHELL Script in EBS

#!/bin/bash ################################################################################# # File_Name    : imauanzstmtfilearchv.prog                                               …

Read More