Home
Videos uploaded by user “Oracle EBS Hands-On”
How to Refund/Return an AP Prepayment in Oracle Payables (eBS)?
 
05:42
There are situations when your supplier is returning your prepayment (advance payment) and you have to reflect this transaction in your bank statement. I. How can we cover this flow in Oracle eBS Payables (AP)? Solution I always suggested is: 1. Create a mixed invoice for supplier that is returning your prepayment 2. Create a line with amount 0 3. Apply prepayment by checking both Apply and Prepayment on Invoice checkboxes 4. Validate mixed invoice 5. Pay mixed invoice using a Refund payment type from your bank account
Views: 13274 Oracle EBS Hands-On
How to setup default template for an Oracle eBS report with multiple templates?
 
04:44
When you create multiple XML/BI publisher templates for same report in Oracle eBS, end user is requesting a specific template to be the default one. In this video I show a short example how to fulfill this requirement. Steps: Step 1 - Get short name for Payables Posted Payment Register report Step 2 - Create a new template for Payables Posted Payment Register report Step 3 - Verify if new template is visible for Payables Posted Payment Register Step 4- Set up new template as default for Payables Posted Payment Register Step 5 - test that new template will be as default when report is run
Views: 3104 Oracle EBS Hands-On
How to connect to Oracle Cloud Database using SQL Developer?
 
03:15
As cloud is already our neighbor I was interested to find more about what Oracle provide as a trial for people interested about this topic. I was happy to find https://cloud.oracle.com/tryit site where you can register and in few days you have access to an Oracle Database in the Cloud. As per above site quote "Oracle Database Cloud Service provides the power and flexibility of the Oracle Database in the cloud with your choice of a dedicated database instance with direct network connections and full administrative control, or a dedicated schema with a full development and deployment platform managed by Oracle." Another trigger that make me investigate more about Oracle Database in cloud was Sql Developer version 4.0.2.15 that has Cloud Connections options. In this video I'll show how easy is to access and browse Oracle Database in cloud using SQL Developer 4.0.2.15
Views: 6274 Oracle EBS Hands-On
How to sweep AR (Receivables) transactions that are in accounting error in Oracle EBS 12.1 or 12.2
 
10:22
This functionality was known for Oracle Payables module but not for Receivables. I'm sure most of you will be happy mainly if you have struggled in the past to close Receivable accounting period on time but due to various accounting errors that was not possible. AR sweep functionality is now available only for transactions that are in accounting error (xla_events table - fields event_status_code = U and process_status_code = I) and can be enabled after below patches are applied. For other interesting tips go to http://oracle-ebs-hands-on.blogspot.com
Views: 4384 Oracle EBS Hands-On
How to setup and use Depreciation Override in Oracle EBS Fixed Assets in R12?
 
08:35
In this video I walk trough below scenarios: - compare monthly depreciation before and after override - correct/modify override depreciation value - close month and make sure depreciation value is same with one before override (This is true only if depreciation is calculated cost / life in months; if depreciation is calculated Net Book Value / remaining life in months depreciation value will be different). For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 5801 Oracle EBS Hands-On
How to Create a Credit Memo From an Existing Invoice (Oracle eBS R12)?
 
02:58
This post is about quick credit functionality from Accounts Payables (AP) invoice workbench that may be used to created a supplier Credit Memo using an existing standard invoice. This functionality will automatically create credit memo lines by reversing standard invoice lines and inherit GL accounts. The demo below will show how to: 1. create a standard Accounts Payables (AP) invoice 2. create credit memo by quick credit functionality base on invoice created at step 1 3. compare invoice and credit memo lines For more tips fill free to visit http://oracle-ebs-hands-on.blogspot.cz/
Views: 14083 Oracle EBS Hands-On
How to Validate and Create Accounting for Multiple Invoices from AP Invoice Workbench?
 
03:37
At month-end, when you find few new AP invoices entered and you want to validate and create accounting for all together you may do it directly from AP invoice workbench instead of running the standard concurrent requests (Invoice Validation and Create Accounting program). More tips on
Views: 3279 Oracle EBS Hands-On
How to Use Tax Control Amount Functionality When Enter an Invoice?
 
03:44
So often your company is receiving invoices with tax (VAT) amount calculated differently than your Oracle eBS Tax engine. This may happen due to: - the way your customer is rounding the value for tax (VAT) and differences are small - your customer send you invoice with wrong tax (VAT) amount - eTax engine is not configurator properly For all above cases you have to record tax (VAT) from supplier invoice. How to achieve this without pain? Solution: enter invoice total tax (VAT) amount into tax control amount field from invoice header level. More Oracle e-Business Suite tips on http://oracle-ebs-hands-on.blogspot.com
Views: 1818 Oracle EBS Hands-On
How to use MS Excel to create or modify Oracle EBS Purchase Order Lines?
 
13:33
Starting with Oracle EBS release 12.2.4 users may use Microsoft Excel (WebADI) functionality to create or modify Purchase Order Lines, Schedules and Distributions. This information is from Oracle Procurement Releases 12.1 and 12.2 (inclusive of 12.0.2 – 12.0.7) document version 5.1 published on July 28, 2014. At the PO Header level users can create or update lines, schedules and distributions in Excel and import these additions into the document. This feature may also be used at the line, schedule, pay item and distribution levels. In this video I'm demonstrating how to use Microsoft Excel (Office 365) to create a new line for an existing Purchase Order (PO) and also to change price and quantity for existing PO lines. This option is accessible only under Buyer Work Center (BWC) - Purchasing responsibility for all PO levels - header, lines, schedules and distributions. Based on the level you access "Update with Excel" option a different Excel template will be downloaded and displayed fields will be specific to each level (line, schedule, distribution). For this demonstration I have used the E-Business Suite 12.2.4 VM Virtual Appliances provided by Oracle Software Delivery Cloud (https://edelivery.oracle.com/linux) For other interesting tips go to http://oracle-ebs-hands-on.blogspot.com
Views: 3153 Oracle EBS Hands-On
How to use Accounts Payables (AP) invoice recurring functionality in Oracle eBS 12.2.3?
 
05:00
It's a common practice for most companies to receive on a monthly bases supplier invoices for rent, leasing and utilities. Most of the time these invoices have same amount. To streamline the invoices entering process Oracle eBS Accounts Payables (AP) provides as standard feature - recurring invoice functionality.
Views: 4241 Oracle EBS Hands-On
How to update Supplier bank or Supplier bank branch details in Oracle EBS R12?
 
06:49
I’m sure you will find this demo very useful as it’s showing the correct way to update supplier bank and supplier bank branch details in Oracle EBS Release 12. For other interesting tips go to http://oracle-ebs-hands-on.blogspot.com
Views: 1736 Oracle EBS Hands-On
How to Change Life Years Field for an Asset in Oracle EBS R12 or R11 Using API?
 
04:50
FA_API_FA_ADJUSTMENT_PUB.DO_ADJUSTMENT API may be used to process changes to existing fixed assets when number of records is very high. Using this API you may change different information (fields) in both releases R11 or R12. The main difference between releases is that in R12 you do not need below parameter which is required for R11. -- px_inv_rate_tbl To get API sample used go to http://oracle-ebs-hands-on.blogspot.com/2014/06/how-to-change-life-years-field-for.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1791 Oracle EBS Hands-On
How to Create Supplier Bank, Branch and Bank Account Using APIs in Oracle eBS R12?
 
05:16
Data migration is always a pain task for all ERP implementation projects because of both data quality and migration scripts/available interfaces. eBusiness Suite provides for important metadata and transactions either standard interface option or APIs (Application programming interfaces). In this post I'll show to you how to use supplier bank APIs in case your client is providing you supplier banks details after you already migrated all supplier data. Supplier bank APIs are: IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH IBY_EXT_BANKACCT_PUB.CREATE_BANK_ACCT IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment For download go to http://oracle-ebs-hands-on.blogspot.cz/2014/06/how-to-create-supplier-bank-branch-and.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 4988 Oracle EBS Hands-On
How to use Account Hierarchy Manager to maintain account structure in Oracle eBS GL?
 
06:01
I found Account Hierarchy Manager feature as a friendly and more flexible way to maintain accounting flex field structure for both adding new child or parent values to hierarchy and changing hierarchy structure. Hierarchy export functionality is also included in case you need to save for later reference or for offline review. For those interested about this subject I create below video following next steps: Step 1 - Open Account Hierarchy Manager (AHM) under GL responsibility Step 2 - Select desired account structure and open natural account segment Step 3 - Move child values from one parent to a different parent Step 4 - Arrange your screen for a better view over values properties Step 5 - Create a new account under an existing parent Step 6 - Export hierarchy for selected parent Step 7 - Drag and drop child between hierarchies Step 8 - Just checking that changes are visible into standard screen Account Hierarchy Manager setup overview For other interesting post visit http://oracle-ebs-hands-on.blogspot.com
Views: 3128 Oracle EBS Hands-On
Overview of Oracle EBS R12.2 Bank Payment Acknowledgement Processing in Payments Module
 
16:49
In this post I'm showing the EBS Payment Acknowledgement functionality delivered by Oracle starting with Release 12.2, or higher. To prepare this demo I have used Oracle Support note 1493240.1 - R12.2: Bank Payment Acknowledgement Processing in Oracle Payments/Payables. I have found this new functionality very useful as in my past projects we identified as a gap the payment acknowledgement process when the bank messages were handled outside EBS (by email) or by a custom solution (custom tables to store bank messages and custom reports to be published to business users). Payment Acknowledgement functionality is about to load and display in EBS the bank processing status for each of your supplier/employee payments after successful transmission of the payment file to your bank. For other interesting tips go to http://oracle-ebs-hands-on.blogspot.com
Views: 4251 Oracle EBS Hands-On
How to Apply a Prepayment on Accounts Payable (AP) Invoice?
 
07:19
A prepayment (payment in advance to your supplier) may be applied in 2 different ways on AP invoice: as a payment or as a reverse. - As a payment it will decrease invoice balance, as a standard payment - As a reverse it will decrease invoice total amount. Used when supplier is reversing prepayment from their customers by adding a negative line inside the invoice. Using this way in AP you will have the real amount of the invoice. More Oracle e-Business Suite tips on http://oracle-ebs-hands-on.blogspot.com
Views: 11139 Oracle EBS Hands-On
How to Create a Custom Disbursement Validation Set - Payment Level in Oracle EBS R12? - Part I
 
04:55
For companies using Oracle E-Business Suite R12.1 or above and paying their suppliers in multiple currencies from a multi-currency bank account it was a challenge to set up a validation rule at payment batch run to exclude any payments under a specific amount using standard functionality. As an example, company X has to avoid sending to bank any payments equal or less then equivalent of 20 USD. As I mentioned above payments may be issued in different currency so is not possible to use standard validation rule due to its limit to one single currency. For full post go to http://oracle-ebs-hands-on.blogspot.com/2014/07/how-to-create-custom-disbursement.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1635 Oracle EBS Hands-On
How to add eBusiness Suite DFFs (descriptive flex fields) to BI Apps (OBIA)?
 
11:43
BI Apps (OBIA) vanilla solution is not including "out-of-the-box" any descriptive flex fields (DFF) available and extensively used in eBS modules for different objects (AP invoice, AR transactions, GL journal lines, etc...) Almost all eBS implementation are storing supplementary information in DFF and most of the time this information is extensively used for reporting both in eBS custom reports or any other external reporting tools. When you plan to implement BI Apps (OBIA) you have to include as an additional step/requirement to extract eBS DFFs by customizing out of the box solution and make them visible to end user (BI answer). The high level steps are: For clients with BI Apps (OBIA) using Informatica: add new field(s) to database table customize Informatica customize repository For clients with BI Apps (OBIA) using ODI add new field(s) to database table customize ODI customize repository This post will not give details about above scenarios but will explain a second option I've successfully implemented. This solution may be implemented quicker without any knowledge about Informatica or ODI as is based on BI repository customization. I recommend this solution when you are running against time and you don't have closed to you any Informatica/ODI expert but you have around a BI admin expert. For full post please visit http://oracle-ebs-hands-on.blogspot.com/2014/05/how-to-add-ebs-dffs-descriptive-flex.html
Views: 1682 Oracle EBS Hands-On
How to Change Category for an Asset in Oracle EBS R12 or R11 Using API?
 
06:10
FA_API_FA_RECLASS_PUB.DO_RECLASS API may be used to change asset category for one or multiple assets. Get API used in this video from http://oracle-ebs-hands-on.blogspot.com/2014/06/how-to-change-category-for-asset-in.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1870 Oracle EBS Hands-On
How to find invoice receipt from Transaction workbench in Oracle eBS R12?
 
06:08
This video will walk you through invoice receipt details starting from receivables transactions workbench or from Account Details screen. Steps included: Step 1 - Find a paid receivables transaction / invoice Step 2 - Transaction balance due details Step 4 - Invoice has three receipt actions on it Step 5 - Review each receipt details Step 6 - Same details may be found from Account Details screen For more interesting post visit us on http://oracle-ebs-hands-on.blogspot.com
Views: 3703 Oracle EBS Hands-On
How due date is calculated for standard accounts payables invoices in Oracle eBS? (Part 2)
 
13:29
Many times when implementation is over key users or users in charge with reporting are starting to raise more in depth questions about setup and logic behind each value option available for different fields. One I have come across recently is about How due date is calculated for standard account payables invoices? The answer is quite simple at high level: payment term on top of terms date (start date when Payables calculates the due and discount dates for invoice scheduled payments). But this answer raise new questions like: 1. Which are available terms date options? 2. How terms date is defaulted at invoice level? 3. How much flexibility payment term have in regards of configuration? During this video I'll try to answer to third question. First two questions are addressed by a previous post. For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1065 Oracle EBS Hands-On
How to Pay in Full Multiple Invoices from Accounts Payables (AP) Invoice Workbench (Oracle eBS R12)?
 
02:28
Let's say you have to pay in full and quick all validated invoices for a specific supplier and entity (Operating Unit). For this specific case, instead of using payment batch process you can easily pay in full all selected invoices from AP invoice workbench. More eBusiness Suite tips on https://oracle-ebs-hands-on.blogspot.com
Views: 4012 Oracle EBS Hands-On
How to copy / generate multiple invoices from an existing receivable transaction in Oracle eBS R12?
 
08:44
In different occasions I met people that were keying monthly or on a regular bases receivable transactions/invoices for same customer having same amount and under same contractual conditions. Even if is not quite same amount but all the other information (customer, lines details) are similar you can successfully use the Copy To functionality in Oracle eBS Accounts Receivables. Steps included: Step 1 - Find the invoice / transaction you want to copy Step 2 - Copy same invoice using Daily option Step 3 - Copy same invoice using Monthly option Step 4 - Copy same invoice using Annually option Step 5 - Review generated transactions - output file Step 6 - Review generated transactions - workbench For more interesting post visit us on http://oracle-ebs-hands-on.blogspot.com
Views: 2051 Oracle EBS Hands-On
How to Assign Products and Services to an Existing Supplier (eBS R12.2.3)?
 
09:21
Most of the time organizations are looking to categorize their own suppliers based on type of products and services they are purchasing. This post will walk you trough Oracle eBS Supplier Products and Services configuration and the way products and services may be assigned to an existing supplier or may be included as a step inside supplier registration flow (iSupplier). Configuration steps (a flex structure is already configured): 1.Identify the default category set assigned to Purchasing functional area (Purchasing in our example) 2.Identify the Flex structure linked to category set (PO Item category, in our example) 3.Populate flex structure (PO Item category) with values - categories 4.Assign only values - categories you consider are relevant for suppliers 5.Setup up Products and Services category by assigning one or more segments of your flex structure (PO Item category) 6.Enable Products & Services profile section for internal users (standard supplier page) and/or for supplier users (iSupplier or supplier registration page)
Views: 1031 Oracle EBS Hands-On
How to Create Hierarchical Relationship of Trade Partners and Produce Reporting?
 
07:26
Most of the time eBS customers are looking for specific functionality to create, maintain hierarchical relationship of their trade partners (customers, suppliers, employees, banks, etc) and also to produce reporting base on desired hierarchy. To achieve this functionality you may use in Oracle eBS R12.1.1 Customers Data Librarian responsibility and in later releases Supplier Data Librarian responsibility. Using this responsibility you will be able to create and manage very easy various hierarchies and also access important information about each party. More tips on http://oracle-ebs-hands-on.blogspot.com
Views: 1049 Oracle EBS Hands-On
How to Record Freight or Various Costs to a PO Line During the PO Match to AP Invoice?
 
05:37
How to record freight or various costs to a PO line during the PO match to AP invoice The main advantage is that the freight/miscellaneous line will automatically inherit PO line GL account. AP clerk will love you for this! More tips on http://oracle-ebs-hands-on.blogspot.com
Views: 2177 Oracle EBS Hands-On
How AR transactions / invoices may be closed in Oracle eBS R12?
 
08:29
I will walk you through most used two ways to close an AR transaction, Receipt and Credit Memo, and also through another very useful action type, Adjustment, easy to use if all required setup are in place (receivables activity and approval limits for adjustments) Step 1 - Find unpaid receivables transactions Step 2 - Credit receivables transaction Step 3 - Adjust receivables transaction Step 4 -- Record receipt for receivables transaction For more interesting post visit us on http://oracle-ebs-hands-on.blogspot.com
Views: 6114 Oracle EBS Hands-On
How to Open Purchase Order (PO) Attachment From Accounts Payable (AP) Invoice Workbench?
 
05:26
Requirement: Account Payables (AP) clerk needs instant access to a specific purchase order (PO) attachment type. Solution: 1. Create a custom object to retrieve URL address 2. Create form personalization at line level as same AP invoice may be matched to multiple POs 3. Test steps: • Find a PO match to Invoice • Add an attachment to PO • Go to invoice line level and click on PO number field To download the package go to https://oracle-ebs-hands-on.blogspot.com More Oracle e-Business Suite tips on http://oracle-ebs-hands-on.blogspot.com
Views: 2573 Oracle EBS Hands-On
How to add iSurvey to iSupplier registration page in Oracle eBS R12?
 
14:56
I just came across with a requirement to enrich supplier registration (iSupplier portal) page with a short questionnaire and also with possibility to add attachments. iSupplier portal includes in release 12.2.3 add attachments functionality but not release 12.1.3 where you have this feature only inside standard supplier page - organization section. What about questionnaire? Using as support Oracle note 1213989.1 I'll summarize the steps to deliver a solution using "out-of-the box" functionalities: Step 1: Assign to your user Scripting Administrator and Survey Administrator responsibilities Step 2: Create a questionnaire (Oracle Script) Step 3: Create Oracle iSurvey and assign created Oracle Script to it Step 4: Configure iSupplier onboarding profile by enabling the questionnaire Step 5: Testing iSurvey from iSupplier portal Step 6: View prospective supplier registration Step 7: Reviewing iSurvey Responses For more solutions visit us on https://oracle-ebs-hands-on.blogspot.com
Views: 626 Oracle EBS Hands-On
How due date is calculated for standard accounts payables invoices in Oracle eBS? (Part 1)
 
09:06
Many times when implementation is over key users or users in charge with reporting are starting to raise more in depth questions about setup and logic behind each value option available for different fields. One I have come across recently is about How due date is calculated for standard account payables invoices? The answer is quite simple at high level: payment term on top of terms date (start date when Payables calculates the due and discount dates for invoice scheduled payments). But this answer raise new questions like: 1. Which are available terms date options? 2. How terms date is defaulted at invoice level? 3. How much flexibility payment term have in regards of configuration? During this video I'll try to answer to the above first two questions and show some real examples about how due date is calculated. Third one will be treated in a separate post. For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1353 Oracle EBS Hands-On
How to find database fields for an OBIEE report?
 
12:08
Often it is required to investigate what is the database source (table field) for an OBIEE report field(s) or to find out if in BI data model (repository) you can find a specific information(field). To speed up the investigation process I have decide to export the BI repository documentation and in this way I'm able to quickly progress with my analysis and also to respond immediately to any kind of questions. On one hand you have the OBIEE report with details about Subject area, Presentation Table and Presentation column and on the other hand BI repository documentation with complete details about Business Model, Logical Table, Logical Column, Logical Table Source, Database, Physical Catalog, Physical Schema, Physical Table and Physical Column. For full post and additional documents visit http://oracle-ebs-hands-on.blogspot.com/2014/06/how-to-find-database-fields-for-obiee.html
Views: 1904 Oracle EBS Hands-On
How to Create a Custom Disbursement Validation Set - Payment Level in Oracle EBS R12? - Part II
 
08:53
For companies using Oracle E-Business Suite R12.1 or above and paying their suppliers in multiple currencies from a multi-currency bank account it was a challenge to set up a validation rule at payment batch run to exclude any payments under a specific amount using standard functionality. As an example, company X has to avoid sending to bank any payments equal or less then equivalent of 20 USD. As I mentioned above payments may be issued in different currency so is not possible to use standard validation rule due to its limit to one single currency. For full post go to http://oracle-ebs-hands-on.blogspot.com/2014/07/how-to-create-custom-disbursement.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 949 Oracle EBS Hands-On
How to update Supplier information using API in Oracle EBS R12?
 
07:02
Is any way to run a supplier mass update from backend? I bet this question was raised many time to E-Business Suite support team few months after go live. More over when data was migrated from a legacy system and cleaning activity was completed under time pressure. Answer is yes, it's possible to run a mass update as Oracle EBS provides APIs for supplier master data and also for supplier site level. API sample may be downloaded from http://oracle-ebs-hands-on.blogspot.com/2014/06/how-to-update-supplier-information.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 6989 Oracle EBS Hands-On
How to View AP Invoice or PO details from Asset Source Line in Oracle EBS? - setup
 
09:04
Often Fixed Assets team members have to find more details about AP invoices in case asset is purchased and asset source lines came from Oracle EBS Account Payables module. These details may be related to freight or tax lines, when invoice was entered, who approved the invoice in case approval flow is enabled, if invoice was paid, if are any invoice attachments and so no. Also PO details may be useful for further investigation - when and who approved PO, if is any requisition link to PO, what was PO need by date and so on. These details may be found within Oracle E-Business Suite modules but will required time, additional responsibilities and at the end FA clerk is tired about number of steps to go trough. This post will show to you how to improve user experience with Oracle E-Business Suite Fixed Assets module when integration exists with Account Payables and Purchasing. For complete post go to http://oracle-ebs-hands-on.blogspot.com/2014/07/how-to-view-ap-invoice-or-po-details.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 1152 Oracle EBS Hands-On
How to View AP Invoice or PO details from Asset Source Line - Oracle EBS?
 
07:01
Often Fixed Assets team members have to find more details about AP invoices in case asset is purchased and asset source lines came from Oracle EBS Account Payables module. These details may be related to freight or tax lines, when invoice was entered, who approved the invoice in case approval flow is enabled, if invoice was paid, if are any invoice attachments and so no. Also PO details may be useful for further investigation - when and who approved PO, if is any requisition link to PO, what was PO need by date and so on. These details may be found within Oracle E-Business Suite modules but will required time, additional responsibilities and at the end FA clerk is tired about number of steps to go trough. This post will show to you how to improve user experience with Oracle E-Business Suite Fixed Assets module when integration exists with Account Payables and Purchasing. For complete post go to http://oracle-ebs-hands-on.blogspot.com/2014/07/how-to-view-ap-invoice-or-po-details.html For other interesting tips http://oracle-ebs-hands-on.blogspot.com
Views: 739 Oracle EBS Hands-On

Reclaimed windows nj
Minitab windows 7
Windows cd mp3 converter
Habilitar administrador windows 8
Ultraseal uk windows