Blog / Category
Oracle EBS Blog
58 articles in this category
Fixing FRM-92101 Error After Re-Enabling a Custom Concurrent Program in Oracle EBS
Introduction During a recent Oracle E-Business Suite (EBS) maintenance activity, we needed to re-enable a custom concurrent program that had been disabled for a…
ECC Menu Configuration Fix for Data Set Authorization Errors
Introduction: While accessing Oracle E-Business Suite Embedded Command Center (ECC), users may encounter the error “400 Bad Request: Current user not authorized…
Resolving JVM Startup Failures in Tomcat: Invalid Heap Size and Unsupported Class Version Errors
Introduction: Java-based middleware components such as Apache Tomcat and ORDS are highly dependent on correct JVM configuration. Misalignment between Java versi…
Oracle ERP Cloud Period Close Procedures & Runbook Considerations
Introduction/ Issue: Oracle ERP Cloud customers have a need to close their books every period, quarter and/or year. This paper provides guidance on the period-e…
Delete the concurrent programs
Delete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concur…
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_statu…
Ship Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_vers…
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migrati…
Excessive MMON Trace Files Generation in DB Trace File Location
DESCRIPTION: The size MMON trace files gets increased which is causing trace file Location Overflow. CAUSE: Trace files generation with message “AUTO SGA: kmgs_…
Troubleshooting Support Connectivity Issues in OEM 13.5
Troubleshooting My Oracle Support Connectivity Issues in Oracle Enterprise Manager (13.5) Introduction: Greetings! This blog is all about my oracle support conn…
R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Oracle EBS – Archive the file with Script
By using the bleow script, we can archive the file from specific folder to back up folder in the server location. # =====================================…
SERVICE CONTRACT – Oracle External Table
This is the sample script to create the oracle external table to access the data from the file. prompt prompt creating TABLE XX_SC_EXT ….. CREATE TABLE “XX”.”XX…
Deploying plugin on OEM
Deploying plugin on Oracle Enterprise Manager (OEM 13c) Introduction Greetings! This blog is all about deploying Oracle E-business suite (EBS) plugins on OEM an…
Split Sales Order Line using script.
Shipment is happening from third party system and if partial shipment is happening then sales order line should be split based on balance quantity and with ship…
Integrated SOA Gateway – A Guide
Integrated SOA Gateway – A Guide Introduction to Integrated SOA Gateway Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service…
APPS_DDL package issues in fs_clone
APPS_DDL package issues in fs_clone This blog is intended for DBA’s who have issues in completing fs_clone. We applied a critical patch for one of the client an…
AP Invoice To GL Link Query with additional attribute values
This query to Trace an AP Invoice to the GL. There is an Invoice in AP which is correctly Validated, Accounted, Approved etc. This will useful To find the GL He…
AP Bank details query with additional attributes values
The supplier (or External) bank account information are stored in the table called ce_bank_accounts. The bank and bank branches information are stored in CE_BAN…
Workflow Script Deassign user from role
Oracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, an…
GL Flexi ield Query with additional details
GL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. Thi…
AP PO Vendor Creation interface with additional attributes
Payables modules are used to create supplier related information in oracle. In this module we can create supplier invoice bank etc will be maintained. This scri…
Inventory Lot Creation Interface
Inventory module used to create items in oracle. This module will link with AP, PO, GL modules. In inventory we have lot concepts where we will create lots , so…
Query to find Tax Recoverable
Query to find Tax Recoverable SELECT NVL (attribute_value, ‘N’) FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid WHERE 1 = 1 AND jih.template_hdr_id = j…
Query to Find HSN Code
Query to Find HSN Code SELECT REPORTING_CODE FROM jai_reporting_codes jrc, jai_reporting_types jrt WHERE jrc.reporting_type_id = jrt.reporting_type_id AND jrt.r…
Call Auto invoice for Order number Range
Sample Call Auto invoice for Order number Range PROCEDURE xx_bdg_ar_autoinvoice ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS l_responsibili…
Ship Confirm
Sample script for Ship confirm PROCEDURE xx_bdg_ship_confirm ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_m…
Pick Release
Sample script for Pick Release PROCEDURE xx_bdg_sin_delv_picrelease ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (…
Book Sales Order
Sample script to book the sales Order PROCEDURE xx_book_bdg_so ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS v_api_version_number NUMBER :=…
Reserve Lot number for the order
Sample script for Reserve Lot number for the order PROCEDURE xx_bdg_Reserve_attribs ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) IS v_api_vers…
Autoinvoice Program Error correction Script on Duplicate Invoice Number
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number…
Autoinvoice Program Error correction Script on Offset Account and Revenue Account
please_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from c…
Autoinvoice Program Error correction Script on Rule Start date
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number…
Oracle GL Transaction Register Report
Header : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post :…
Form Personalization on Purchasing Receipt Standard Form
Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Descriptio…
How to Enable DFF in Bank Account Transfer Page
Header : How to Enable DFF in Bank Account Transfer Page Usage of Heading : Useful in the cash management module in banking page Description of post : DFF means…
Mobile First strategy with Oracle CX Mobile App
Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals.…
EBS R12.2 ADOP phases and parameters
EBS R12.2 ADOP phases and parameters 1) Prepare – Starts a new patching cycle. Syntax: adop phase=prepare 2) Apply – Used to apply a patch to the patch file sys…
To recover Concurrent Manager – Concurrent Manager recovery Wizard – EBS 11i/R12
Concurrent Manager Recovery Wizard – Oracle Applications Manager Troubleshooting and Diagnostics Follow the below steps to use the Concurrent Manager Recovery W…
How To Clear BNE Cache in EBS 11i/R12
GOAL: To clear BNE cache in EBS environment Solution: To Clear BNE cache: A. Releases prior to 12.2.7 Using System Administrator responsibility: Login to the ap…
Receivables Party Site details Extract script in R12
receivables_party_site_details_along_with_location This script useful to extract all the AR party site details with location and account details as well as addr…
Purchase Order meta data details extract in R12
meta_data_po_deatils_on_specific_dates This script is useful to get all the details of purchase order with requisition details item details item category along…
AP invoice Post Register Details Extract Query in R12
ap_invoice_post_register_details_of_specific_org This script is useful to provide details of AP invoice post register details along with PO number check number…
API Delete Orphan Events in AR invoices not in XLA in R12
api_events api_events This is useful script while doing period close on every month basis. Some time there will be no relation will generate between AR invoice…
Payables VMD Data Extract in R12
vmdvendormetadata_extract_query This reusable component very useful in pulling payables vendor metadata that will have all the the information vendor payments b…
AR invoice Number change Script for Brazil Country in R12
invoice-numberchange-script-for-brazil This is useful script that will help for Brazil Country. This script will find the invoice number of Brazil localization…
Make single column excel output to excel row output in XML Publisher
Requirement Single Excel column output with multiple data separated by comma need to make row-wise data, eg Name Marks Peter 50,70,30 Need to change with this N…
How to Delete AP Invoice Data from the Oracle Apps EBS R12.
API “AP_AI_TABLE_HANDLER_PKG.DELETE_ROW” can be used to delete AP Invoice Data. This Script can be used when invoice accounting is not done. DECLARE CURS…
To display all data for a particular block while opening the EBS form.
Overview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open y…
Script to collect all the required information for understanding the Concurrent Processing workload on a system
REM HEADER REM $Header: cp_analyzer.sql v1.01 MCOSTA $ REM REM MODIFICATION LOG: REM REM MCOSTA REM REM Consolidated script to diagnose the current status and f…
Prepare phase failed:[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.
Update Database Tier to Latest Code Call env from APPS NOde Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admi…
How to apply Middleware 11.1.1.9 webtier patches in 12.2
adop patch process cycle steps: 1) Run FSCLONE 2) PREPARE 3) APPLY 4) FINALIZE 5) CUTOVER 6) CLEANUP Before start to apply the patches we have to run fsclone to…
How to monitor adop patching cycle from backend
As a new feature of EBS 12.2.5 , we have adopmon(adop monitor, Online Patching Monitoring utility) utility for monitoring the online patching cycles. It provide…
Prepare phase failed With Error “ETCC Not Run In The Database Node”
We might some time get into below issue after clone or after installing AD and TXK patches. Error: ETCC not run in the database node [Node…
Script To Find the Versions of all the Oracle E Business Suite R12.2 technology stack components utility
On Application Tier: Source the Applications environment file as the owner of the application tier file system and run: $ADPERLPRG $FND_TOP…
How to create Oracle EBS (Applications User ) with only read privilege
Introduction Steps to create Oracle EBS Application user with read only priviliege Posted by Sakthi Sethu Perumal a.Connect to the Oracle EBS b.Select system Ad…
Oracle Integration Cloud :- An Introduction about OIC .
oracle-integration-cloud-an-introduction Oracle Integration Cloud Connects and integrates various applications like SaasS with on premise applicat…
Oracle Apps(EBS) – AR Receipt Register Query with Bank statement Header and Line Details
Below query is useful when you required Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELE…