Oracle has provided an API IEX_DISPUTE_PUB.CREATE_DISPUTE which is part of Advanced Collections to create a dispute on an Invoice Transaction. Below is the sample API… Read More »PL/SQL API to Create Dispute on an Invoice Transaction
Trace file is not in a understandable format, but to make it easier to understand and readable Oracle has provided a utility TKPROF. Syntaxt to… Read More »What is TKPROF? How to run TKPROF?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /************************************************************ *PURPOSE: To change/reset… Read More »PL/SQL Script to Reset User Password from Backend
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… Read More »How to Generate Trace for a Seeded or Custom Concurrent Program/Report?
Some times we see a message “Low-level Diagnostic Logging is turned on. This may temporarily reduce performance” which slow downs the application response time. This… Read More »Low-level Diagnostic Logging is turned on. This may temporarily reduce performance
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… Read More »What is MO_GLOBAL.INIT and When to Use MO_GLOBAL.INIT?
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) :=… Read More »API to add a Claim Line to already existing Claim
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… Read More »PL/SQL Script to Inactive and Delete Adhoc Role
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… Read More »Adhoc Roles in Oracle Workflow
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 =… Read More »PL/SQL Script to Remove and Add Users to Adhoc Role