SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreSyntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreStep 1: Navigation: US AR SetupUser à Iron Source Bill Code MappingàEnter the Source->Operating Unit->Bill Code-> Modifiy the Code Combination-> Save
Read MorePurpose: Need to assign the responsibility which we created last sheet to the specific user ID Navigation: System Administrator > Security > User > Define Step 1: Query the…
Read MoreTo Create New AutoAccounting in Oracle Apps R12: Define AutoAccounting to specify the general ledger accounts for transactions that you enter manually or import using Auto Invoice. AutoAccounting helps to…
Read MoreCreate Oracle Chart of Accounts Setup We will share the detail steps to implement the chart of accounts in oracle. We will share the complete configuration details for oracle chart of accounts. We do create the chart of…
Read MoreWithholding tax: Withholding tax is an amount of which deduction takes place directly from the earning of an employee by the employer. It is paid to the government as…
Read MoreCreate the Payment Method in Oracle Apps r12 The Payment Method we do create for supplier payments. As per our requirement, we can create the new payment methods for the…
Read MoreEnable Sequential Numbering Profile Option The profile option Sequential Numbering must be enabled in order to use the Document Sequence feature. This can be set at the site, application or responsibility level. Valid…
Read MorePlease make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read More