How to Generate Trace for a Seeded or Custom Concurrent Program/Report?

This article tells you the process of generating trace for a concurrent program which will be helpful for debugging. Step 1: Enable trace for a concurrent program Navigate to System Administrator Responsibility –> Concurrent Programs –> Define and Query the program/report and then enable check box Enable trace Step 2: Enabling Debugging Profile Option Navigate… Read More »

What is MO_GLOBAL.INIT and When to Use MO_GLOBAL.INIT?

Before reading this post, if you are new to Multi Org and MOAC then read: MOAC – Oracle Apps ORG_ID, Multi Org Concept What is MO_GLOBAL.INIT ? MO_GLOBAL.INIT will read the “MO: Operating Unit” and “MO: Security Profile” profile option values from the current context (responsibility/user) and will initialize access to Multiple Organizations. How does… Read More »

API to add a Claim Line to already existing Claim

SET serveroutput ON;   DECLARE l_return_status VARCHAR2 (1); l_msg_count NUMBER; l_msg_data VARCHAR2 (20000); l_resp_name VARCHAR2 (100) := ‘Oracle Trade Management User’; l_user_name VARCHAR2 (100) := ‘SYSADMIN’; l_claim_number CONSTANT VARCHAR2 (25) := ‘CLA10107’; l_appl_id NUMBER; l_resp_id NUMBER; l_user_id NUMBER; l_org_id NUMBER; l_line_counter NUMBER := 1; l_claim_id NUMBER; l_api_version CONSTANT NUMBER := 1.0; l_error_index NUMBER; l_claim_line_pub_tbl ozf_claim_pub.claim_line_tbl_type;… Read More »

PL/SQL Script to Inactive and Delete Adhoc Role

DECLARE lc_role_name apps.wf_roles.name%TYPE := ‘XX_TEST_ROLE’; BEGIN wf_directory.setadhocroleexpiration(lc_role_name, sysdate -1 ); COMMIT; wf_directory.setadhocrolestatus( lc_role_name, ‘INACTIVE’); COMMIT; wf_directory.deleterole(lc_role_name , ‘WF_LOCAL_ROLES’ , 0); COMMIT; END; /DECLARE lc_role_name apps.wf_roles.name%type := ‘XX_TEST_ROLE’; BEGIN wf_directory.setadhocroleexpiration(lc_role_name, sysdate -1 ); COMMIT; wf_directory.setadhocrolestatus( lc_role_name, ‘INACTIVE’); COMMIT; wf_directory.deleterole(lc_role_name , ‘WF_LOCAL_ROLES’ , 0); COMMIT; END; / PL/SQL Script to Create Adhoc Role PL/SQL Script to Remove… Read More »

Adhoc Roles in Oracle Workflow

Before reading this article, read about Roles in Workflow if you are not aware of what a role is about. A role can be created from application from “User Management” responsibility. Adhoc role is something which can be created dynamically using PL/SQL on run time based on requirement. Not only Adhoc role can be created… Read More »

PL/SQL Script to Remove and Add Users to Adhoc Role

DECLARE ln_role_users_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO ln_role_users_count FROM apps.wf_user_roles WHERE NAME = lc_role_name;   IF ln_role_users_count > 0 THEN ——————————– –Removing users from Adhoc Role ——————————– apps.wf_directory.removeusersfromadhocrole (role_name => lc_role_name);   dbms_output.put_line("Users removed from Role!"); END IF; ——————————– –Adding users to Adhoc… Read More »

PL/SQL Script to Create Adhoc Role

DECLARE ln_role_count NUMBER; lc_role_name apps.wf_roles.NAME%TYPE := ‘XX_TEST_ROLE’; lc_role_display_name apps.wf_roles.description%TYPE := ‘XX Test Role’; BEGIN —————————— –Checking if Adhoc Role Exits —————————— SELECT COUNT (1) INTO ln_role_count FROM apps.wf_roles WHERE NAME = lc_role_name;   IF ln_role_count = 0 THEN ——————— –Creating Adhoc Role ——————— apps.wf_directory.createadhocrole (role_name => lc_role_name, role_display_name => lc_role_display_name, notification_preference => ‘MAILHTM2’ );  … Read More »

What is a Role in Oracle Workflow

A Role in Oracle EBS is a a categorization of set of users who share same responsibilities. A role will have one or more users under it. When a notification in Oracle Workflow needs to be sent to multiple users, a role is created with set of users and notifications is sent to the role.… Read More »

Query to list all Documents and their information under a Payment Process Request

This query list all payment documents under a payment batch with detailed invoice and Supplier/Employee information. /********************************************************************** *PURPOSE: Query to list all Documents and their information under a Payment Process Request *AUTHOR: Shailender Thallam ***********************************************************************/ SELECT ip.payment_process_request_name, invh.invoice_id , invh.vendor_id , invh.invoice_num , invh.invoice_amount , invh.amount_paid , idpa.payment_date , idpa.document_type , idpa.payment_amount , idpa.payment_method_code ,… Read More »