Tech Touch Online

Friday, May 30, 2025

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

Wednesday, May 28, 2025

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'

Monday, May 19, 2025

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')

Monday, May 5, 2025

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)

Monday, October 16, 2023

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)

Friday, October 6, 2023

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

Thursday, February 9, 2023

Bitlocker Keys solution for accidental lock of drive

1. login in myaccount.microsoft.com

like abc.d@standard-group.com

2. go to Devices option

3. Click the Downarrow option

4. View Bitlocker Keys option will be visible after a while

5. Click View Bitlocker Keys

6. Click Show Recovery Key

7. Copy the Recovery Key

8. Click the drive to recover & paste Recovery Key into Recovery Key option

View https://www.youtube.com/watch?v=J1UMvVuyQAU