Create Chart of Accounts Structure in Fusion
Key Flexfield Structures A key flexfield structure arranges the segments of a key so that you can reuse a single key flexfield in multiple combinations of the same segments or a subset of those…
Read MoreORA-38760: This database instance failed to turn on flashback database
ERROR: ORA-38760: This database instance failed to turn on flashback database CAUSE: When we are upgrading from 12c to 19c we faced below error, SQL> alter database open; alter database…
Read MoreScript to Schedule concurrent program from back end
Sample Script to Schedule concurrent program from back end Procedure xxTTK_schedule_prog is l_conc_id VARCHAR2(500); l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_conc_id1 number; l_language VARCHAR2(50); l_territory VARCHAR2(50); l_option_return BOOLEAN;…
Read MoreQuery to find GL Period status
Query to find GL Period status SELECT * FROM gl_period_statuses ps, gl_sets_of_books sob, fnd_application_vl fnd WHERE 1=1 and ps.application_id = 101 AND sob.set_of_books_id = (SELECT set_of_books_id FROM org_organization_definitions WHERE ORGANIZATION_CODE…
Read MoreQuery to find Sales Person
Query to find Sales Person SELECT hcsu.primary_salesrep_id FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE hca.cust_account_id = 940301 AND hca.cust_account_id = hcas.cust_account_id AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id AND hcsu.site_use_code = ‘BILL_TO’…
Read More10 лучших вариантов размещения в Осло, Норвегия
The landlord has been waiting for us in the house. When we arrived, she was very enthusiastic about introducing us to the interior of the house. The facilities https://rehabliving.net/ inside…
Read MoreHow to Change Weblogic Password in R12.2
1. Shutdown the Application Services using $ADMIN_SCRIPTS_HOME/adstpall.sh 2. Start the admin server on Primary node using $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start 3. Run the below command to create new password perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword…
Read MoreHow to Resolve Gaps in Data Guard Apply Using Incremental RMAN Backup
Step-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> select…
Read MoreWeblogic Error : The Store Record X Could Not Be Found
ERROR weblogic.store.PersistentStoreFatalException: [Store:280029]The store record 4 could not be found. Solution The issue can be caused by the corruption of the database, by .lok or .DAT files associated with the…
Read MoreQuery to find Third Party Registration
Query to find Third Party Registration SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num INTO lv_gst_num FROM jai_party_regs a, jai_party_reg_lines b WHERE 1 = 1 AND a.party_reg_id = b.party_reg_id AND a.party_type_code =…
Read More