Sales Orders not getting Invoiced

If Invoice not interfaced 1. Order Type workflow assignments to check if there is an invoicing node. 2. From Order –> Lines go to Tools –> Workflow Status, check if the Invoice Interface is complete as shown in the attachment. Lines stuck in Interface Trip Stop? Check in Shipping–> Interfaces –> Run and select ITS… Read More »

What is TKPROF? How to run TKPROF?

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 run TKPROF TKPROF <trace-file> <output-file> [options]TKPROF <trace-file> <output-file> [options] Note: Its mandatory to set environment before running TKPROF. TKPROF Example TKPROF PerfIssue.trc PerfIssue.prf — –Another way with options — TKPROF… Read More »

PL/SQL Script to Reset User Password from Backend

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 password of a user from backend * *AUTHOR: Shailender Thallam * *************************************************************/ SET serveroutput ON; DECLARE v_user_name VARCHAR2(30):= UPPER(’SYSADMIN’); v_new_password VARCHAR2(30):= ‘welcome1’; v_status BOOLEAN; BEGIN v_status := fnd_user_pkg.ChangePassword ( username… Read More »

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 »