Automatic Modifier is Not Applying to Service Contract
automatic-modifier-is-not-applying-to-service-contract
Read MoreExplore/Explore BOM components for a config item
PROCEDURE xxbom_explode_bom_for_abc(i_item_id IN NUMBER, i_organization_id number, i_num_so_line_id number) IS g_chr_excp_msg VARCHAR2(4000); g_chr_log_msg VARCHAR2(4000); g_dte_sysdate DATE := SYSDATE; g_num_elig_comp_exist NUMBER := 0; g_num_item_inc NUMBER := 0; v_num_boe_open_qty NUMBER; v_num_bill_sequence_id NUMBER; v_rec_inc…
Read MoreTransfer file from PL SQL to third party system using java concurrent program
Transfer the CLOB variable to third party system using https protocol and java concurrent program. package xxpo.ebs; import java.io.IOException; import oracle.apps.fnd.cp.request.CpContext; import oracle.apps.fnd.cp.request.JavaConcurrentProgram; import oracle.apps.fnd.cp.request.LogFile; import oracle.apps.fnd.cp.request.ReqCompletion; import oracle.apps.fnd.util.NameValueType; import…
Read MoreSales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreOacore & Forms Servers Are Stuck at ADMIN State in EBS R12.2.5
Not able to bring up oacore and forms managed servers after clone. These managed servers are stuck at ADMIN state while trying to start the services. CAUSE: Credentials Missing in…
Read Moreadcfgclone.pl error :RC-50014: Fatal: Execution of AutoConfig was failed in R12
While R12.2.5 cloning autoconfig failed with the below error AutoConfig is exiting with status 1 ERROR: RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyApplTop END: Executed runAutoConfig… ERROR:…
Read MoreSYS and SYSTEM Password no longer needed in E-Business Suite
Introduction: R12.2 is being modernized with many new functionalities and changes in architecture. We, as a DBA, rely on SYS and SYSTEM passwords for any activities like patching/cloning and upgrading.…
Read MoreTriage E-business Suite Performance tuning
Performance issues in the application are the most common thing in every organization, almost in every product. Oracle performance issues are prevalent in E-business suite product. But understanding issues from…
Read More