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)

how to increase session timeout in oracle apps r12

 how to increase session timeout in Oracle apps r12

Find Profile name ICX:Session Timeout

Default : None

Recommendation : 30 (minutes)

pick release process could not allocate of item for order as there was insufficient quantity available or inventory allocations have failed, and the line has been back ordered.

 Question: pick release process could not allocate of item  for order as there was insufficient quantity available or inventory allocations have failed, and the line has been back ordered.
Oracle EBS Apps R12

Answer: 

Please confirm whether the inventory period is currently accessible for the specified dates of the order. If it is not, kindly proceed to initiate the opening of the inventory period and conduct a thorough examination.

SELECT SEVERITY, STATUS, A.*

FROM WSH_EXCEPTIONS A

WHERE BATCH_ID = 6393351