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 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 More1.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(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 MoreAutoPatch – 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 MoreNot 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 MoreWhile 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 MoreIntroduction: 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 MorePerformance 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 MoreProblem: In the execution of autoconfig in the patch file system. we faced the following error. [SETUP PHASE] AutoConfig could not successfully execute the following scripts: Directory: /u01/apps/fs2/inst/apps/TEST_TESTEBSSYS01/admin/install adgendbc.sh INSTE8_SETUP…
Read More