ERROR: While running autoconfig i am getting below error, autoconfig failing – jtfictx.sh Solution: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘public’) PL/SQL procedure successfully completed. After executing this run autoconfig.
Read MoreError: Perl lib version v5.8.3 doesn’t match executable version v5.10.0 Solution: export ORACLE_HOME=/u01/oracle_home/db/tech_st/12.1.0.2 export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH check again perl version
Read MoreUseful query to get user id, responsibility id and application id in EBS. To know about User Id use below Query:- SQL> select user_id from fnd_user where user_name=’DOYEN’; To know…
Read MoreHow to enable or disable the event oracle.apps.icx.security.session.created 1. Login to E-Business and navigate to Workflow Administrator Web Application > Business Event.Search for oracle.apps.icx.security.session.created 2. Then click on clock…
Read MoreOverview This document talks about uploading Blob Content without Page Submit. This source code used in this document has been taken and modified from the following website, https://apexplained.wordpress.com/2016/09/12/chunked-multi-file-upload-with-ajax/. Technologies and…
Read MoreThis blog will describe about the AR period close process in Oracle Fusionar-period-close-process-and-open-close-accounting-periods-in-oracle-fusion
Read MoreNavigation: System Administrator ? Security ? Responsibility ? Define Enter the details Responsibility Name: IM CO AP Period End Application: Payables Responibility_key: IM_CO_AP_PERIOD_END Description: IM CO AP Period…
Read MoreThe below query gives the Vendor delivery performance details with po approval TAT and delivery TAT. SELECTpo_number,vendor_name,po_creation_date,po_approved_date,po_item_code,po_item_description,po_quantity,po_price,rate_type,exchange_rate_date,exchange_rate,po_line_amt,pr_to_po_creation_tat,po_creation_to_approval_tat,need_by_date,mrn_date,actual_material_receipt_date,mrn_tat,delivery_tatFROM(SELECT DISTINCTpoh.segment1 po_number,poh.creation_date po_creation_date,aps.vendor_name vendor_name,poh.approved_date po_approved_date,mtl.segment1 po_item_code,pol.po_line_id,pol.item_description po_item_description,pol.quantity po_quantity,pol.unit_price po_price,poh.rate_type,poh.rate_date exchange_rate_date,poh.rate exchange_rate,( pol.quantity *…
Read MoreOverview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process…
Read More