There is no global variable in Java. However, we have a static keyword that we can use to define a global variable by doing something like the below:

public class A {
public static String var1 = "Oraask";
public static int var2 = 37;
}

A.var1;

A.var2;

But be careful because if this class gets unloaded, you will end up with an undefined null error that is difficult to catch.

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

Firstly, It’s ok to use dates in varchar attributes; that’s why Oracle makes it varchar to accept multiple data types in the form of character, and later on, we can deal with it by converting that to date or number.

The second point is the VO; try to look into this VO instead of the ones you were looking at

oracle.apps.pos.supplier.server.BCAttrVO oracle.apps.pos.supplier.server.BCAttrEO

This one is updateable VO.

Finally, you can add one of the general attributes that exist on the POS_BUS_CLASS_ATTR table
by extending above VO and making this field updatable.

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.

Clarification: This message refer to failed authentication that’s because of the credentials for one or more connections being used by your integration.

Resolution: get the list of connections being used by your integration then go to them and make sure of the username and password that they are correct by doing validate and test.