Pages

▼
Showing posts with label #Oracle #EBS. Show all posts
Showing posts with label #Oracle #EBS. Show all posts
Tuesday, 20 January 2026

Oracle PLSQL - Need to Reassign the PR from one user to another user

›
  DECLARE     x_errbuf           VARCHAR2(2000);     x_retcode          VARCHAR2(2000);     p_curnt_apprvr     VARCHAR2(200) := 'RYANH...
Thursday, 6 November 2025

Oracle EBS - XDO Loader Script to Download & Upload BI Publisher Data Template and XML Template

›
  --Download XML file -- java oracle.apps.xdo.oa.util. XDOLoader \ DOWNLOAD \ -DB_USERNAME apps \ -DB_PASSWORD apps \ -JDBC_CONNECTION  db.t...
Wednesday, 11 September 2024

Oracle EBS - How to Enable Debug log on user's session

›
    1)   As System Administrator responsibility        Navigation: Profile -> System            a) In the FIND window,                   ...
Tuesday, 19 March 2024

Oracle EBS - R12 - Inventory - Oracle API to Update Lot Origin Date of Item Lot Numbers

›
 -- R12 - INV - Sample Script to Update Lot Number Lot Origin Date usinginv_lot_api_pub.update_inv_lot DECLARE     l_object_id      NUMBER; ...
Monday, 7 August 2023

Oracle EBS - SQL Query to find Cloned Date, Version Details, URL of Oracle Applications

›
Subject:  SQL Query to find Cloned Date, Version Details, URL of Oracle Applications Query to get Instance Version details SELECT  product, ...
Wednesday, 4 January 2023

Oracle EBS - Not able to create Payment in Past Date

›
  Issue:   While Creating Payment and Enter Payment Date for Past Open Period getting below error message Error: APP-SQLAP-10026: The P...
Wednesday, 10 August 2022

Oracle EBS: How to Create Request Group and Assign Request Group to Responsibility

›
    Step1: Create a Request Group. Navigate: System Administrator Responsibility > Security > Responsibility > Request Group...
Tuesday, 9 August 2022

Oracle EBS - Order Management Sales Order Line Need to Split using Oracle API

›
set serveroutput on; DECLARE  l_header_rec OE_ORDER_PUB.Header_Rec_Type;  l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;  l_action_request_tbl OE_OR...