3:I[39275,[],""]
5:I[61343,[],""]
6:I[23053,["7699","static/chunks/8e1d74a4-5fcc24cf3a9fd8c2.js","7240","static/chunks/53c13509-baa86b522e6ae78c.js","4740","static/chunks/4740-14bdf05e7ce04a11.js","9617","static/chunks/9617-544346a1cd0024b4.js","3185","static/chunks/app/layout-8c4bc5784f5090d9.js"],"StateProvider"]
7:I[19593,["7699","static/chunks/8e1d74a4-5fcc24cf3a9fd8c2.js","7240","static/chunks/53c13509-baa86b522e6ae78c.js","4740","static/chunks/4740-14bdf05e7ce04a11.js","9617","static/chunks/9617-544346a1cd0024b4.js","3185","static/chunks/app/layout-8c4bc5784f5090d9.js"],""]
8:I[18709,["7699","static/chunks/8e1d74a4-5fcc24cf3a9fd8c2.js","5706","static/chunks/9c4e2130-08078aeb5700c43b.js","5505","static/chunks/385cb88d-fd2f37c33b8aa92c.js","5452","static/chunks/5e22fd23-9bf9fa71e7554411.js","9956","static/chunks/ee560e2c-f551c028fd538293.js","4740","static/chunks/4740-14bdf05e7ce04a11.js","6648","static/chunks/6648-3bc9d66179346fb0.js","9160","static/chunks/app/not-found-5850ce7843ba4d5a.js"],"default"]
9:I[45723,["7699","static/chunks/8e1d74a4-5fcc24cf3a9fd8c2.js","7240","static/chunks/53c13509-baa86b522e6ae78c.js","4740","static/chunks/4740-14bdf05e7ce04a11.js","9617","static/chunks/9617-544346a1cd0024b4.js","3185","static/chunks/app/layout-8c4bc5784f5090d9.js"],"default"]
4:["all","oracle-financials-interview-questions-and-answers","c"]
0:["79z6y6ppLce0GndJRjYzJ",[[["",{"children":[["all","oracle-financials-interview-questions-and-answers","c"],{"children":["__PAGE__",{}]}]},"$undefined","$undefined",true],["",{"children":[["all","oracle-financials-interview-questions-and-answers","c"],{"children":["__PAGE__",{},[["$L1","$L2"],null],null]},["$","$L3",null,{"parallelRouterKey":"children","segmentPath":["children","$4","children"],"error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L5",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":"$undefined","notFoundStyles":"$undefined","styles":[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/402d889fee29bde2.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","1",{"rel":"stylesheet","href":"/_next/static/css/0ff6cecb1d0e96f8.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","2",{"rel":"stylesheet","href":"/_next/static/css/cb4e98a4c2dc4d80.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","3",{"rel":"stylesheet","href":"/_next/static/css/a246b44e33111fd9.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","4",{"rel":"stylesheet","href":"/_next/static/css/9d9d0f6a85930e46.css","precedence":"next","crossOrigin":"$undefined"}]]}],null]},[["$","html",null,{"lang":"en","children":["$","body",null,{"children":["$","$L6",null,{"children":[["$","$L7",null,{}],["$","$L3",null,{"parallelRouterKey":"children","segmentPath":["children"],"error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L5",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":["$","$L8",null,{}],"notFoundStyles":[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/cb4e98a4c2dc4d80.css","precedence":"next","crossOrigin":"$undefined"}]],"styles":null}],["$","$L9",null,{}]]}]}]}],null],null],[[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/0cc2495744a38244.css","precedence":"next","crossOrigin":"$undefined"}]],"$La"]]]]
b:I[67379,["7699","static/chunks/8e1d74a4-5fcc24cf3a9fd8c2.js","5706","static/chunks/9c4e2130-08078aeb5700c43b.js","5505","static/chunks/385cb88d-fd2f37c33b8aa92c.js","5452","static/chunks/5e22fd23-9bf9fa71e7554411.js","9956","static/chunks/ee560e2c-f551c028fd538293.js","7240","static/chunks/53c13509-baa86b522e6ae78c.js","6051","static/chunks/795d4814-d7614a20709c27af.js","614","static/chunks/3d47b92a-f2bb54912083012c.js","9212","static/chunks/59650de3-13cfd2620b7240d2.js","522","static/chunks/94730671-a8ad9eca65504500.js","7675","static/chunks/b563f954-501d993050fd0717.js","1994","static/chunks/e34aaff9-cd556a7ee1a90c03.js","6990","static/chunks/13b76428-5a68792917164904.js","5957","static/chunks/30a37ab2-a5fc2d8864b3152b.js","6844","static/chunks/f25cdb8d-30c837856fb6d42d.js","7259","static/chunks/479ba886-8536ff4966e1aaf8.js","4740","static/chunks/4740-14bdf05e7ce04a11.js","6648","static/chunks/6648-3bc9d66179346fb0.js","4349","static/chunks/4349-c8f0646a83cc4179.js","4791","static/chunks/4791-6c93b9aca8a9f315.js","5225","static/chunks/5225-dc21c87d99338f19.js","9293","static/chunks/9293-d1b040d0324d0d5a.js","5919","static/chunks/5919-545104f05818203e.js","1413","static/chunks/1413-986ad1f4cd2d661e.js","2499","static/chunks/2499-61bd3b514e9c4cb8.js","4175","static/chunks/4175-fb05509a4e1790ec.js","5653","static/chunks/app/%5B...all%5D/page-f1bbbeae9a681a62.js"],"default"]
c:Te2f3,<p>Oracle Financials ERP Cloud is a cloud-based end-to-end business management solution developed for midsized to enterprise-level consumers. It gives a set of applications including financial accounting, material planning, self-service reporting, and analytics.</p>
<p>If you're preparing for an interview for a role that involves Oracle Financials, it's important to familiarize yourself with common <em><strong>Oracle Financials Interview Questions</strong></em> to showcase your knowledge and skills in the cloud-based end-to-end business management solution.</p>
<table style="border-collapse: collapse; width: 100%; height: 120px;" border="1px" cellpadding="10">
<tbody>
<tr>
<td style="width: 98.2759%;">
<h3><strong>Most Frequently Asked Oracle Financials Interview Questions</strong></h3>
<ul>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q1">How many key flex fields are there in Oracle financials?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q5">What is a key flex field qualifier?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q8">What are Cross Validating Values?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q10">How many segments are there in the key flex field (s) in the Oracle general ledger?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q14">What is a period in Oracle gl?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q22">What is a retained earnings account?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q29">What is Account Hierarchy Manager?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q35">Can you create a journal entry with a parent segment value?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q51">How revaluation journals are created in which currency?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q61">Explain a profile and list the types of profiles.</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q70">List the necessary tables in GL.</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q74">What are Oracle financial modules?</a></span></li>
</ul>
</td>
</tr>
</tbody>
</table>
<h2><strong><span style="color: #236fa1; font-size: 24px;">Oracle Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q1"></a>1Q) How many key flex fields are there in oracle financials?</span></h3>
<p><span style="color: #000000;"><strong><span style="font-size: 12pt;">Ans: </span></strong><span style="font-size: 14px;">The key flex fields in oracle financials are:</span></span></p>
<p><em><span style="font-size: 14px;"><strong>General Ledger</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">&nbsp;Accounting Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Assets</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Asset Key Flexfield</span></li>
<li><span style="font-size: 14px;">Location Flexfield</span></li>
<li><span style="font-size: 14px;">Category Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Service</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Service Item Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Receivables</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Territory Flexfield</span></li>
<li><span style="font-size: 14px;">Sales Tax Location Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Inventory</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Item Categories</span></li>
<li><span style="font-size: 14px;">System Items</span></li>
<li><span style="font-size: 14px;">Sales Orders</span></li>
<li><span style="font-size: 14px;">Item Catalogs</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">2Q) What is the report used to identify duplicate suppliers?&nbsp;</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>To find out duplicate suppliers, the SUPPLIER AUDIT REPORT is run.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">3Q) What are the benefits of flex fields?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Benfits of flexfields are:</span></p>
<ul>
<li><span style="font-size: 14px;">Configure applications to support your own accounting, product, and other codes.</span></li>
<li><span style="font-size: 14px;">Enable the construction of intelligent keys.</span></li>
<li><span style="font-size: 14px;">Configure the application to capture additional data.</span></li>
<li><span style="font-size: 14px;">Use the application to validate values and value combinations entered by the user.</span></li>
<li><span style="font-size: 14px;">Support multiple flex field structures depending on the data context.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">4Q) What are the types of flex fields?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Types <span style="color: #000000;">of flexfields are:</span></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Key flexfield</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Descriptive flexfield</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q5"></a>5Q) What is a key flex field qualifier?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A qualifier is a label attached to a particular key flexfield segment so it can be located by the application requiring its information. A key flexfield qualifier can be of 2 types:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Flexfield qualifiers identify a segment in a flexfield.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Segment qualifiers identify a value set in a segment.</span></li>
</ul>
<blockquote>
<table style="border-collapse: collapse; width: 100%; height: 33px; background-color: #ecf0f1;" border="1px" cellpadding="10">
<tbody>
<tr style="height: 33px;">
<td style="width: 98.1605%; height: 33px; text-align: center;"><em>Inclined to build a profession as Oracle Financial Developer? Then here is the blog post on, explore <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle Financial Training" href="https://tekslate.com/oracle-financials-training" target="_blank"><strong>Oracle Financial Training</strong></a></span></em></td>
</tr>
</tbody>
</table>
</blockquote>
<h3><span style="font-size: 18px; color: #e67e23;">6Q) What are the types of Flexfield Qualifiers?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>NATURAL ACCOUNT:</em> </strong></span>Each Accounting Flexfield structure must contain only one natural account segment. When setting up the values, you will indicate the type of account as Asset, Liability, Owner&rsquo;s Equity, Revenue, or Expense.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>BALANCING ACCOUNT:</em>&nbsp;</strong></span>Each Structure must contain only one balancing segment. Oracle GL ensures that all journal balances for each balancing segment.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>COST CENTER:</em>&nbsp;</strong></span>This segment is required for Oracle Assets. The Cost centre segment is used in many Oracle Assets reports and by Oracle Workflow to generate account numbers. Also, <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle apps training" href="https://tekslate.com/oracle-apps-technical-training" target="_blank"><strong>Oracle apps training</strong></a> </span>Projects and Oracle Purchasing utilize the cost centre segment.</span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>INTERCOMPANY:&nbsp;</strong></span></em>GL automatically uses the intercompany segment in the account code combination to track intercompany transactions within a single set of books. This segment has the same value set and the same values as the balancing segment.</span></p>
<p style="text-align: justify;"><span style="color: #000000;"><em><span style="font-size: 14px;"><strong>Segment Qualifiers</strong></span></em></span></p>
<p style="text-align: left;"><span style="font-size: 14px;">ACCOUNT TYPE: Asset, Liability, Owner&rsquo;s Equity, Revenue, Expense, Budgetary Dr, and Budgetary Cr.</span></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 39px;">
<td style="width: 249.5px; height: 39px;"><span style="font-size: 14px;">Budget entry allowed</span></td>
<td style="width: 212.5px; height: 39px;"><span style="font-size: 14px;">(Yes/No)</span></td>
</tr>
<tr style="height: 37px;">
<td style="width: 249.5px; height: 37px;"><span style="font-size: 14px;">Posting allowed</span></td>
<td style="width: 212.5px; height: 37px;"><span style="font-size: 14px;">(Yes/No)</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Control Account Reconciliation Flag</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Available for specific countries</span></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px;">&nbsp;<span style="color: #e67e23;">7Q) What is the implication of dynamic insert?</span></span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px; color: #000000;">Dynamic Insertion is a feature that controls whether the user can enter new account code combinations from any form/window. If this feature is disabled, then the user cannot input new account code combinations from any window/form.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px; color: #000000;">Oracle applications use a particular form (called a Combination form) for directly entering the new code combinations. Users can enter new account code combinations only through this form if Dynamic Insertion is disabled.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q8"></a>8Q) What are Cross Validating Values?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>For key flexfields with multiple segments, we can define rules to cross-check value combinations entered within the key flexfield segments. This option is referred to as Cross Validation rules.</span></p>
<p style="text-align: left;"><em><span style="color: #000000; font-size: 14px;"><strong>Value Set List Types</strong></span></em></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 39px;">
<td style="width: 249.5px; height: 39px;"><span style="font-size: 14px;">List of values</span></td>
<td style="width: 212.5px; height: 39px;"><span style="font-size: 14px;">(10 to 200)</span></td>
</tr>
<tr style="height: 37px;">
<td style="width: 249.5px; height: 37px;"><span style="font-size: 14px;">A long list of values</span></td>
<td style="width: 212.5px; height: 37px;"><span style="font-size: 14px;">(&gt; 200)</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Poplist</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">(&gt; 10)</span></td>
</tr>
</tbody>
</table>
<p><span style="color: #000000; font-size: 14px;"><strong>Value Set Security Type</strong></span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>No Security:</strong></span> </em>All security is disabled for this value set.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><em><strong>Hierarchical Security:</strong></em> </span>With Hierarchical security, the features of the value security and value hierarchies are combined. With this feature, any security that applies to a parent value also applies to its child values.</span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>Non-Hierarchical Security:</strong></span></em> Security is enabled, but the rules of hierarchical security do not apply. That is, a security rule that applies to a parent value does not &ldquo;cascade down&rdquo; to its child values.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">9Q) What are the types of Value Sets?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Types of Value Sets:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>None:</strong></em>&nbsp;A value set of the type None has no list of approved values associated with it. A None value set performs only minimal checking of, for example, data type and length.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Independent:</strong></em>&nbsp;Independent type value sets perform basic checking but also check a value entered against the list of approved values you define.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Dependent:</strong></em> A dependent value set is associated with an independent value set. Dependent value sets ensure that all dependent values are associated with a value in the related independent value set.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Table:</strong></em> Table value sets obtain their lists of approved values from existing application tables. When defining your table value set, you specify a SQL query to retrieve all the approved values from the table.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><strong><em>Special:</em>&nbsp;</strong>This specialized value set provides another flexfield as a value set for a single segment.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Pair:&nbsp;</strong></em>This specialized value set provides a range of flexfield as a value set for a pair of segments.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Translated Independent:</strong></em> This works similar to the Independent type. However, a Translated Independent value set can contain display values that are translated into different languages.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Translated Dependent:</strong></em> This works similarly to the Dependent type. However, a Translated Dependent value set can contain display values that are translated into different languages.</span></li>
</ul>
<p>&nbsp;</p>
<h2><strong><span style="font-size: 24px; color: #236fa1;">Oracle Fusion Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q10"></a>10Q) How many segments are there in the key flexfield(s) in the oracle general ledger?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Oracle GL Key flexfield can have 15 columns each representing a segment. However, the segments type can be:</span></p>
<ul>
<li><span style="font-size: 14px;">Cost&nbsp;Center&nbsp;segment</span></li>
<li><span style="font-size: 14px;">Balancing segment</span></li>
<li><span style="font-size: 14px;">Account segment</span></li>
<li><span style="font-size: 14px;">Intercompany segment</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">11Q) On which entity is a security rule applicable?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>It&rsquo;s a feature of Key flexfield, applicable on Value Sets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">12Q) On which entity is the cross-validation rule applicable?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>It&rsquo;s a feature of Key flexfield, applicable on Value Sets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">13Q) Shorthand alias?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>An Alias is a label for a particular combination of key flexfield segment value. This allows users to enter data faster and more easily because the user has to just enter the shorthand alias, and the flexfield automatically populates the values for the segment.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q14"></a>14Q) What is a period in oracle gl?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A Period corresponds to a time span within which transactions are entered before finalizing, otherwise called as close of the period.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">15Q) What are the period types?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Predefined period types in Oracle GL are:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Month</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Quarter</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Year</span></li>
</ul>
<p style="text-align: justify;"><span style="font-size: 14px;">If needed, period types of our own can be defined in addition to the standard periods.</span></p>
<p style="text-align: right;"><span style="font-size: 14px;"><em>Checkout:&nbsp;</em>[ <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA Sample Project Creation" href="https://tekslate.com/projects" target="_blank"><em><strong>Oracle SOA Sample Project Creation</strong></em></a></span> ]</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">16Q) What are an adjusting period and its implications?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Typically, the last day of the fiscal year is used to perform adjusting and closing journal entries. This period is referred to as Adjusting Period.</span></p>
<p><span style="font-size: 14px;">Choosing whether to include an adjusting period or not in a calendar is a very important decision. There can be an unlimited number of adjusting periods. Once the accounting calendar is used, changes to its structure to remove or add an adjusting period cannot be done.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">17Q) How many types of conversion rates are there in oracle gl?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>There are 5 basic types of conversion rate types predefined in Oracle GL:</span></p>
<p><span style="font-size: 14px;"><strong>Spot:</strong>&nbsp;An exchange rate based on the rate for a specific date. It applies to the immediate delivery of a currency.</span></p>
<p><span style="font-size: 14px;"><strong>Corporate:</strong> An exchange rate that standardizes rates for your company. This rate is generally a standard market rate determined by senior financial management for use throughout the organization.</span></p>
<p><span style="font-size: 14px;"><strong>User:</strong>&nbsp;An exchange rate that you enter during foreign currency journal entry.</span></p>
<p><span style="font-size: 14px;"><strong>Emu Fixed:&nbsp;</strong>An exchange rate that is used by countries joining the EU during the transition period to the Euro currency.</span></p>
<p><span style="font-size: 14px;"><strong>User-Defined: </strong>A rate type defined by your company to meet specific needs.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">18Q) What type of conversion rate is required to be defined for all transactional purposes?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Spot (Not sure).</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">19Q) What are the three essential components of a gl set of books?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px; color: #000000;"><strong style="text-align: start;">Ans: </strong><span style="text-align: start;">The Essential components of gl set of books are:</span></span></p>
<p><em><span style="font-size: 14px;"><strong>Chart of Accounts:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. Your chart of accounts is the account structure you define to fit the specific needs of your organization.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. You can choose the number of account segments as well as the length, name, and order of each segment.</span></p>
<p><em><span style="font-size: 14px;"><strong>Accounting Calendar:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. An accounting calendar defines an accounting year and the periods it contains.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. You can define multiple calendars and assign a different calendar to each set of books.</span></p>
<p><em><span style="font-size: 14px;"><strong>Currencies:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. You select the functional currency for your set of books as well as other currencies that you use to transact business and report in.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. GL converts monetary amounts entered in a foreign currency to functional currency equivalents using supplied rates.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">20Q) What is the implication of the &lsquo;future period&rdquo; field in the set of book definition forms?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>The value mentioned in the Future Period field represents the number of future enterable periods that users can use to input journal entries (provided those future periods are opened). However, consideration must be given to minimize the number of future enterable periods to prevent users from accidentally entering journal entries in an incorrect period.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">21Q) How many tabbed regions are there in the set of book definition form? What are the names of these tabbed regions?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>There are 5 tabbed regions in the set of a book's definition form.</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Closing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Journaling</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Average Balances</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Budgetary Control</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Multiple Reporting Currencies</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q22"></a>22Q) What is a retained earnings account?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL posts the net balance of all income and expenses accounts from the prior year to this account when you open the first period of a fiscal year.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">23Q) What is the purpose of the translation adjustment account?</span></h3>
<p style="text-align: left;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>If you translate your functional currency balances into another currency for reporting, or if you revalue foreign currency-dominated balances, you must specify a translation adjustment account.</span></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 38.9931px;">
<td style="width: 249.5px; height: 38.9931px;"><span style="font-size: 14px;">Parent</span></td>
<td style="width: 212.5px; height: 38.9931px;"><span style="font-size: 14px;">Do no enable</span></td>
</tr>
<tr style="height: 36.9965px;">
<td style="width: 249.5px; height: 36.9965px;"><span style="font-size: 14px;">Budget</span></td>
<td style="width: 212.5px; height: 36.9965px;"><span style="font-size: 14px;">Yes</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Posting</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Yes</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Account Type</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Ownership/Stock</span></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">24Q) What is the purpose of/unique feature of the net income account?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL uses this account to capture the net activity of all revenue and expense accounts when calculating the average balance for retained earnings.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">25Q) What is the purpose of the transaction calendar?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong>The transaction</span> calendar is defined to enable average balance processing. The transaction calendar is created optionally with valid business days mentioned.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">26Q) To allow unbalances journal posting what action is required at a set of book definition levels / what is a suspense account and its purpose?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>If you choose to allow posting of out-of-balance/unbalanced journal entries, GL automatically posts the difference to Suspense Account. However, the Suspense Account checkbox should be checked and an Account # to be provided for this feature to work during the creation of a set of books.</span></p>
<p><span style="font-size: 14px;">If you have multiple companies or balancing entities within a set of books, GL automatically creates a suspense account for each balancing entity.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">27Q) What is a value set?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A value set defines the boundaries for the attributes that you assign to a key or descriptive flexfield segment. Value sets control what types of values can be used as Accounting Flexfield segment values. Value sets determine the attributes of your segments such as length, zero-fill, and right justify, alphanumeric, and value security. Value sets also control how validation is performed.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">28Q) To allow intercompany journals what action is required at a set of book definition levels?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>One of the accounting key flexfield segments should be of the type Intercompany. This segment would have the same value set and the same values as the balancing segment.</span></p>
<p><span style="font-size: 14px;">Also, enable the Balance Intercompany Journals feature. This allows users to post out-of-balance intercompany journal entries and automatically balance those journal entries against a specified intercompany account. Select the Balance Intercompany Journal checkbox and enter the intercompany account(s) in the Intercompany Accounts window. If you do not enable this feature, you can only post intercompany journal entries that balance by balancing segment, (usually the company segment).</span></p>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q29"></a>29Q) What is Account Hierarchy Manager?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Account hierarchy manager is a feature provided by Oracle Application which allows to:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Graphically create, maintain, and review account structure hierarchies.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Define new parent and child segment values, as well as change parent/child dependencies.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Create new roll-up groups from the account hierarchy manager and have your changes reflected automatically in both key segment values and roll-up groups window.</span></li>
</ul>
<p style="text-align: justify;"><span style="font-size: 14px;">Also provides an option to control entities such as:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Read-only</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Read/write security</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Segment Value Security: An oracle applications feature that lets you exclude a segment value or ranges of segment values for a specific user responsibility. Segment Value Security is extended to the Account Hierarchy Manager.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Chart of Accounts Security</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">30Q) What does balance type &ldquo;a&rdquo; indicate?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not Sure. Maybe ACTUAL.</span></p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA EDN" href="https://tekslate.com/edn-event-delivery-network" target="_blank" rel="noopener"><strong>Oracle SOA EDN</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">31Q) How many buttons are there on the manual journal entry form? What are they?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>By default, there are 3 buttons on the manual journal entry form:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">More Details</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Change Currency</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">More Actions</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">32Q) How many buttons are there under the &ldquo;more actions&rdquo; button? What are they?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>When we click on the &ldquo;More Actions&rdquo; button, another window appears with 4 buttons:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Reverse Journal</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Post</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Change Period</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">CANCEL</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">33Q) What is the status of a newly entered journal?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Unposted.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Posting statuses.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Unposted</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Pending</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Processing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Selected for posting</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Posted</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Error</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">34Q) What is Journal Reversal Pre-Requisites?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">The journal balance type is Actual</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The Journal category has AutoReverse enabled</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The Journal is posted but not yet reversed</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The journal reversal period is open or future enterable</span></li>
</ul>
<p>&nbsp;</p>
<h2 id="advanced"><strong><span style="color: #236fa1; font-size: 24px;">Oracle Cloud Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q35"></a>35Q) Can you create a journal entry with a parent segment value?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure. Maybe possible with a child value combined. Parent values automatically allow posting and budgeting.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">36Q) When a journal is created, which all gl tables are impacted?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>The impacted gl tables are:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_BATCHES</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_HEADERS</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_LINES</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">37Q) When a journal is posted, which gl table is posted?</span></h3>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL_BALANCES&nbsp;</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">38Q) When journals are interfaced, which gl table is populated?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL_INTERFACE</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">39Q) What is the name of the concurrent to populate the gl tables from the interface table?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Journal Import.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">40Q) What is the mechanism to rectify a posted journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Reverse the Journal.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">41Q) What is the purpose of the state journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>You can associate statistical amounts with monetary amounts by using statistical units of measure.</span></p>
<p><span style="font-size: 14px;">This enables you to enter both monetary and statistical amounts in a single journal entry line.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">42Q) For the creation of periodically repetitive journals, what is the gl tool?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Recurring Journal.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">43Q) What is mass allocations?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A single journal entry formula that allocates revenues and expenses across a group of cost centers, departments, or divisions.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">44Q) What is the formula for the creation of allocation journals?</span></h3>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans:&nbsp; &nbsp;</strong></span><strong>A*B/C</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">A is the Cost Pool that will be allocated. It can be an amount or account balance.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">B is the numerator of the factor (a number or statistical account) that multiplies the cost pool for the allocation.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">C is the denominator of the factor (a number or statistical account) that divides the cost pool for the allocation.</span></li>
</ul>
<p style="text-align: justify; padding-left: 20px;"><span style="font-size: 14px;">Note: Parent values can be used in one or more segments.</span></p>
<p style="text-align: justify;"><span style="color: #e67e23; font-size: 14px;"><strong>Account segment types for mass allocation.</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Looping</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Summing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Constant</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">45Q) What are the target and offset accounts in the allocation formula?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>These are the lines that are the actual journal entry.</span></p>
<p><em><span style="font-size: 14px;"><strong>Target (T):</strong></span></em></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Enter an account in the Target line to specify the destination for your allocation.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The parent value used in the target must be the same parent value used in the B and C lines of the formula.</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Offset (O):</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Enter an account in the Offset line to specify the account to use for offsetting debit or credit from your allocation.</span></li>
<li><span style="font-size: 14px;">The Offset account is usually the same as formula line A to reduce the cost pool by the allocated amount.</span></li>
</ul>
<p>&nbsp;</p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA Rejection handles" href="https://tekslate.com/rejection-handles" target="_blank"><strong>Oracle SOA Rejection handles</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">46Q) Can you delete an unposted journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">47Q) Journals from which sub-ledger do not pass through the gl interface table?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure. Maybe Assets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">48Q) When the journals are interfaced and imported, what posting status do they have?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Unposted.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">49Q) What is the pre-requisite for conversion?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Define new currencies</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Enable seeded currencies</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Define rate types</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Enter daily rates</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">50Q) For revaluation, what rate types are available?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Daily rates</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Historical rates</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The revaluation rate is the inverse of the period-end rate.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q51"></a>51Q) How revaluation journals are created in which currency?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Functional currency</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">52Q) Explain Flexfield Qualifiers In Gl?</span></h3>
<p><span style="font-size: 12pt;"><span style="color: #000000;"><strong>Ans: </strong></span><span style="font-size: 14px;">Need to assign qualifiers to individual accounting key flexfield segments to identify or represent the purpose of COA. Natural Account Each Accounting Flexfield structure must contain only one natural account segment. When setting up the values, you will indicate the type of account as Asset, Liability, Owner&rsquo;s Equity, Revenue, or Expense. Balancing Account Each structure must contain only one balancing segment. Oracle General Ledger ensures that all journal balances for each balancing segment. Cost Center This segment is required for Oracle Assets. The cost centre segment is used in many Oracle Assets reports and by Oracle Workflow to generate account numbers. Also, Oracle Projects and Oracle Purchasing utilize the cost centre segment. Intercompany General Ledger automatically uses the intercompany segment in the account code combination to track intercompany transactions within a single ledger. This segment has the same value set and the same values as the balancing segment.</span></span></p>
<h3><span style="font-size: 18px; color: #e67e23;">53Q) Discuss Primary Ledger Vs Secondary Ledger Vs Reporting Currency.</span></h3>
<p><strong><span style="font-size: 12pt; color: #000000;">Ans: Primary Ledger Vs Secondary Ledger:</span></strong></p>
<p><span style="font-size: 14px;">Use secondary ledgers for supplementary purposes, such as consolidation, statutory reporting, or adjustments for one or more legal entities within the same accounting setup. For example, use a primary ledger for corporate accounting purposes that use the corporate chart of accounts and subledger accounting method, and use a secondary ledger for statutory reporting purposes that use the statutory chart of accounts and subledger accounting method. This allows you to maintain both a corporate and statutory representation of the same legal entity&rsquo;s transactions in parallel.</span></p>
<p style="text-align: right;"><em>Checkout:</em> [ <span style="color: #236fa1;"><a style="color: #236fa1;" title=" How to provide a Security in Oracle SOA " href="https://tekslate.com/security" target="_blank"><strong><em>How to provide Security in Oracle SOA </em></strong></a></span>]</p>
<h2 id="financials"><strong><span style="color: #236fa1; font-size: 24px;">Oracle Finance Functional Consultant Interview Questions</span></strong></h2>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>54Q) What are the kinds of flex fields?</strong></span></h3>
<p><strong>Ans:</strong> There are two different kinds of flexfields they are:</p>
<p><em><strong>Key flexfield:</strong></em> A key flexfield is a field you can customize to insert multi-segment values such as account numbers, part numbers, etc. A descriptive flexfield means a field you customize to insert further information for which your Oracle Applications product has not already given a field.</p>
<p><em><strong>Descriptive flexfield:</strong></em> Descriptive flexfields give a method for implementers at customer sites to add custom attributes to entities, and to determine validation and show properties for them. A descriptive flexfield is a logical grouping of segments that are mapped to a set of database columns that serve as placeholders for custom attributes.&nbsp;</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>55Q) What are the advantages of flex fields?</strong></span></h3>
<p><span style="color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li>Flexfields enable the development of wise keys.</li>
<li>Utilizes the application to approve esteem.</li>
<li>Configure the applications to assist your bookkeeping.</li>
<li>Support various flex field structures depending upon the information setting.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">56Q) What is the symbol of DFF in the forms?</span></strong></span></h3>
<p><strong>Ans:</strong> Square bracket[] is the symbol of DFF in the forms.</p>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">57Q) How many segments are in AFF?</span></strong></span></h3>
<p><strong>Ans: </strong>The maximum number of segments in AFF is 30, and the minimum number of segments in AFF is 2.</p>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">58) What are the different types of flexfield qualifiers?</span></strong></span></h3>
<p><strong>Ans:</strong> There are four different types of flexfield qualifiers they are:</p>
<ul>
<li>Cost centre segment qualifier&nbsp;</li>
<li>Balancing segment qualifier&nbsp;</li>
<li>Intercompany segment qualifier&nbsp;</li>
<li>Natural account segment qualifier&nbsp; &nbsp;</li>
</ul>
<h3 dir="ltr" role="presentation"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">59Q) What tables store Currency and period type names?</span></strong></span></h3>
<p><strong>Ans: </strong></p>
<ul>
<li>Currency -- FND_CURRENCIES&nbsp;</li>
<li>Period -- GL_PERIOD_STATUSES</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">60Q) What are the different types of calendars?&nbsp;</span></strong></span></h3>
<p><strong>Ans: </strong>There are two different types of calendars they are</p>
<p><em><strong>Fiscal calendar:</strong></em> A fiscal year is a 12-month period utilized by organizations and governments for financial reporting plus budgeting that sometimes follows the January - December calendar year and sometimes does not.</p>
<p><em><strong>Accounting:</strong></em> The accounting calendar determines the start and end of your fiscal year and the time periods within that calendar, including the specific dates for each time period. Your sales application utilizes these defined periods, frequently called enterprise periods, for multiple purposes.&nbsp;</p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Latest Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="JMS in Oracle SOA 11g" href="https://tekslate.com/jms-java-messaging-service11g" target="_blank"><strong>JMS in Oracle SOA 11g</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><a id="q61"></a>61Q) Explain a profile and list the types of profiles.</span></h3>
<p><strong>Ans:</strong> A profile is a changeable option that influences the way your application runs. There are two types of profiles.</p>
<ul>
<li>User-defined&nbsp;</li>
<li>System defined&nbsp;</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">62Q) Explain about the period, and what are the different types of periods?</span></h3>
<p><strong>Ans: </strong>A Period correlates to a period range within which exchanges are entered preceding finishing, usually called as close of the period, predefined period types are.</p>
<ul>
<li>Month</li>
<li>Quarter&nbsp;</li>
<li>Year</li>
</ul>
<h3 dir="ltr" role="presentation"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">63Q) What are the different types of change rates in Oracle gl?</span></strong></span></h3>
<p><strong>Ans:</strong> There are five different types of change rates in oracle gl they are:</p>
<ul>
<li><strong>Detect:</strong>&nbsp;A swapping scale dependent upon the rate for a specific date. It refers to the prompt conveyance of money.&nbsp;</li>
<li><strong>Corporate:</strong> A swapping scale that institutionalizes rates for your business. This rate is usually a standard market rate managed by senior money-related administration for use all over the association.</li>
<li><strong>Client: </strong>A conversion scale that you enter significantly outside the cash diary section.</li>
<li><strong>Emu Fixed:</strong> A conversion scale that is used by nations joining the EU among the progress time frame to the Euro cash.</li>
<li><strong>Client Defined:</strong> A rate type characterized by your business to address explicit issues.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><strong>64Q) Explain a held income account.</strong></span></h3>
<p><strong>Ans: </strong>GL posts the net equalization of all pay and costs accounts from the earlier year to this record when you open the main time of a financial year.</p>
<h3><span style="font-size: 18px;"><strong><span style="color: #e67e23;">65Q) Explain an esteemed set.</span></strong></span></h3>
<p><strong>Ans:</strong> An esteem set characterizes the limits for the attributes which you dole out to a key or descriptive flexfield fragment. Esteem sets control of what kinds of qualities can be used as Accounting Flexfield section esteems. Esteem sets determine the properties of your sections, for example, zero-fill, length, and right legitimize, alphanumeric, and esteem security.</p>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">66Q) Explain the journal import.</span></h3>
<p><strong>Ans:</strong> Journal import is the name of the concurrent to populate the gl table from the interface tables.</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>67Q) What is the use of the state journal?</strong></span></h3>
<p><strong>Ans: </strong></p>
<p>You can join factual sums with financial sums by using factual units of measure.</p>
<p>This enables you to enter both fiscal plus measurable sums within a solitary diary section line.</p>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">68Q) What is a Recurring journal?</span></h3>
<p><strong>Ans: </strong>The recurring journal is the gl tool that is used to create periodically repetitive journals.</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>69Q) List the types of record segments for mass allocation.</strong></span></h3>
<p><strong>Ans:</strong>&nbsp;</p>
<ul>
<li>Circling</li>
<li>Summing</li>
<li>Consistent &nbsp;&nbsp;</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><strong><a id="q70"></a>70Q) List the necessary tables in GL.</strong></span></h3>
<ul>
<li>GL_JE_BATCHES</li>
<li>GL_JE_HEADERS</li>
<li>GL_JE_LINES</li>
<li>GL_BALANCES</li>
<li>GL_SETS_OF_BOOKS</li>
<li>GL_CODE_COMBINATIONS</li>
<li>GL_PERIOD_STATUES</li>
<li>GL_INTERFACE</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">71Q) In which table supplier's information is stored?</span></h3>
<p><strong>Ans: </strong>Suppliers information can be found in the following tables:</p>
<ul>
<li>PO_VENDORS</li>
<li>PO_VENDOR_SITES_ALL</li>
<li>PO_VENDOR_CONTACTS</li>
</ul>
<h3><span style="color: #e67e23; font-size: 18px;"><strong>72Q) What is the formula used to create allocation journals?</strong></span></h3>
<p><strong>Ans:</strong> A*B/C.</p>
<ul>
<li>A is the Cost Pool that will be distributed. It manages to be a sum or record balance.</li>
<li>B is the numerator of the factor that replicates the cost pool for the designation.</li>
<li>C is the denominator of the factor which separates the cost pool for the distribution.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">73Q) Difference between kff and dff?</span></h3>
<p><strong>Ans: </strong></p>
<p><em><strong>KFF:</strong></em></p>
<ul>
<li>KFF is a unique identifier.</li>
<li>KFF is stored in the segment column.</li>
</ul>
<p><em><strong>DFF:</strong></em></p>
<ul>
<li>DFF is used to capture additional information.</li>
<li>DFF is stored in an attribute column.</li>
</ul>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong><a id="q74"></a>74Q) What are Oracle financial modules?</strong></span></h3>
<p><strong>Ans: </strong>Six important Oracle financials modules are:</p>
<ul>
<li>Oracle Assets&nbsp;</li>
<li>Oracle Payables</li>
<li>Oracle General Ledger</li>
<li>Oracle Cash Management&nbsp;</li>
<li>Oracle receivables&nbsp;</li>
<li>Oracle Tabs</li>
</ul>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="How to work with FTP in Oracle SOA" href="https://tekslate.com/ftpfile-transfer-protocol" target="_blank"><strong>How to work with FTP in Oracle SOA</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3 style="text-align: justify;"><span style="color: #e67e23; font-size: 18px;"><strong>Different statuses of an accounting period.</strong></span></h3>
<p><span style="font-size: 12pt;"><strong>Ans:<span style="font-size: 14px;"> </span></strong><span style="font-size: 14px;">The different statuses are:</span></span></p>
<p><span style="font-size: 14px;"><strong>1) <em>Never Opened:</em> </strong>Cannot enter or post journals.</span></p>
<p><span style="font-size: 14px;"><strong>2) <em>Future Enterable:</em> </strong>Enter journal, but cannot post. The number of future enterable periods is a fixed number defined in the set of books window. The number of the future enterable period can be changed at any time.</span></p>
<p><span style="font-size: 14px;"><strong>3) <em>Open:</em> </strong>Enter and port journals to any open period. An unlimited number of periods can be opened, but doing so may slow the posting process and can confuse users entering journals.</span></p>
<p><span style="font-size: 14px;"><strong>4) <em>Closed:</em> </strong>Cannot post journals in a closed period. Must reopen closed periods before posting journals. Should manually close periods after finishing month/quarter/year-end processing.</span></p>
<p><span style="font-size: 14px;"><strong>5) <em>Permanently Closed:</em> </strong>Permanently closed periods cannot be reopened. This status is required to Archive and Purge data.</span></p>
<p>&nbsp;</p>
<h3><span style="color: #e67e23; font-size: 20px;"><strong>Conclusion:&nbsp;</strong></span></h3>
<p>Use Oracle Financials applications to better accomplish the business to the targets that are published to investors. Management can adequately report to investors and colleagues. Oracle Financials applications also assist you to meet your responsibilities in key areas encompassing the numbers, such as Compliance. If you want to know more please enrol on the course.&nbsp;</p>e:Te2f3,<p>Oracle Financials ERP Cloud is a cloud-based end-to-end business management solution developed for midsized to enterprise-level consumers. It gives a set of applications including financial accounting, material planning, self-service reporting, and analytics.</p>
<p>If you're preparing for an interview for a role that involves Oracle Financials, it's important to familiarize yourself with common <em><strong>Oracle Financials Interview Questions</strong></em> to showcase your knowledge and skills in the cloud-based end-to-end business management solution.</p>
<table style="border-collapse: collapse; width: 100%; height: 120px;" border="1px" cellpadding="10">
<tbody>
<tr>
<td style="width: 98.2759%;">
<h3><strong>Most Frequently Asked Oracle Financials Interview Questions</strong></h3>
<ul>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q1">How many key flex fields are there in Oracle financials?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q5">What is a key flex field qualifier?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q8">What are Cross Validating Values?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q10">How many segments are there in the key flex field (s) in the Oracle general ledger?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q14">What is a period in Oracle gl?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q22">What is a retained earnings account?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q29">What is Account Hierarchy Manager?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q35">Can you create a journal entry with a parent segment value?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q51">How revaluation journals are created in which currency?</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q61">Explain a profile and list the types of profiles.</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q70">List the necessary tables in GL.</a></span></li>
<li><span style="color: #236fa1;"><a style="color: #236fa1;" href="#q74">What are Oracle financial modules?</a></span></li>
</ul>
</td>
</tr>
</tbody>
</table>
<h2><strong><span style="color: #236fa1; font-size: 24px;">Oracle Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q1"></a>1Q) How many key flex fields are there in oracle financials?</span></h3>
<p><span style="color: #000000;"><strong><span style="font-size: 12pt;">Ans: </span></strong><span style="font-size: 14px;">The key flex fields in oracle financials are:</span></span></p>
<p><em><span style="font-size: 14px;"><strong>General Ledger</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">&nbsp;Accounting Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Assets</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Asset Key Flexfield</span></li>
<li><span style="font-size: 14px;">Location Flexfield</span></li>
<li><span style="font-size: 14px;">Category Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Service</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Service Item Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Receivables</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Territory Flexfield</span></li>
<li><span style="font-size: 14px;">Sales Tax Location Flexfield</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Inventory</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Item Categories</span></li>
<li><span style="font-size: 14px;">System Items</span></li>
<li><span style="font-size: 14px;">Sales Orders</span></li>
<li><span style="font-size: 14px;">Item Catalogs</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">2Q) What is the report used to identify duplicate suppliers?&nbsp;</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>To find out duplicate suppliers, the SUPPLIER AUDIT REPORT is run.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">3Q) What are the benefits of flex fields?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Benfits of flexfields are:</span></p>
<ul>
<li><span style="font-size: 14px;">Configure applications to support your own accounting, product, and other codes.</span></li>
<li><span style="font-size: 14px;">Enable the construction of intelligent keys.</span></li>
<li><span style="font-size: 14px;">Configure the application to capture additional data.</span></li>
<li><span style="font-size: 14px;">Use the application to validate values and value combinations entered by the user.</span></li>
<li><span style="font-size: 14px;">Support multiple flex field structures depending on the data context.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">4Q) What are the types of flex fields?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Types <span style="color: #000000;">of flexfields are:</span></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Key flexfield</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Descriptive flexfield</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q5"></a>5Q) What is a key flex field qualifier?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A qualifier is a label attached to a particular key flexfield segment so it can be located by the application requiring its information. A key flexfield qualifier can be of 2 types:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Flexfield qualifiers identify a segment in a flexfield.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Segment qualifiers identify a value set in a segment.</span></li>
</ul>
<blockquote>
<table style="border-collapse: collapse; width: 100%; height: 33px; background-color: #ecf0f1;" border="1px" cellpadding="10">
<tbody>
<tr style="height: 33px;">
<td style="width: 98.1605%; height: 33px; text-align: center;"><em>Inclined to build a profession as Oracle Financial Developer? Then here is the blog post on, explore <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle Financial Training" href="https://tekslate.com/oracle-financials-training" target="_blank"><strong>Oracle Financial Training</strong></a></span></em></td>
</tr>
</tbody>
</table>
</blockquote>
<h3><span style="font-size: 18px; color: #e67e23;">6Q) What are the types of Flexfield Qualifiers?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>NATURAL ACCOUNT:</em> </strong></span>Each Accounting Flexfield structure must contain only one natural account segment. When setting up the values, you will indicate the type of account as Asset, Liability, Owner&rsquo;s Equity, Revenue, or Expense.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>BALANCING ACCOUNT:</em>&nbsp;</strong></span>Each Structure must contain only one balancing segment. Oracle GL ensures that all journal balances for each balancing segment.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong><em>COST CENTER:</em>&nbsp;</strong></span>This segment is required for Oracle Assets. The Cost centre segment is used in many Oracle Assets reports and by Oracle Workflow to generate account numbers. Also, <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle apps training" href="https://tekslate.com/oracle-apps-technical-training" target="_blank"><strong>Oracle apps training</strong></a> </span>Projects and Oracle Purchasing utilize the cost centre segment.</span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>INTERCOMPANY:&nbsp;</strong></span></em>GL automatically uses the intercompany segment in the account code combination to track intercompany transactions within a single set of books. This segment has the same value set and the same values as the balancing segment.</span></p>
<p style="text-align: justify;"><span style="color: #000000;"><em><span style="font-size: 14px;"><strong>Segment Qualifiers</strong></span></em></span></p>
<p style="text-align: left;"><span style="font-size: 14px;">ACCOUNT TYPE: Asset, Liability, Owner&rsquo;s Equity, Revenue, Expense, Budgetary Dr, and Budgetary Cr.</span></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 39px;">
<td style="width: 249.5px; height: 39px;"><span style="font-size: 14px;">Budget entry allowed</span></td>
<td style="width: 212.5px; height: 39px;"><span style="font-size: 14px;">(Yes/No)</span></td>
</tr>
<tr style="height: 37px;">
<td style="width: 249.5px; height: 37px;"><span style="font-size: 14px;">Posting allowed</span></td>
<td style="width: 212.5px; height: 37px;"><span style="font-size: 14px;">(Yes/No)</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Control Account Reconciliation Flag</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Available for specific countries</span></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px;">&nbsp;<span style="color: #e67e23;">7Q) What is the implication of dynamic insert?</span></span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px; color: #000000;">Dynamic Insertion is a feature that controls whether the user can enter new account code combinations from any form/window. If this feature is disabled, then the user cannot input new account code combinations from any window/form.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px; color: #000000;">Oracle applications use a particular form (called a Combination form) for directly entering the new code combinations. Users can enter new account code combinations only through this form if Dynamic Insertion is disabled.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q8"></a>8Q) What are Cross Validating Values?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>For key flexfields with multiple segments, we can define rules to cross-check value combinations entered within the key flexfield segments. This option is referred to as Cross Validation rules.</span></p>
<p style="text-align: left;"><em><span style="color: #000000; font-size: 14px;"><strong>Value Set List Types</strong></span></em></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 39px;">
<td style="width: 249.5px; height: 39px;"><span style="font-size: 14px;">List of values</span></td>
<td style="width: 212.5px; height: 39px;"><span style="font-size: 14px;">(10 to 200)</span></td>
</tr>
<tr style="height: 37px;">
<td style="width: 249.5px; height: 37px;"><span style="font-size: 14px;">A long list of values</span></td>
<td style="width: 212.5px; height: 37px;"><span style="font-size: 14px;">(&gt; 200)</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Poplist</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">(&gt; 10)</span></td>
</tr>
</tbody>
</table>
<p><span style="color: #000000; font-size: 14px;"><strong>Value Set Security Type</strong></span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>No Security:</strong></span> </em>All security is disabled for this value set.</span></p>
<p><span style="font-size: 14px;"><span style="color: #000000;"><em><strong>Hierarchical Security:</strong></em> </span>With Hierarchical security, the features of the value security and value hierarchies are combined. With this feature, any security that applies to a parent value also applies to its child values.</span></p>
<p><span style="font-size: 14px;"><em><span style="color: #000000;"><strong>Non-Hierarchical Security:</strong></span></em> Security is enabled, but the rules of hierarchical security do not apply. That is, a security rule that applies to a parent value does not &ldquo;cascade down&rdquo; to its child values.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">9Q) What are the types of Value Sets?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>Types of Value Sets:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>None:</strong></em>&nbsp;A value set of the type None has no list of approved values associated with it. A None value set performs only minimal checking of, for example, data type and length.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Independent:</strong></em>&nbsp;Independent type value sets perform basic checking but also check a value entered against the list of approved values you define.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Dependent:</strong></em> A dependent value set is associated with an independent value set. Dependent value sets ensure that all dependent values are associated with a value in the related independent value set.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Table:</strong></em> Table value sets obtain their lists of approved values from existing application tables. When defining your table value set, you specify a SQL query to retrieve all the approved values from the table.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><strong><em>Special:</em>&nbsp;</strong>This specialized value set provides another flexfield as a value set for a single segment.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Pair:&nbsp;</strong></em>This specialized value set provides a range of flexfield as a value set for a pair of segments.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Translated Independent:</strong></em> This works similar to the Independent type. However, a Translated Independent value set can contain display values that are translated into different languages.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;"><em><strong>Translated Dependent:</strong></em> This works similarly to the Dependent type. However, a Translated Dependent value set can contain display values that are translated into different languages.</span></li>
</ul>
<p>&nbsp;</p>
<h2><strong><span style="font-size: 24px; color: #236fa1;">Oracle Fusion Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q10"></a>10Q) How many segments are there in the key flexfield(s) in the oracle general ledger?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Oracle GL Key flexfield can have 15 columns each representing a segment. However, the segments type can be:</span></p>
<ul>
<li><span style="font-size: 14px;">Cost&nbsp;Center&nbsp;segment</span></li>
<li><span style="font-size: 14px;">Balancing segment</span></li>
<li><span style="font-size: 14px;">Account segment</span></li>
<li><span style="font-size: 14px;">Intercompany segment</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">11Q) On which entity is a security rule applicable?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>It&rsquo;s a feature of Key flexfield, applicable on Value Sets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">12Q) On which entity is the cross-validation rule applicable?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>It&rsquo;s a feature of Key flexfield, applicable on Value Sets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">13Q) Shorthand alias?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>An Alias is a label for a particular combination of key flexfield segment value. This allows users to enter data faster and more easily because the user has to just enter the shorthand alias, and the flexfield automatically populates the values for the segment.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q14"></a>14Q) What is a period in oracle gl?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A Period corresponds to a time span within which transactions are entered before finalizing, otherwise called as close of the period.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">15Q) What are the period types?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Predefined period types in Oracle GL are:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Month</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Quarter</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Year</span></li>
</ul>
<p style="text-align: justify;"><span style="font-size: 14px;">If needed, period types of our own can be defined in addition to the standard periods.</span></p>
<p style="text-align: right;"><span style="font-size: 14px;"><em>Checkout:&nbsp;</em>[ <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA Sample Project Creation" href="https://tekslate.com/projects" target="_blank"><em><strong>Oracle SOA Sample Project Creation</strong></em></a></span> ]</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">16Q) What are an adjusting period and its implications?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Typically, the last day of the fiscal year is used to perform adjusting and closing journal entries. This period is referred to as Adjusting Period.</span></p>
<p><span style="font-size: 14px;">Choosing whether to include an adjusting period or not in a calendar is a very important decision. There can be an unlimited number of adjusting periods. Once the accounting calendar is used, changes to its structure to remove or add an adjusting period cannot be done.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">17Q) How many types of conversion rates are there in oracle gl?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>There are 5 basic types of conversion rate types predefined in Oracle GL:</span></p>
<p><span style="font-size: 14px;"><strong>Spot:</strong>&nbsp;An exchange rate based on the rate for a specific date. It applies to the immediate delivery of a currency.</span></p>
<p><span style="font-size: 14px;"><strong>Corporate:</strong> An exchange rate that standardizes rates for your company. This rate is generally a standard market rate determined by senior financial management for use throughout the organization.</span></p>
<p><span style="font-size: 14px;"><strong>User:</strong>&nbsp;An exchange rate that you enter during foreign currency journal entry.</span></p>
<p><span style="font-size: 14px;"><strong>Emu Fixed:&nbsp;</strong>An exchange rate that is used by countries joining the EU during the transition period to the Euro currency.</span></p>
<p><span style="font-size: 14px;"><strong>User-Defined: </strong>A rate type defined by your company to meet specific needs.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">18Q) What type of conversion rate is required to be defined for all transactional purposes?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Spot (Not sure).</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">19Q) What are the three essential components of a gl set of books?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px; color: #000000;"><strong style="text-align: start;">Ans: </strong><span style="text-align: start;">The Essential components of gl set of books are:</span></span></p>
<p><em><span style="font-size: 14px;"><strong>Chart of Accounts:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. Your chart of accounts is the account structure you define to fit the specific needs of your organization.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. You can choose the number of account segments as well as the length, name, and order of each segment.</span></p>
<p><em><span style="font-size: 14px;"><strong>Accounting Calendar:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. An accounting calendar defines an accounting year and the periods it contains.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. You can define multiple calendars and assign a different calendar to each set of books.</span></p>
<p><em><span style="font-size: 14px;"><strong>Currencies:</strong></span></em></p>
<p style="text-align: justify;"><span style="font-size: 14px;">1. You select the functional currency for your set of books as well as other currencies that you use to transact business and report in.</span></p>
<p style="text-align: justify;"><span style="font-size: 14px;">2. GL converts monetary amounts entered in a foreign currency to functional currency equivalents using supplied rates.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">20Q) What is the implication of the &lsquo;future period&rdquo; field in the set of book definition forms?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>The value mentioned in the Future Period field represents the number of future enterable periods that users can use to input journal entries (provided those future periods are opened). However, consideration must be given to minimize the number of future enterable periods to prevent users from accidentally entering journal entries in an incorrect period.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">21Q) How many tabbed regions are there in the set of book definition form? What are the names of these tabbed regions?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>There are 5 tabbed regions in the set of a book's definition form.</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Closing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Journaling</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Average Balances</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Budgetary Control</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Multiple Reporting Currencies</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q22"></a>22Q) What is a retained earnings account?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL posts the net balance of all income and expenses accounts from the prior year to this account when you open the first period of a fiscal year.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">23Q) What is the purpose of the translation adjustment account?</span></h3>
<p style="text-align: left;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>If you translate your functional currency balances into another currency for reporting, or if you revalue foreign currency-dominated balances, you must specify a translation adjustment account.</span></p>
<table style="border-collapse: collapse; width: 100%; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr style="height: 38.9931px;">
<td style="width: 249.5px; height: 38.9931px;"><span style="font-size: 14px;">Parent</span></td>
<td style="width: 212.5px; height: 38.9931px;"><span style="font-size: 14px;">Do no enable</span></td>
</tr>
<tr style="height: 36.9965px;">
<td style="width: 249.5px; height: 36.9965px;"><span style="font-size: 14px;">Budget</span></td>
<td style="width: 212.5px; height: 36.9965px;"><span style="font-size: 14px;">Yes</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Posting</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Yes</span></td>
</tr>
<tr style="height: 40px;">
<td style="width: 249.5px; height: 40px;"><span style="font-size: 14px;">Account Type</span></td>
<td style="width: 212.5px; height: 40px;"><span style="font-size: 14px;">Ownership/Stock</span></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">24Q) What is the purpose of/unique feature of the net income account?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL uses this account to capture the net activity of all revenue and expense accounts when calculating the average balance for retained earnings.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">25Q) What is the purpose of the transaction calendar?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong>The transaction</span> calendar is defined to enable average balance processing. The transaction calendar is created optionally with valid business days mentioned.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">26Q) To allow unbalances journal posting what action is required at a set of book definition levels / what is a suspense account and its purpose?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>If you choose to allow posting of out-of-balance/unbalanced journal entries, GL automatically posts the difference to Suspense Account. However, the Suspense Account checkbox should be checked and an Account # to be provided for this feature to work during the creation of a set of books.</span></p>
<p><span style="font-size: 14px;">If you have multiple companies or balancing entities within a set of books, GL automatically creates a suspense account for each balancing entity.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">27Q) What is a value set?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A value set defines the boundaries for the attributes that you assign to a key or descriptive flexfield segment. Value sets control what types of values can be used as Accounting Flexfield segment values. Value sets determine the attributes of your segments such as length, zero-fill, and right justify, alphanumeric, and value security. Value sets also control how validation is performed.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">28Q) To allow intercompany journals what action is required at a set of book definition levels?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>One of the accounting key flexfield segments should be of the type Intercompany. This segment would have the same value set and the same values as the balancing segment.</span></p>
<p><span style="font-size: 14px;">Also, enable the Balance Intercompany Journals feature. This allows users to post out-of-balance intercompany journal entries and automatically balance those journal entries against a specified intercompany account. Select the Balance Intercompany Journal checkbox and enter the intercompany account(s) in the Intercompany Accounts window. If you do not enable this feature, you can only post intercompany journal entries that balance by balancing segment, (usually the company segment).</span></p>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q29"></a>29Q) What is Account Hierarchy Manager?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Account hierarchy manager is a feature provided by Oracle Application which allows to:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Graphically create, maintain, and review account structure hierarchies.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Define new parent and child segment values, as well as change parent/child dependencies.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Create new roll-up groups from the account hierarchy manager and have your changes reflected automatically in both key segment values and roll-up groups window.</span></li>
</ul>
<p style="text-align: justify;"><span style="font-size: 14px;">Also provides an option to control entities such as:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Read-only</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Read/write security</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Segment Value Security: An oracle applications feature that lets you exclude a segment value or ranges of segment values for a specific user responsibility. Segment Value Security is extended to the Account Hierarchy Manager.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Chart of Accounts Security</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">30Q) What does balance type &ldquo;a&rdquo; indicate?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not Sure. Maybe ACTUAL.</span></p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA EDN" href="https://tekslate.com/edn-event-delivery-network" target="_blank" rel="noopener"><strong>Oracle SOA EDN</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">31Q) How many buttons are there on the manual journal entry form? What are they?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>By default, there are 3 buttons on the manual journal entry form:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">More Details</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Change Currency</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">More Actions</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">32Q) How many buttons are there under the &ldquo;more actions&rdquo; button? What are they?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>When we click on the &ldquo;More Actions&rdquo; button, another window appears with 4 buttons:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Reverse Journal</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Post</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Change Period</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">CANCEL</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">33Q) What is the status of a newly entered journal?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Unposted.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Posting statuses.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Unposted</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Pending</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Processing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Selected for posting</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Posted</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Error</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">34Q) What is Journal Reversal Pre-Requisites?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">The journal balance type is Actual</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The Journal category has AutoReverse enabled</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The Journal is posted but not yet reversed</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The journal reversal period is open or future enterable</span></li>
</ul>
<p>&nbsp;</p>
<h2 id="advanced"><strong><span style="color: #236fa1; font-size: 24px;">Oracle Cloud Financials Interview Questions</span></strong></h2>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q35"></a>35Q) Can you create a journal entry with a parent segment value?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure. Maybe possible with a child value combined. Parent values automatically allow posting and budgeting.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">36Q) When a journal is created, which all gl tables are impacted?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans: </strong>The impacted gl tables are:</span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_BATCHES</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_HEADERS</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">GL_JE_LINES</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">37Q) When a journal is posted, which gl table is posted?</span></h3>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL_BALANCES&nbsp;</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">38Q) When journals are interfaced, which gl table is populated?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>GL_INTERFACE</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">39Q) What is the name of the concurrent to populate the gl tables from the interface table?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Journal Import.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">40Q) What is the mechanism to rectify a posted journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Reverse the Journal.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">41Q) What is the purpose of the state journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>You can associate statistical amounts with monetary amounts by using statistical units of measure.</span></p>
<p><span style="font-size: 14px;">This enables you to enter both monetary and statistical amounts in a single journal entry line.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">42Q) For the creation of periodically repetitive journals, what is the gl tool?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Recurring Journal.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">43Q) What is mass allocations?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>A single journal entry formula that allocates revenues and expenses across a group of cost centers, departments, or divisions.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">44Q) What is the formula for the creation of allocation journals?</span></h3>
<p><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans:&nbsp; &nbsp;</strong></span><strong>A*B/C</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">A is the Cost Pool that will be allocated. It can be an amount or account balance.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">B is the numerator of the factor (a number or statistical account) that multiplies the cost pool for the allocation.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">C is the denominator of the factor (a number or statistical account) that divides the cost pool for the allocation.</span></li>
</ul>
<p style="text-align: justify; padding-left: 20px;"><span style="font-size: 14px;">Note: Parent values can be used in one or more segments.</span></p>
<p style="text-align: justify;"><span style="color: #e67e23; font-size: 14px;"><strong>Account segment types for mass allocation.</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Looping</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Summing</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Constant</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">45Q) What are the target and offset accounts in the allocation formula?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>These are the lines that are the actual journal entry.</span></p>
<p><em><span style="font-size: 14px;"><strong>Target (T):</strong></span></em></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Enter an account in the Target line to specify the destination for your allocation.</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The parent value used in the target must be the same parent value used in the B and C lines of the formula.</span></li>
</ul>
<p><em><span style="font-size: 14px;"><strong>Offset (O):</strong></span></em></p>
<ul>
<li><span style="font-size: 14px;">Enter an account in the Offset line to specify the account to use for offsetting debit or credit from your allocation.</span></li>
<li><span style="font-size: 14px;">The Offset account is usually the same as formula line A to reduce the cost pool by the allocated amount.</span></li>
</ul>
<p>&nbsp;</p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="Oracle SOA Rejection handles" href="https://tekslate.com/rejection-handles" target="_blank"><strong>Oracle SOA Rejection handles</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3><span style="font-size: 18px; color: #e67e23;">46Q) Can you delete an unposted journal?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">47Q) Journals from which sub-ledger do not pass through the gl interface table?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Not sure. Maybe Assets.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">48Q) When the journals are interfaced and imported, what posting status do they have?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Unposted.</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">49Q) What is the pre-requisite for conversion?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Define new currencies</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Enable seeded currencies</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Define rate types</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Enter daily rates</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;">50Q) For revaluation, what rate types are available?</span></h3>
<p><span style="font-size: 14px; color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li style="text-align: justify;"><span style="font-size: 14px;">Daily rates</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">Historical rates</span></li>
<li style="text-align: justify;"><span style="font-size: 14px;">The revaluation rate is the inverse of the period-end rate.</span></li>
</ul>
<h3><span style="font-size: 18px; color: #e67e23;"><a id="q51"></a>51Q) How revaluation journals are created in which currency?</span></h3>
<p style="text-align: justify;"><span style="font-size: 14px;"><span style="color: #000000;"><strong>Ans: </strong></span>Functional currency</span></p>
<h3><span style="font-size: 18px; color: #e67e23;">52Q) Explain Flexfield Qualifiers In Gl?</span></h3>
<p><span style="font-size: 12pt;"><span style="color: #000000;"><strong>Ans: </strong></span><span style="font-size: 14px;">Need to assign qualifiers to individual accounting key flexfield segments to identify or represent the purpose of COA. Natural Account Each Accounting Flexfield structure must contain only one natural account segment. When setting up the values, you will indicate the type of account as Asset, Liability, Owner&rsquo;s Equity, Revenue, or Expense. Balancing Account Each structure must contain only one balancing segment. Oracle General Ledger ensures that all journal balances for each balancing segment. Cost Center This segment is required for Oracle Assets. The cost centre segment is used in many Oracle Assets reports and by Oracle Workflow to generate account numbers. Also, Oracle Projects and Oracle Purchasing utilize the cost centre segment. Intercompany General Ledger automatically uses the intercompany segment in the account code combination to track intercompany transactions within a single ledger. This segment has the same value set and the same values as the balancing segment.</span></span></p>
<h3><span style="font-size: 18px; color: #e67e23;">53Q) Discuss Primary Ledger Vs Secondary Ledger Vs Reporting Currency.</span></h3>
<p><strong><span style="font-size: 12pt; color: #000000;">Ans: Primary Ledger Vs Secondary Ledger:</span></strong></p>
<p><span style="font-size: 14px;">Use secondary ledgers for supplementary purposes, such as consolidation, statutory reporting, or adjustments for one or more legal entities within the same accounting setup. For example, use a primary ledger for corporate accounting purposes that use the corporate chart of accounts and subledger accounting method, and use a secondary ledger for statutory reporting purposes that use the statutory chart of accounts and subledger accounting method. This allows you to maintain both a corporate and statutory representation of the same legal entity&rsquo;s transactions in parallel.</span></p>
<p style="text-align: right;"><em>Checkout:</em> [ <span style="color: #236fa1;"><a style="color: #236fa1;" title=" How to provide a Security in Oracle SOA " href="https://tekslate.com/security" target="_blank"><strong><em>How to provide Security in Oracle SOA </em></strong></a></span>]</p>
<h2 id="financials"><strong><span style="color: #236fa1; font-size: 24px;">Oracle Finance Functional Consultant Interview Questions</span></strong></h2>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>54Q) What are the kinds of flex fields?</strong></span></h3>
<p><strong>Ans:</strong> There are two different kinds of flexfields they are:</p>
<p><em><strong>Key flexfield:</strong></em> A key flexfield is a field you can customize to insert multi-segment values such as account numbers, part numbers, etc. A descriptive flexfield means a field you customize to insert further information for which your Oracle Applications product has not already given a field.</p>
<p><em><strong>Descriptive flexfield:</strong></em> Descriptive flexfields give a method for implementers at customer sites to add custom attributes to entities, and to determine validation and show properties for them. A descriptive flexfield is a logical grouping of segments that are mapped to a set of database columns that serve as placeholders for custom attributes.&nbsp;</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>55Q) What are the advantages of flex fields?</strong></span></h3>
<p><span style="color: #000000;"><strong>Ans:</strong></span></p>
<ul>
<li>Flexfields enable the development of wise keys.</li>
<li>Utilizes the application to approve esteem.</li>
<li>Configure the applications to assist your bookkeeping.</li>
<li>Support various flex field structures depending upon the information setting.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">56Q) What is the symbol of DFF in the forms?</span></strong></span></h3>
<p><strong>Ans:</strong> Square bracket[] is the symbol of DFF in the forms.</p>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">57Q) How many segments are in AFF?</span></strong></span></h3>
<p><strong>Ans: </strong>The maximum number of segments in AFF is 30, and the minimum number of segments in AFF is 2.</p>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">58) What are the different types of flexfield qualifiers?</span></strong></span></h3>
<p><strong>Ans:</strong> There are four different types of flexfield qualifiers they are:</p>
<ul>
<li>Cost centre segment qualifier&nbsp;</li>
<li>Balancing segment qualifier&nbsp;</li>
<li>Intercompany segment qualifier&nbsp;</li>
<li>Natural account segment qualifier&nbsp; &nbsp;</li>
</ul>
<h3 dir="ltr" role="presentation"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">59Q) What tables store Currency and period type names?</span></strong></span></h3>
<p><strong>Ans: </strong></p>
<ul>
<li>Currency -- FND_CURRENCIES&nbsp;</li>
<li>Period -- GL_PERIOD_STATUSES</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">60Q) What are the different types of calendars?&nbsp;</span></strong></span></h3>
<p><strong>Ans: </strong>There are two different types of calendars they are</p>
<p><em><strong>Fiscal calendar:</strong></em> A fiscal year is a 12-month period utilized by organizations and governments for financial reporting plus budgeting that sometimes follows the January - December calendar year and sometimes does not.</p>
<p><em><strong>Accounting:</strong></em> The accounting calendar determines the start and end of your fiscal year and the time periods within that calendar, including the specific dates for each time period. Your sales application utilizes these defined periods, frequently called enterprise periods, for multiple purposes.&nbsp;</p>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Latest Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="JMS in Oracle SOA 11g" href="https://tekslate.com/jms-java-messaging-service11g" target="_blank"><strong>JMS in Oracle SOA 11g</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><a id="q61"></a>61Q) Explain a profile and list the types of profiles.</span></h3>
<p><strong>Ans:</strong> A profile is a changeable option that influences the way your application runs. There are two types of profiles.</p>
<ul>
<li>User-defined&nbsp;</li>
<li>System defined&nbsp;</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">62Q) Explain about the period, and what are the different types of periods?</span></h3>
<p><strong>Ans: </strong>A Period correlates to a period range within which exchanges are entered preceding finishing, usually called as close of the period, predefined period types are.</p>
<ul>
<li>Month</li>
<li>Quarter&nbsp;</li>
<li>Year</li>
</ul>
<h3 dir="ltr" role="presentation"><span style="font-size: 18px;"><strong><span style="color: #e67e23;">63Q) What are the different types of change rates in Oracle gl?</span></strong></span></h3>
<p><strong>Ans:</strong> There are five different types of change rates in oracle gl they are:</p>
<ul>
<li><strong>Detect:</strong>&nbsp;A swapping scale dependent upon the rate for a specific date. It refers to the prompt conveyance of money.&nbsp;</li>
<li><strong>Corporate:</strong> A swapping scale that institutionalizes rates for your business. This rate is usually a standard market rate managed by senior money-related administration for use all over the association.</li>
<li><strong>Client: </strong>A conversion scale that you enter significantly outside the cash diary section.</li>
<li><strong>Emu Fixed:</strong> A conversion scale that is used by nations joining the EU among the progress time frame to the Euro cash.</li>
<li><strong>Client Defined:</strong> A rate type characterized by your business to address explicit issues.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><strong>64Q) Explain a held income account.</strong></span></h3>
<p><strong>Ans: </strong>GL posts the net equalization of all pay and costs accounts from the earlier year to this record when you open the main time of a financial year.</p>
<h3><span style="font-size: 18px;"><strong><span style="color: #e67e23;">65Q) Explain an esteemed set.</span></strong></span></h3>
<p><strong>Ans:</strong> An esteem set characterizes the limits for the attributes which you dole out to a key or descriptive flexfield fragment. Esteem sets control of what kinds of qualities can be used as Accounting Flexfield section esteems. Esteem sets determine the properties of your sections, for example, zero-fill, length, and right legitimize, alphanumeric, and esteem security.</p>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">66Q) Explain the journal import.</span></h3>
<p><strong>Ans:</strong> Journal import is the name of the concurrent to populate the gl table from the interface tables.</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>67Q) What is the use of the state journal?</strong></span></h3>
<p><strong>Ans: </strong></p>
<p>You can join factual sums with financial sums by using factual units of measure.</p>
<p>This enables you to enter both fiscal plus measurable sums within a solitary diary section line.</p>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">68Q) What is a Recurring journal?</span></h3>
<p><strong>Ans: </strong>The recurring journal is the gl tool that is used to create periodically repetitive journals.</p>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong>69Q) List the types of record segments for mass allocation.</strong></span></h3>
<p><strong>Ans:</strong>&nbsp;</p>
<ul>
<li>Circling</li>
<li>Summing</li>
<li>Consistent &nbsp;&nbsp;</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;"><strong><a id="q70"></a>70Q) List the necessary tables in GL.</strong></span></h3>
<ul>
<li>GL_JE_BATCHES</li>
<li>GL_JE_HEADERS</li>
<li>GL_JE_LINES</li>
<li>GL_BALANCES</li>
<li>GL_SETS_OF_BOOKS</li>
<li>GL_CODE_COMBINATIONS</li>
<li>GL_PERIOD_STATUES</li>
<li>GL_INTERFACE</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">71Q) In which table supplier's information is stored?</span></h3>
<p><strong>Ans: </strong>Suppliers information can be found in the following tables:</p>
<ul>
<li>PO_VENDORS</li>
<li>PO_VENDOR_SITES_ALL</li>
<li>PO_VENDOR_CONTACTS</li>
</ul>
<h3><span style="color: #e67e23; font-size: 18px;"><strong>72Q) What is the formula used to create allocation journals?</strong></span></h3>
<p><strong>Ans:</strong> A*B/C.</p>
<ul>
<li>A is the Cost Pool that will be distributed. It manages to be a sum or record balance.</li>
<li>B is the numerator of the factor that replicates the cost pool for the designation.</li>
<li>C is the denominator of the factor which separates the cost pool for the distribution.</li>
</ul>
<h3 dir="ltr"><span style="font-size: 18px; color: #e67e23;">73Q) Difference between kff and dff?</span></h3>
<p><strong>Ans: </strong></p>
<p><em><strong>KFF:</strong></em></p>
<ul>
<li>KFF is a unique identifier.</li>
<li>KFF is stored in the segment column.</li>
</ul>
<p><em><strong>DFF:</strong></em></p>
<ul>
<li>DFF is used to capture additional information.</li>
<li>DFF is stored in an attribute column.</li>
</ul>
<h3 dir="ltr"><span style="color: #e67e23; font-size: 18px;"><strong><a id="q74"></a>74Q) What are Oracle financial modules?</strong></span></h3>
<p><strong>Ans: </strong>Six important Oracle financials modules are:</p>
<ul>
<li>Oracle Assets&nbsp;</li>
<li>Oracle Payables</li>
<li>Oracle General Ledger</li>
<li>Oracle Cash Management&nbsp;</li>
<li>Oracle receivables&nbsp;</li>
<li>Oracle Tabs</li>
</ul>
<table style="border-collapse: collapse; width: 100%; height: 58px; background-color: #ecf0f1; border-color: #CED4D9; border-style: solid;" border="1px" cellpadding="5">
<tbody>
<tr>
<td style="width: 98.4956%; text-align: center;"><em>Checkout Our Blog on <span style="color: #236fa1;"><a style="color: #236fa1;" title="How to work with FTP in Oracle SOA" href="https://tekslate.com/ftpfile-transfer-protocol" target="_blank"><strong>How to work with FTP in Oracle SOA</strong></a></span></em></td>
</tr>
</tbody>
</table>
<h3 style="text-align: justify;"><span style="color: #e67e23; font-size: 18px;"><strong>Different statuses of an accounting period.</strong></span></h3>
<p><span style="font-size: 12pt;"><strong>Ans:<span style="font-size: 14px;"> </span></strong><span style="font-size: 14px;">The different statuses are:</span></span></p>
<p><span style="font-size: 14px;"><strong>1) <em>Never Opened:</em> </strong>Cannot enter or post journals.</span></p>
<p><span style="font-size: 14px;"><strong>2) <em>Future Enterable:</em> </strong>Enter journal, but cannot post. The number of future enterable periods is a fixed number defined in the set of books window. The number of the future enterable period can be changed at any time.</span></p>
<p><span style="font-size: 14px;"><strong>3) <em>Open:</em> </strong>Enter and port journals to any open period. An unlimited number of periods can be opened, but doing so may slow the posting process and can confuse users entering journals.</span></p>
<p><span style="font-size: 14px;"><strong>4) <em>Closed:</em> </strong>Cannot post journals in a closed period. Must reopen closed periods before posting journals. Should manually close periods after finishing month/quarter/year-end processing.</span></p>
<p><span style="font-size: 14px;"><strong>5) <em>Permanently Closed:</em> </strong>Permanently closed periods cannot be reopened. This status is required to Archive and Purge data.</span></p>
<p>&nbsp;</p>
<h3><span style="color: #e67e23; font-size: 20px;"><strong>Conclusion:&nbsp;</strong></span></h3>
<p>Use Oracle Financials applications to better accomplish the business to the targets that are published to investors. Management can adequately report to investors and colleagues. Oracle Financials applications also assist you to meet your responsibilities in key areas encompassing the numbers, such as Compliance. If you want to know more please enrol on the course.&nbsp;</p>f:{"id":1,"author_designation":"Content Writer","author_name":"TekSlate","author_bio":"<p>TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.</p>","author_img":"https://tekslateassets.s3.amazonaws.com/images/logo.svg","author_url":"tekslate","article_count":"0","field_of_intrest":"","status":1}
11:{"id":344,"views":9437,"rating":4.2,"title":"Oracle Financials Interview Questions","url_title":"oracle-financials-interview-questions-and-answers"}
12:{"id":356,"views":1783,"rating":4.4,"title":"Oracle Project Accounting Interview Questions","url_title":"oracle-project-accounting-interview-questions"}
13:{"id":778,"views":1001,"rating":4.4,"title":"Displaying Images on OAF Page","url_title":"displaying-images-page"}
14:{"id":873,"views":877,"rating":4,"title":"Oracle BAM","url_title":"oracle-bam"}
10:["$11","$12","$13","$14"]
16:{"id":4,"blog_id":416,"blog_title":"Embedded Systems Interview Questions","blog_url_title":"interview-questions-on-embedded-systems","order_value":5,"views":1547}
17:{"id":5,"blog_id":1237,"blog_title":"Types of Pointers in C","blog_url_title":"explain-different-types-pointers-c-language","order_value":6,"views":14352}
18:{"id":6,"blog_id":391,"blog_title":"Oracle Procure To Pay Interview Questions","blog_url_title":"interview-questions-on-oracle-procure-to-pay","order_value":1,"views":4352}
19:{"id":7,"blog_id":1216,"blog_title":"Characteristics of C Language","blog_url_title":"characteristics-of-c-language","order_value":2,"views":10834}
1a:{"id":8,"blog_id":939,"blog_title":"Salesforce Sample Triggers with different Scenarios","blog_url_title":"15-sample-triggers-different-scenarios","order_value":3,"views":11712}
1b:{"id":9,"blog_id":344,"blog_title":"Oracle Financials Interview Questions","blog_url_title":"oracle-financials-interview-questions-and-answers","order_value":4,"views":9437}
1c:{"id":10,"blog_id":441,"blog_title":"Service Desk Analyst Interview Questions","blog_url_title":"interview-questions-on-service-desk-analyst","order_value":7,"views":5421}
1d:{"id":11,"blog_id":381,"blog_title":"SAP OOPS ABAP Interview Questions","blog_url_title":"interview-questions-on-sap-oops-abap","order_value":8,"views":5421}
1e:{"id":12,"blog_id":380,"blog_title":"SAP Adobe Forms Interview Questions","blog_url_title":"interview-questions-on-sap-adobe-forms","order_value":9,"views":1875}
1f:{"id":13,"blog_id":2079,"blog_title":"Power Apps Interview Questions","blog_url_title":"powerapps-interview-questions","order_value":10,"views":7541}
15:["$16","$17","$18","$19","$1a","$1b","$1c","$1d","$1e","$1f"]
21:{"id":63,"course":"PeopleSoft HRMS Training","rating":"4.9","enrolled":"5422","url_title":"peoplesoft-hrms-training"}
22:{"id":73,"course":"Microsoft Dynamics 365 Training","rating":"4.6","enrolled":"265","url_title":"microsoft-dynamics-365-training"}
23:{"id":88,"course":"NetSuite Training","rating":"4.9","enrolled":"5773","url_title":"netsuite-training"}
24:{"id":89,"course":"Peoplesoft Admin Training","rating":"4.5","enrolled":"1983","url_title":"peoplesoft-admin-training"}
25:{"id":96,"course":"Oracle Fusion Financials Training","rating":"4.9","enrolled":"2182 ","url_title":"oracle-fusion-financials-training"}
26:{"id":102,"course":"Microsoft Dynamics AX Training","rating":"4.9","enrolled":"6394","url_title":"microsoft-dynamics-ax-training"}
27:{"id":106,"course":"Workday Training","rating":"4.9","enrolled":"4098","url_title":"workday-training"}
28:{"id":112,"course":"Oracle Fusion HCM Cloud Training","rating":"4.8","enrolled":"5768","url_title":"oracle-fusion-hcm-training"}
29:{"id":115,"course":"Oracle Financials Training","rating":"4.8","enrolled":"5789","url_title":"oracle-financials-training"}
2a:{"id":133,"course":"Oracle HRMS Training","rating":"4.9","enrolled":"5738","url_title":"oracle-hrms-training"}
2b:{"id":144,"course":"Oracle EBS Training","rating":"4.7","enrolled":"233","url_title":"oracle-ebs-training"}
2c:{"id":166,"course":"Workday HCM Training","rating":"4.7","enrolled":"1333 ","url_title":"workday-hcm-training"}
2d:{"id":182,"course":"Workday Payroll Training","rating":"4.9","enrolled":"2473","url_title":"workday-payroll-training"}
2e:{"id":186,"course":"Oracle Project Accounting Training","rating":"4.5","enrolled":"340","url_title":"oracle-project-accounting-training"}
2f:{"id":194,"course":"Peoplesoft Financials Training","rating":"4.6","enrolled":"2643","url_title":"peoplesoft-financials-training"}
20:["$21","$22","$23","$24","$25","$26","$27","$28","$29","$2a","$2b","$2c","$2d","$2e","$2f"]
30:{"id":883,"name":"Oracle Financials Interview Questions And Answers","slug":"oracle-financials-interview-questions-and-answers","type":"articles","status":1}
d:{"id":344,"blog_category":70,"blog_type":2,"wp_id":1,"excerpt":"","table_of_content":"","description":"$e","title":"Oracle Financials Interview Questions","url_title":"oracle-financials-interview-questions-and-answers","image_url":"https://newtekslateassets.s3.us-west-2.amazonaws.com/wp-content/uploads/articles/oracle-fusion-financials-interview-questions-10032023.png","meta_title":"TOP 70 Oracle Financial Interview Questions (2023)","meta_desc":"Looking for Oracle Fusion Financial Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies","views":9437,"rating":4.2,"author":"1","top_level_cat_id":"5","author_desc":"","course_id":"115","created_at":"2016-10-19T11:01:04.000Z","updated_at":"2021-04-07T10:34:29.000Z","status":1,"video_schema_name":"","video_schema_upload_date":"","video_schema_description":"","faq_schema_q1":"","faq_schema_a1":"","faq_schema_q2":"","faq_schema_a2":"","faq_schema_q3":"","faq_schema_a3":"","like_counter":25,"author_details":"$f","related_blogs":"$10","recommended_articles":"$15","recommended_programs":"$20","category_name":"Oracle Financials","category_url":"oracle-financials","type_d":"$30"}
2:["$","$Lb",null,{"rohit":{"trending":{"id":344,"blog_category":70,"blog_type":2,"wp_id":1,"excerpt":"","table_of_content":"","description":"$c","title":"Oracle Financials Interview Questions","url_title":"oracle-financials-interview-questions-and-answers","image_url":"https://newtekslateassets.s3.us-west-2.amazonaws.com/wp-content/uploads/articles/oracle-fusion-financials-interview-questions-10032023.png","meta_title":"TOP 70 Oracle Financial Interview Questions (2023)","meta_desc":"Looking for Oracle Fusion Financial Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies","views":9437,"rating":4.2,"author":"1","top_level_cat_id":"5","author_desc":"","course_id":"115","created_at":"2016-10-19T11:01:04.000Z","updated_at":"2021-04-07T10:34:29.000Z","status":1,"video_schema_name":"","video_schema_upload_date":"","video_schema_description":"","faq_schema_q1":"","faq_schema_a1":"","faq_schema_q2":"","faq_schema_a2":"","faq_schema_q3":"","faq_schema_a3":"","like_counter":25,"author_details":{"id":1,"author_designation":"Content Writer","author_name":"TekSlate","author_bio":"<p>TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.</p>","author_img":"https://tekslateassets.s3.amazonaws.com/images/logo.svg","author_url":"tekslate","article_count":"0","field_of_intrest":"","status":1},"related_blogs":[{"id":344,"views":9437,"rating":4.2,"title":"Oracle Financials Interview Questions","url_title":"oracle-financials-interview-questions-and-answers"},{"id":356,"views":1783,"rating":4.4,"title":"Oracle Project Accounting Interview Questions","url_title":"oracle-project-accounting-interview-questions"},{"id":778,"views":1001,"rating":4.4,"title":"Displaying Images on OAF Page","url_title":"displaying-images-page"},{"id":873,"views":877,"rating":4,"title":"Oracle BAM","url_title":"oracle-bam"}],"recommended_articles":[{"id":4,"blog_id":416,"blog_title":"Embedded Systems Interview Questions","blog_url_title":"interview-questions-on-embedded-systems","order_value":5,"views":1547},{"id":5,"blog_id":1237,"blog_title":"Types of Pointers in C","blog_url_title":"explain-different-types-pointers-c-language","order_value":6,"views":14352},{"id":6,"blog_id":391,"blog_title":"Oracle Procure To Pay Interview Questions","blog_url_title":"interview-questions-on-oracle-procure-to-pay","order_value":1,"views":4352},{"id":7,"blog_id":1216,"blog_title":"Characteristics of C Language","blog_url_title":"characteristics-of-c-language","order_value":2,"views":10834},{"id":8,"blog_id":939,"blog_title":"Salesforce Sample Triggers with different Scenarios","blog_url_title":"15-sample-triggers-different-scenarios","order_value":3,"views":11712},{"id":9,"blog_id":344,"blog_title":"Oracle Financials Interview Questions","blog_url_title":"oracle-financials-interview-questions-and-answers","order_value":4,"views":9437},{"id":10,"blog_id":441,"blog_title":"Service Desk Analyst Interview Questions","blog_url_title":"interview-questions-on-service-desk-analyst","order_value":7,"views":5421},{"id":11,"blog_id":381,"blog_title":"SAP OOPS ABAP Interview Questions","blog_url_title":"interview-questions-on-sap-oops-abap","order_value":8,"views":5421},{"id":12,"blog_id":380,"blog_title":"SAP Adobe Forms Interview Questions","blog_url_title":"interview-questions-on-sap-adobe-forms","order_value":9,"views":1875},{"id":13,"blog_id":2079,"blog_title":"Power Apps Interview Questions","blog_url_title":"powerapps-interview-questions","order_value":10,"views":7541}],"recommended_programs":[{"id":63,"course":"PeopleSoft HRMS Training","rating":"4.9","enrolled":"5422","url_title":"peoplesoft-hrms-training"},{"id":73,"course":"Microsoft Dynamics 365 Training","rating":"4.6","enrolled":"265","url_title":"microsoft-dynamics-365-training"},{"id":88,"course":"NetSuite Training","rating":"4.9","enrolled":"5773","url_title":"netsuite-training"},{"id":89,"course":"Peoplesoft Admin Training","rating":"4.5","enrolled":"1983","url_title":"peoplesoft-admin-training"},{"id":96,"course":"Oracle Fusion Financials Training","rating":"4.9","enrolled":"2182 ","url_title":"oracle-fusion-financials-training"},{"id":102,"course":"Microsoft Dynamics AX Training","rating":"4.9","enrolled":"6394","url_title":"microsoft-dynamics-ax-training"},{"id":106,"course":"Workday Training","rating":"4.9","enrolled":"4098","url_title":"workday-training"},{"id":112,"course":"Oracle Fusion HCM Cloud Training","rating":"4.8","enrolled":"5768","url_title":"oracle-fusion-hcm-training"},{"id":115,"course":"Oracle Financials Training","rating":"4.8","enrolled":"5789","url_title":"oracle-financials-training"},{"id":133,"course":"Oracle HRMS Training","rating":"4.9","enrolled":"5738","url_title":"oracle-hrms-training"},{"id":144,"course":"Oracle EBS Training","rating":"4.7","enrolled":"233","url_title":"oracle-ebs-training"},{"id":166,"course":"Workday HCM Training","rating":"4.7","enrolled":"1333 ","url_title":"workday-hcm-training"},{"id":182,"course":"Workday Payroll Training","rating":"4.9","enrolled":"2473","url_title":"workday-payroll-training"},{"id":186,"course":"Oracle Project Accounting Training","rating":"4.5","enrolled":"340","url_title":"oracle-project-accounting-training"},{"id":194,"course":"Peoplesoft Financials Training","rating":"4.6","enrolled":"2643","url_title":"peoplesoft-financials-training"}],"category_name":"Oracle Financials","category_url":"oracle-financials","type_d":{"id":883,"name":"Oracle Financials Interview Questions And Answers","slug":"oracle-financials-interview-questions-and-answers","type":"articles","status":1}},"type":"articles","categories":[]},"data":"$d"}]
a:[["$","meta","0",{"name":"viewport","content":"width=device-width, initial-scale=1"}],["$","meta","1",{"charSet":"utf-8"}],["$","title","2",{"children":"TOP 70 Oracle Financial Interview Questions (2023)"}],["$","meta","3",{"name":"description","content":"Looking for Oracle Fusion Financial Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies"}],["$","meta","4",{"name":"application-name","content":"tekslatetutor"}],["$","meta","5",{"name":"generator","content":"tekslatetutor"}],["$","link","6",{"rel":"canonical","href":"https://tekslate.com/oracle-financials-interview-questions-and-answers"}],["$","meta","7",{"property":"og:title","content":"TOP 70 Oracle Financial Interview Questions (2023)"}],["$","meta","8",{"property":"og:description","content":"Looking for Oracle Fusion Financial Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies"}],["$","meta","9",{"property":"og:url","content":"https://tekslate.com/oracle-financials-interview-questions-and-answers"}],["$","meta","10",{"property":"og:site_name","content":"tekslatetutor"}],["$","meta","11",{"property":"og:locale","content":"en_US"}],["$","meta","12",{"property":"og:image","content":"https://newtekslateassets.s3.us-west-2.amazonaws.com/wp-content/uploads/articles/oracle-fusion-financials-interview-questions-10032023.png"}],["$","meta","13",{"property":"og:image:width","content":"1200"}],["$","meta","14",{"property":"og:image:height","content":"628"}],["$","meta","15",{"property":"og:type","content":"website"}],["$","meta","16",{"name":"twitter:card","content":"summary"}],["$","meta","17",{"name":"twitter:creator","content":"@tekslatetutor"}],["$","meta","18",{"name":"twitter:title","content":"TOP 70 Oracle Financial Interview Questions (2023)"}],["$","meta","19",{"name":"twitter:description","content":"Looking for Oracle Fusion Financial Interview Questions with Answers? Here we have compiled set of questions from the students who have attended interviews in Fortune 500 companies"}],["$","meta","20",{"name":"twitter:image","content":"https://newtekslateassets.s3.us-west-2.amazonaws.com/wp-content/uploads/articles/oracle-fusion-financials-interview-questions-10032023.png"}],["$","link","21",{"rel":"icon","href":"https://tekslateassets.s3.amazonaws.com/images/favicon.svg"}]]
1:null
