Blog / Category
Oracle Apps R12
28 articles in this category
Integrating Oracle EBS with Oracle Apex
Introduction / Issue Organizations often develop custom applications in Oracle APEX to extend the functionality of Oracle E-Business Suite (EBS). However, one c…
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…
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…
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…
Order Creation Using API
Script to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create Sales Order ) Script PROCEDURE xx_bdg_so_interface ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_or…
Invalid Column Type error in OAF
This error occurred in OAF when I added the new export button to table layout region. For this error just right click on our VO (View Object) and select Edit. T…
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.…
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…
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 disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form Oracle Apps R12.
Overview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOC…
Disable Descriptive Flex field (DFF) at form level through CUSTOM.pll
Sometimes, We have a requirement to disable the DFF at form level. Either have to do disable the DFF as well or Read-Only of the attribute of the DFF. So, First…
Find Concurrent Manager status from Backend
select decode(CONCURRENT_QUEUE_NAME, ‘FNDICM’,’Internal Manager’, ‘FNDCRM’,’Conflict Resolution Manager’, ‘AMSDMIN’,’Marketing Data Mining Manager’, ‘C_AQCT_SVC…
To check scheduled concurrent request in R12
SELECT cr.request_id, DECODE (cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’ || cr.description, cp.user_concurrent_program_name ) NAME, argument_t…
ADOP – Applications DBA Online Patching Tool
ADOP: Oracle E-Business R12.2 introduced new patching mechanism that allow the application of patches while your environment is up and running which is called a…
ORA-01804: failure to initialize timezone information – issue while running AutoConfig during Upgrade Oracle Apps (EBS) to 12.2 ?
issue “ORA-01804: failure to initialize timezone information” in Post Database upgrade 11.2.0.4 step while running AutoConfig. 1. Running Autoconfig on Database…
RC-30007 :Error while running adpreclone on DB Tier during 12.1.3 cloning
RC-30007: Stage area /ebsdb1/ebstest/db/tech_st/11.1.0/appsutil/clone/dbts [oracle@ebstemp ~]$ cd /ebsdb1/ebstest/db/tech_st/11.1.0/appsutil/clone [oracle@ebste…
Error while starting the application after cloning 12.1.3:-
Check the application status:- [applmgr@ebstemp scripts]$./adoacorectl.sh status Check the log file From the log file below error came HTTP listener is not resp…
R12.2 Upgrade: Rapidwiz Prerequisite Check Fails With Message: DB Version Check Has Failed. Not able to check the Database version.
Issue: Oracle E-business suite R12.2 Upgrade File System Pre-install check Failed for : ——————-ADX Database Utility Finished————— DB Version Check has failed. N…
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora while running autoconfig on appstire
Updating s_tnsmode to ‘generateTNS’ UpdateContext exited with status: 0 AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.…
WLS Domain Validation failed during EBS 12.2 upgrade
In this particular case, one of the post installation check “WLS Domain Validation” failed as shown below . WLS_Check_Failed Click on Red mark button ( ! ) to c…
Customer PO Conversion
Customer PO Conversion Description This blog is used to create a Customer PO conversion. This…