Find below the query to find the free space of a tablespace:

SELECT DFQ.TABLESPACE_NAME "Tablespace Name"
,DFQ.TOTALSPACE "Total Size MB"
, (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) "Free Space MB"
,ROUND (100 * ( (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) / DFQ.TOTALSPACE)) || '%' "Free Space %"
FROM (SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / 1048576) TOTALSPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) DFQ
,(SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024)) TOTALUSEDSPACE
FROM DBA_SEGMENTS
GROUP BY TABLESPACE_NAME) DSQ
WHERE DFQ.TABLESPACE_NAME = DSQ.TABLESPACE_NAME(+);

Also, you can refer to this article to find a handful of detail about the tablespace:

Check Tablespace Usage in Oracle

Unfortunately, you can’t achieve this kind of requirement without create a distribution set as per Oracle note Doc ID 1954890.1

Also currently there is no an API or interface table available to create a new distribution set from the backend. The only way is to create a temporary distribution set and delete it’s account distributions once you have done from your task.

If you go with creating distribution set you have to pass either distribution_set_id or distribution_set_name while populating “ap_invoice_lines_interface” interface table.

check: Create AP Invoice using AP open interface in oracle apps R12 for your reference.

FNDLOAD to download responsibility from the source instance:

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt FND_RESPONSIBILITY RESP_KEY=”<RESPONSIBILITY_KEY>”

FNDLOAD to upload responsibility to destination instance:

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt

Notes:

• <LDT_FILE_NAME>.ldt : LDT file generated from FNDLOAD command
• <RESPONSIBILITY_KEY>: Responsibility Key name

Note: Don’t forget to move the LDT file after downloaded it from source instance to destination instance.

What do you mean by Customized DFF?

If you want to list all custom context that is created on a specific DFF you can run this query to get the result:

SELECT FAPT.APPLICATION_NAME,
FDFC.DESCRIPTIVE_FLEXFIELD_NAME,
FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE,
FDFC.ENABLED_FLAG,
FDFC.GLOBAL_FLAG,
FDFC.DESCRIPTION,
FDFC.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM FND_DESCR_FLEX_CONTEXTS_VL FDFC, FND_USER FU, FND_APPLICATION_TL FAPT
WHERE FAPT.APPLICATION_NAME = :P_APPLICATION_NAME
AND FDFC.DESCRIPTIVE_FLEXFIELD_NAME LIKE :P_DFF_NAME
AND FDFC.CREATED_BY = FU.USER_ID
AND FDFC.APPLICATION_ID = FAPT.APPLICATION_ID
AND FAPT.LANGUAGE = 'US'
AND ( FU.USER_NAME NOT LIKE '%ORACLE%'
AND FU.USER_NAME NOT LIKE '%AUTOINSTALL%'
AND FU.USER_NAME NOT LIKE '%INITIAL SETUP%');

P_APPLICATION_NAME : Is your application name

P_DFF_NAME : Is your Descriptive flexfield name. It’s not the title which is available on DFF screen, but you can find the column name “DESCRIPTIVE_FLEXFIELD_NAME” from help -> diagnostic -> examine.

Note: We have excluded three users because Oracle seeded DFF contexts are created by these users above, thus, we can get only the custom ones.