Month: October 2017

October 10, 2017 Query To find the details of the Accounting Flexfield structure

AppsDBA ScriptsConfigurations-GLScripts

SELECT gls.name, idfs.id_flex_num chart_of_accounts_id, idfs.segment_num, idfs.flex_value_set_id, fvs.flex_value_set_name, idfs.application_id, idfs.id_flex_code, idfs.application_column_name, idfs.segment_name, fvs.security_enabled_flag, ( CASE WHEN fvs.validation_type = ‘F’ THEN ‘Table’ WHEN fvs.validation_type = ‘I’ THEN ‘Independent’ WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’ WHEN fvs.validation_type = ‘N’ THEN ‘None’ WHEN fvs.validation_type = ‘P’ THEN ‘Pair’ WHEN fvs.validation_type = ‘U’ THEN ‘Special’ ELSE ‘Unknown Type’ END ) validation_type, ( CASE …

October 10, 2017 Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN) (ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT SOLUTION This Issue exists in…

October 6, 2017 Data Guard Vs SAN To SAN Replication

Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Data Guard Vs SAN to SAN Replication Oracle Data Guard SAN-to-SAN Implementation Cost Low High Database Aware Yes No…

October 6, 2017 Comparison Between Oracle GoldenGate and DataGuard

Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Comparison Between Oracle GoldenGate and DataGuard Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database…