Category: Oracle General Ledger

Category for Oracle General Ledger , setup, functional and technical solutions

Query to get all records from GL_CODE_COMBINATIONS which are updated after last_run_date derived

Query to get all records from GL_CODE_COMBINATIONS which are updated after last_run_date derived SELECT GCC.CODE_COMBINATION_ID ,GCC.ALTERNATE_CODE_COMBINATION_ID ,GCC.CHART_OF_ACCOUNTS_ID ,GCC.DETAIL_POSTING_ALLOWED_FLAG ,GCC.DETAIL_BUDGETING_ALLOWED_FLAG ,GCC.ACCOUNT_TYPE ,GCC.ENABLED_FLAG ,GCC.SUMMARY_FLAG ,GCC.SEGMENT1 ,GCC.SEGMENT2 ,GCC.SEGMENT3 ,GCC.SEGMENT4 ,GCC.SEGMENT5 ,GCC.SEGMENT6 ,GCC.SEGMENT7 ,GCC.SEGMENT8 ,GCC.SEGMENT9 ,GCC.SEGMENT10 ,GCC.SEGMENT11 ,GCC.SEGMENT12 ,GCC.START_DATE_ACTIVE ,GCC.END_DATE_ACTIVE ,GCC.JGZZ_RECON_FLAG ,GCC.PRESERVE_FLAG ,GCC.DESCRIPTION ,GCC.TEMPLATE_ID

Continue reading

oracle apps General Ledger Query to delete the budget lines from Budget Interface Table in R12

  General Ledger SELECT Query to get the details for the Budget Name and Budget Entity Name SELECT GBI.* FROM GL_BUDGET_INTERFACE GBI WHERE 1=1 AND GBI.LEDGER_ID = <PROVIDE_LEDGER_ID> AND GBI.BUDGET_NAME= ‘<PROVIDE_BUDGET_NAME>’ AND GBI.BUDGET_ENTITY_NAME= ‘<PROVIDE_BUDGET_ENTITY_NAME>’ AND GBI.FISCAL_YEAR = ‘<PROVIDE_FISCAL_YEAR>’ –2016  

Continue reading

oracle apps General Ledger SQL to get the complete workflow Item and process activities for a particular Journal Batch

General Ledger SQL Query  to get Journal Batch workflow Item and process activities: SELECT WF_PROCESS.PROCESS_NAME, WF_IT_ACT_STATUS.* FROM WF_ITEM_ACTIVITY_STATUSES WF_IT_ACT_STATUS, WF_PROCESS_ACTIVITIES WF_PROCESS WHERE 1=1 AND ITEM_KEY LIKE ‘%<PROVIDE_JE_BATCH_ID>%’ AND WF_IT_ACT_STATUS.ITEM_TYPE = ‘GLBATCH’ AND WF_PROCESS.INSTANCE_ID = WF_IT_ACT_STATUS.PROCESS_ACTIVITY ORDER BY BEGIN_DATE, END_DATE Link to this

Continue reading
Copy Protected by Chetan's WP-Copyprotect.