Home / HomePage – TimeLine Layout

HomePage – TimeLine Layout




Query To find the details of the Accounting Flexfield structure

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             WHEN fvs.validation_type = ‘F’ THEN fvt.application_table_name             ELSE ‘Not Applicable’           END )          validation_table_name  FROM   gl_ledgers gls,         fnd_id_flex_segments idfs,         fnd_flex_value_sets fvs,         fnd_flex_validation_tables fvt  WHERE  gls.chart_of_accounts_id (+) = idfs.id_flex_num         AND fvs.flex_value_set_id = idfs.flex_value_set_id         AND gls.ledger_id = &ledgerid  …

Read More »

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

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 default R12 installation Step 1. Run the concurrent program “Workflow …

Read More »

Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard   Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database and Standby Database Should be same. (But 11g Onwards …

Read More »