Office Activation

 

How to convert MP3 to Text

 

Download

https://github.com/BtbN/FFmpeg-Builds/releases

 

Convert to pure MP3 first & then Split (chatgpt)

If the original file is wrapped in a different container or is partially corrupt, re-export it:

bash

কপি করুনএডিট করুন

ffmpeg -i input.mp3 -vn -ar 44100 -ac 2 -b:a 192k clean_input.mp3

Then split the cleaned file:

bash

কপি করুনএডিট করুন

ffmpeg -i clean_input.mp3 -f segment -segment_time 300 -c copy output_%03d.mp3

 

N.B.: 300 = 5 minutes

Convert MP3 to Text

https://turboscribe.ai/dashboard

Use the following queries to check the status of accounting periods. Be sure to substitute the relevant start and end dates as needed.

 SELECT FA.APPLICATION_NAME, SOB.NAME LEDGER, GPS.PERIOD_NAME,

       GPS.PERIOD_NUM, GPS.START_DATE, GPS.END_DATE, GPS.CLOSING_STATUS,

       DECODE(CLOSING_STATUS,'O','Open', 'C','Closed', 'F','Future', 'N','Never', CLOSING_STATUS) GL_STATUS

  FROM GL_PERIOD_STATUSES GPS,

       GL_SETS_OF_BOOKS SOB,

       FND_APPLICATION_VL FA

 WHERE 1=1 

   --AND FA.APPLICATION_NAME = 'General Ledger'

   AND SOB.NAME LIKE 'Vision Operations (USA)%'

   AND SOB.SET_OF_BOOKS_ID=GPS.SET_OF_BOOKS_ID

   AND FA.APPLICATION_ID = GPS.APPLICATION_ID

   --AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'

   --AND GPS.CLOSING_STATUS = 'O'

   AND PERIOD_NAME ='Jun-25'

   

How to find GL Code Combination ID and Description

Find GL Code Combination ID & Description

SELECT    gcc.segment1

       || '.'

       || gcc.segment2

       || '.'

       || gcc.segment3

       || '.'

       || gcc.segment4

       || '.'

       || gcc.segment5      ACCOUNT_CODE,

          a1.description

       || '-'

       || a2.description

       || '-'

       || a3.description

       || '-'

       || a4.description

       || '-'

       || a5.description    ACCOUNT_DECS

  FROM fnd_flex_values_vl    A1,

       fnd_flex_values_vl    A2,

       fnd_flex_values_vl    A3,

       fnd_flex_values_vl    A4,

       fnd_flex_values_vl    A5,

       gl_code_combinations  gcc

 WHERE     a1.flex_value = gcc.segment1

       AND a1.flex_value_set_id IN

               (SELECT FLEX_VALUE_SET_ID

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT1')

       AND a2.flex_value = gcc.segment2

       AND a2.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT2')

       AND a3.flex_value = gcc.segment3

       AND a3.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT3')

       AND a4.flex_value = gcc.segment4

       AND a4.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT4')

       AND a5.flex_value = gcc.segment5

       AND a5.flex_value_set_id IN

               (SELECT flex_value_set_id

                  FROM fnd_id_flex_segments

                 WHERE     application_id = 101

                       AND id_flex_code = 'GL#'

                       AND enabled_flag = 'Y'

                       AND application_column_name = 'SEGMENT5')

PLSQL query to find Open/Close status of Periods - Oracle EBS R12

 /* Formatted on 5/6/2025 9:55:34 AM (QP5 v5.381) */

select * from GL_PERIOD_STATUSES

select * from GL_PERIOD_STATUSES_V

SELECT * FROM GL_LEDGERS where name ='Vision Operations (USA)'

SELECT NAME,

       LEDGER_ID,

       period_name,

       APPLICATION_NAME,

       status

  FROM (SELECT ff.NAME                  NAME,

               kk.LEDGER_ID,

               kk.PERIOD_NAME,

               jj.APPLICATION_NAME,

               period_year,

               start_date, end_date,

               DECODE (kk.CLOSING_STATUS,

                       'O', 'Open',

                       'C', 'Closed',

                       'F', 'Future',

                       'N', 'Never')    STATUS

          FROM GL_PERIOD_STATUSES_V kk, fnd_application_vl jj, gl_ledgers ff

         WHERE     1 = 1

               AND jj.APPLICATION_ID = kk.APPLICATION_ID

               AND ff.LEDGER_ID = kk.LEDGER_ID

               AND kk.CLOSING_STATUS != 'N')

               where name ='Vision Operations (USA)'

               --and period_year = 2024

               and APPLICATION_NAME='General Ledger'

UNION

(SELECT 

        fbc.BOOK_TYPE_CODE                                         NAME,

        fbc.set_of_books_id                                        LEDGER_ID,

        fdp.period_name,

        'Assets'                                                   APPLICATION_NAME,

        DECODE (fdp.period_close_date, NULL, 'Open', 'Closed')     status

   FROM fa_book_controls fbc, fa_deprn_periods fdp

  WHERE     fbc.book_type_code = fdp.book_type_code

        AND fbc.DATE_INEFFECTIVE IS NULL)