top of page



Oracle Fusion FA System Controls Query

SELECT Company_Name,


FA_FAS430_XMLP_PKG.bookformula() Book,



FA_FAS430_XMLP_PKG.period1formula() Period1,

--FA_FAS430_XMLP_PKG.report_nameformula(FA_SYSTEM_CONTROLS.Company_Name, :ACCT_BAL_APROMPT, :ACCT_CC_APROMPT) Report_Name,

FA_FAS430_XMLP_PKG.report_nameformula(FA_SYSTEM_CONTROLS.Company_Name, &ACCT_BAL_APROMPT, &ACCT_CC_APROMPT) Report_Name,

-- FA_FAS430_XMLP_PKG.Accounting_Flex_Structure_p Accounting_Flex_Structure,

FA_FAS430_XMLP_PKG.Currency_Code_p Currency_Code,

FA_FAS430_XMLP_PKG.Period1_PC_p Period1_PC,

FA_FAS430_XMLP_PKG.Period1_PCD_p Period1_PCD,

FA_FAS430_XMLP_PKG.Period1_POD_p Period1_POD


55 views0 comments

Recent Posts

See All

Dynamic Insertion#GL#FUSION

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Segment Security #GL#Fusion

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Cross Validation Rules #GL#Fusion Financials

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested