Business Function B0900114 (Retrieve F0901 Info Without Cache) and Retrieve B0900104 (F0901 - Retrieve Account Master Infor for GL Post)
Purpose of Document
Question 1> What is Business Function B0900114 (Retrieve F0901 Info without Cache) for?
Question 2> Is there any similar business function which returns basic Chart of Account (F0901, Account Master) information like B0900114?
Question 1> What is Business Function B0900114 (Retrieve F0901 Info without Cache) for?
Answer 1>
The business function RetrieveF0901InfowithoutCach (B0900114, Retrieve F0901 Info without Cache) can be described as below,
Purpose: This function is to get Account Master (F0901) not from Cache but from database by issuing JDB_SelectKeyed(). The reason we have this business function is that the table F0901 is to be cached (database cache) because we have defined it in P98613 (Database Cache). In return this can cause Dirty Read (return value before it gets update) or Phantom read (return data which was deleted) until you flush/reset database cache (For deletion of cache, see <Document 944015.1> E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne). So benefit of this function is, it returns only limited columns and it reads table directly (not through cache) and drawback is it may perform slower because it has to make a trip to the database.
Note: There are other business functions which read database cache by issuing API JDB_FetchKeyed() and which returns all columns from F0901. For example,
(IN) szAccountId (to select data on F0901.gmaid = (input) Account ID
(OUT) szCompany (F0901.gmco)
(OUT) szCostCenter (F0901.gmmcu)
(OUT) szObjectAccount (F0901.gmobj)
(OUT) szSubsidiary (F0901.gmsub)
(OUT) szDescription001 (F0901.gmdl01)
(OUT) szCurrencyCodeFrom (F0901.gmcrcd)
(OUT) cPostingEdit (F0901.gmpec) for E1 application release 9.0 and 9.1
Standard Application calls B0900114
: Currently 3 batch applications is calling same function as listed below,
R097021 (Transaction w/o Account Master)
R097031 (Account Balance w/o Account Master)
R11414A (Currency Restatement Compute)
: In case you want to make use of this function, refer how standard application is calling it
Question 2> Is there any similar business function which returns basic Chart of Account (F0901, Account Master) information like B0900114?
Answer 2> XX0901 is hard to use because it performs too many things (See, <Document 1372342.1> E1: BSFN: XX0901 - Business Function Detail Information). So you may make use of RetrieveAccountMasterInfoGLPost (B0900104, F0901 - Retrieve Account Master Infor for GL Post) which performs same but this function reads database cache.