Search Results to_epoch

Overview

DBMS_DBFS_SFS is an Oracle-supplied PL/SQL package owned by the SYS schema that implements the SecureFile System (SFS) provider for the Database File System (DBFS) framework. Within Oracle E-Business Suite 12.1.1 and 12.2.2, this package does not execute application business logic directly; rather, it supplies the storage-layer primitives that allow EBS components to treat database-resident SecureFile LOBs as a hierarchical, POSIX-like file system. The package is documented in ETRM with the API classification OTHER and is reported as VALID in both 12.1.1 and 12.2.2 environments.

DBMS_DBFS_SFS is a foundational dependency of several other SYS packages, including DBMS_DBFS_HS, DBMS_DBFS_SFS_ADMIN, and DBMS_FUSE. It also references the DBFS content type definitions DBMS_DBFS_CONTENT_CONTEXT_T, DBMS_DBFS_CONTENT_LIST_ITEMS_T, DBMS_DBFS_CONTENT_PROPERTIES_T, and DBMS_DBFS_CONTENT_RAW_T, which confirms its role as the bridge between generic DBFS content semantics and physical SecureFile storage.

Key Procedures and Functions

ETRM documents approximately 110 procedures and functions in this package. The most significant groups are:

• Store and volume administration: GETSTOREID, GETVERSION, GETFEATURES, GETPATHBYSTOREID, and SPACEUSAGE / SPACEUSAGEFULL provide store identity, version, capability, path resolution, and capacity reporting.
• Volume and object enumeration: LISTVOLUMES, LISTFILESYSTEMS, LISTTABLES, and LISTSNAPSHOTS enumerate the store hierarchy, the file systems mapped onto it, the underlying tables, and available snapshots.
• File system mutation: CREATEFILE, CREATEDIRECTORY, CREATELINK, CREATEREFERENCE, and DELETEFILE perform the core object-creation and removal operations used by storefronts.
• Attribute and time utilities: CREATEGETATTRVIEW, RECREATEGETATTRVIEW, and DROPGETATTRVIEW manage the attribute access views required by the SFS provider, while TO_EPOCH and GET_EPOCH convert between database timestamps and epoch representations used by DBFS.

No parameter signatures are reproduced here; the documented interface should be treated exclusively as the procedure and function names above.

Tables Accessed

The ETRM metadata does not list any application tables accessed through APPS synonyms, which is consistent with the object's role as a kernel-level provider. DBMS_DBFS_SFS operates against the SFS store tables created by DBMS_DBFS_SFS_ADMIN, together with the DBFS content tables that track store paths, properties, and items. Attribute access views created by CREATEGETATTRVIEW expose these underlying rows in a queryable form. The absence of APPS-synonym dependencies confirms that custom EBS code should not assume a direct relational contract with this package.

Usage Notes

DBMS_DBFS_SFS is normally invoked indirectly. In EBS 12.1.1 and 12.2.2, Database File System usage is associated with file-system storage for artifacts such as attachments and report output where DBFS has been configured. It is referenced by three other packages, and DBMS_DBFS_HS, DBMS_DBFS_SFS_ADMIN, and DBMS_FUSE all depend on it.

Direct calls from forms, concurrent programs, or custom PL/SQL are generally not recommended. Where an EBS deployment has registered an SFS store, the package may be exercised by administrative scripts or DBMS_DBFS_SFS_ADMIN routines rather than by application code. Any direct use requires the executing schema to hold EXECUTE privilege, since the package is granted to PUBLIC but remains owned by SYS. Because the package is VALID and part of the core SYS dependency chain, its compilation state should be monitored alongside other DBFS packages during EBS patching and cloning.