Prerequisites Desktop with 1.5 GB RAM 1.Telnet and FTP access to apps and db server 2.Database connectivity details: 3.Apps username and password, 4.SID, 5.Host Name and port. 6.Exact version of OA Framework…
Read MoreSymptoms:- Concurrent program completed warning with “ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters” this reason. Solution:- SQL> alter session set “_fix_control”=’17376322:OFF’; or at system…
Read MoreHow to Enable Create/View Accounting from Toolbar on Receipt Summary Form for a Custom Responsibility Goal:- What are the steps to enable Create/View Accounting for a user-defined responsibility? Solution:- Please…
Read MoreWorkflow upload WFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <filepath>[<file_name.wft>] Example: WFLOAD apps/pwd@<connect_string> 0 Y UPLOAD $XXDOY_TOP/install/XXDOYAP.wft Different “Upload Modes” applicable to WFLOAD: UPGRADE Honors both protection and…
Read MoreConvert the Amount in to the Word using Function in Oracle Apps EBS R12. Function: CREATE OR REPLACE FUNCTION APPS.Get_amount_to_word(P_LC_AMOUNT IN NUMBER,P_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2 IS x_tot_amount1 NUMBER …
Read MoreFind the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. SELECT rct.trx_number…
Read MoreCSS Plan Creation Process for Migration Configuration: Inventory – Receiving Options Steps 1. Connect with Server wherein the CSS (ConfigSnapshot) is installed 2. Log-in on to ConfigSnapshot 3. Connect with…
Read MoreCSS Plan Creation Process for Migration Configuration: Inventory Organization Steps 1. Connect with Server wherein the CSS (ConfigSnapshot) is installed 2. Log-in on to ConfigSnapshot 3. Connect with the Source…
Read MoreCREATE OR REPLACE PROCEDURE XX_GL_EXTRACT_ENABLE_ACCOUNT AS v_set_id number; v_position_account_type number:=3; v_acc_flex_value_set varchar2(240):=’XXX_COA_ACCOUNT’; /**Pass the COA name/ flex_value_exeception EXCEPTION; v_upd_count number:=0; BEGIN SELECT …
Read MoreThis script can be used to remove junk characters from a string CREATE OR REPLACE FUNCTION xx_Replace_Junk_Chars_func (p_string IN VARCHAR2) RETURN VARCHAR2 IS lv_string VARCHAR2 (1000); …
Read More