Oracle General Ledger

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 ,GCC.ALLOCATION_CREATE_FLAG FROM   GL_CODE_COMBINATIONS GCC WHERE  GCC.LAST_UPDATE_DATE > TO_DATE (G_DT_LAST_RUN_DATE, ‘DD-MM-YYYY HH24:MI:SS’) AND    GCC.ATTRIBUTE1 IS NULL […]

General Ledger ( GL) differences in 11i and R12

Please find below the details on the major changes in General Ledger ( GL) differences in 11i and R12   Ledger: The ledger is a major concept change  in Release 12 which  replaces the 11i concept of a set of books. the Ledger represents an accounting representation for one or more legal entities or for a business need such […]

General ledger interface table in oracle apps R12

The Oracle apps General Ledger Interface Table – GL_INTERFACE is the entry point for all journals accounting data which have been imported from other systems. The Journal Import Program validates the accounting data received in the GL_INTERFACE Table and imports the available data into Journal entries in the Oracle Apps GL Application. The Journal Import Program […]

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   Get the count for the Budget lines from the Budget Interface Table that need to […]

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

oracle apps SQL to get user supervisor details with user authorized limit

SQL Query in Oracle apps R12 to get user supervisor details with user authorized limit SELECT FU.USER_NAME                                                              ” USER ID” , PER_PEOPLE.FULL_NAME         […]

oracle apps GL Journal Header attributes query

Query to get the Journal Header Level Attributes for the Journal Batches Journal Posted Date is NOT NULL Period Name let you fetch records for a particular Period Source Name provides from which Source it is being received Category Name provides for which category Journal is being received SELECT GJH.JE_BATCH_ID , GJB.NAME ” JOURNAL BATCH […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.