2016-04-09 11:55
Urgent requirement of a sales professional for Qatar location. JD is as below.Experience:- level:- 2-4 years.The candidate should be having experience of selling software solutions/ applicat… Read More
Blog Directory > Software Blogs > Programming Blogs > eBiz Integration Technics programming Blog >
Ebiz Integration Technics Blog
ebiztechnics.blogspot.in
Tags:
oracle
functional consultant
consultant
count
oracle server
supply chain consultant
cost management
kali yuga began
apps
ship confirm
Oracle Applications R12 implementation,upgrades,Oracle SCM,Finance, ADF,OAF, workflow,SQL,PL/sql, forms/Reports 10G, BI publisher reports Interfaces
2016-04-09 10:21
Plan to Inventory Management Flow Script SequenceWhen implementing the Plan to Inventory flow family alone, the flow script should be executed in the sequence depicted below. Flows th… Read More
2016-04-09 06:51
Oracle Order to Cash Accounting EntriesInventory AccountsA. PeriodicB. P… Read More
2016-04-07 23:48
Yugādi (Ugādi, Samvatsarādi, Telugu: ఉగాది Ugadi/Yugadi, Kannada: ಯುಗಾದಿ Yugadi, Konkani: युè&helli…Read More
2016-04-07 04:01
1. What is NOCOPY? By default the IN parameter is passed by reference and the OUT and IN OUT parameters &n&hell…Read More
2016-04-05 11:19
To display a checkbox in BI Publisher PDF reports, test the following steps in a development environment and migrate accordingly.The following steps are provided in the Report's Design… Read More
2016-04-04 10:42
looking for Oracle Fusion HCM Functional Consultant for one of our MNC client. Joining location-Bangalore/Chennai Exp : 8-12 years Job type : Permanent Interested ca… Read More
2016-04-03 12:02
Urgent Requirements for Australia: 1. Oracle Finance Functional Consultant 2. Oracle PO/iProc Functional Consultant 3. Oracle CM Functional Consultant. Interested and qualified candidates ma… Read More
2016-04-03 00:54
In R12, On the Supplier Screen (query for a supplier--> Click on update supplier---> Invoice Management)Here we have a section called Invoice Payment Terms. Usually we have site level… Read More
2016-04-01 06:08
Oracle Landed Cost Management Oracle Landed Cost Management is a new module, which is introduced in Oracle E-Business Suite Release 12.1. Oracle Landed Cost Management'sThe key functionaliti… Read More
2016-03-31 05:28
MeaningAccounting period that can start on any day of a calendar year but has twelve consecutive months (52 consecutive weeks) at the end of which account books are closed, profit or loss is… Read More
2016-03-31 04:01
MeaningAccounting period that can start on any day of a calendar year but has twelve consecutive months (52 consecutive weeks) at the end of which account books are closed, profit or loss is… Read More
2016-03-30 12:47
Generating the trace filesThe trace file helps us in finding the various queries executed while doing certain activities. The complex queries written for selecting, inserting, updating &… Read More
2016-03-30 09:23
Oracle Applications performance tuning issues take two forms:A) Simple issues that developers can fix themselves with an intermediate knowledge of the applications and the database.B) Comple… Read More
2016-03-29 01:48
Use aliasesWhenever you issue a DML command, Oracle must match each column with its corresponding table. Aliases reduce that time. When using aliases, strive for single character names.For… Read More
2016-03-27 09:27
CREATE OR REPLACE PROCEDURE SEND_MAIL_TCP (errbuf OUT VARCHAR2, retcode OUT VARCHAR2 ) IS msg_from VARCHAR… Read More
2016-03-26 10:51
Customer Return to Credit Enter customer returns by referencing Item, Sales Order Number, and Customer Purchase Order Number of Invoice Number. Issue an RMA for the original orde… Read More
2016-03-26 04:23
Oracle Receivables Interview Questions1)Is it possible to apply a receipt from one customer to another customer’s transaction? If Yes, how to apply?Yes, in Manual Quick batch receipt w… Read More
2016-03-25 06:19
Item Orderability Businesses need the ability to define which customers are allowed to order which products, and the ability to apply the business logic when the order is created. For… Read More
2016-03-24 08:40
Junior Developer/Fresher's OpeningDell has 3 positions opened up for Junior Developers ( 0 - 2 Yrs). C & Data Structures, Coding Skills are a Must. Min 75% Aggregate Score. There will… Read More
2016-03-24 04:54
Junior Developer/Fresher's OpeningDell has 3 positions opened up for Junior Developers ( 0 - 2 Yrs). C & Data Structures, Coding Skills are a Must. Min 75% Aggregate Score. There will… Read More
2016-03-24 03:57
Oracle Workflow Basics Part -1Oracle Workflow APIs in Detail... Oracle Workflow APIs:1 WF_ENGINE2 WF_CORE3 WF_PURGE4 WF_DIRECTORY5 WF_PREF6 WF_MONITOR7 Oracle Workflow Views8 WF_QUEUE9 FND_D… Read More
2016-03-24 03:45
t's not only in the case of a HR or a Recruiter. It happens with the candidates as well. I have been looking for job since 8 months and have gone through couple of interviews in BIG MNCs, he… Read More
2016-03-23 08:57
Current Date : Will be used to pass the Sysdate as default valueCurrent Time : Will be used to pass the Systime as default valueConstant : Will be used to pass the… Read More
2016-03-23 07:17
Processes that involve multiple users and the routing of data between the users are termed as 'WORKFLOW'.What are Workflow Components: Workflow typically consist of 4 R’sRules : Rules… Read More
2016-03-23 04:03
Holi is a spring festival in Nepal and India, also known as the festival of colours or the festival of sharing love. Holi is a two day festival which starts on the Purnima (Full Moon d… Read More
2016-03-22 06:00
-----> Part 1 Oracle Applications :Alerts :Concurrent Request work through Oracle Alerts Part-1Step 7: Check for the Output parameters and the description.Step 8: Select ORD_BUK as… Read More
2016-03-22 04:34
As you must be knowing, to create a refund in AR, you have to create a Receivable Activity. It is the GL account provided in this receivable activity which is used for refund accounting. Fol… Read More
2016-03-22 04:25
Self-Assessed Tax :Self Assessed tax differs from regular taxes in one way: as a purchaser, you are responsible for reporting and paying the tax and the supplier is not.This was also… Read More
2016-03-22 04:18
There are many AP reports in 11i that were not upgraded to R12. There also are some that were upgraded, but do not work in RUP 4 and patches need to be applied to get them to work. &nb&hell…Read More
2016-03-21 08:40
Oracle alerts within Oracle Applications that we can use to explore facilities provided by Alerts for calling concurrent request when an insert or update event occurs in the application… Read More
2016-03-21 04:01
WORK IN PROCESS FLOWCreation of Discrete job :we will define the discrete job by mentioning the Type of discrete job,Status,Quantity and completion dateNavigation … Read More
2016-03-20 05:33
2016-03-19 18:53
1.1. Formatting CurrenciesEnsure that each report that shows monetary amounts indicates the currency or currencies associated with those monetary amounts.1.1.1. … Read More
2016-03-19 18:53
Looking for the talent on below requirement. Experience: 3-16 years Required Skills: Strong experience in OBIA/ BI Apps At least one End to End Oracle BI Apps implementation expe… Read More
2016-03-19 12:53
&nb&hell…Read More
2016-03-19 10:53
1) You encounter the following statements:SELECT e1.ename|| 'works for '||e2.ename "Employees and their Managers"FROM emp e1, emp e2 WHERE e1.mgr=e2.empno;What kind of join is this ?A. Carte… Read More
2016-03-18 11:32
1. Which of the following statements is true about implicit cursors? 1. Implicit cursors are used for SQL statements t… Read More
2016-03-18 09:43
Invoice Types:1. Standard Invoice: For supplier Standard payment will select this standard invoice,where we are going to create invoice with supplier name and supplier site name.2. Credit Me… Read More
2016-03-18 05:56
URGENTLY looking for Oracle Fusion HCM Functional Consultant ( 2 to 12 years ) with our US Based IT Client based at BANGALORE location. Interested candidates, please shoot your resume to dar… Read More
2016-03-17 11:51
Extraction of year,month.day from date function by using ExtractSyntax:SELECT EXTRACT (YEAR FROM SYSDATE) AS year, EXTRACT (MONTH FROM SYSDATE)… Read More
2016-03-17 04:15
Naming Variables• PL/SQL variables, except for fields in record structures, should not have names identical to column names.• Temporary variables should be named after the da… Read More
2016-03-16 04:51
1>Need Oracle PL/SQL Developer with UNIX hands on experience and ETL knowledge will be advantage for an US product development company in Hyderabad (Uppal)with 3 Years of experience. Plea… Read More
2016-03-15 08:23
What is email etiquette?Whether you are writing a business email or a personal email, there are proper rules of etiquette to consider before you send an email. Please consider the tips below… Read More
2016-03-15 04:58
1. What is the name of the top Organization in Oracle HRMS, which serves as a container for all other organizations? (a) Gover… Read More
2016-03-14 16:48
Accenture is hiring BE / B Tech/ MCA graduates (2015 passed out only) with 60% aggregate in the highest educational qualification (mandate). 3 months to 1 yr exp in any domain. ( n… Read More
2016-03-14 09:05
A ribbon cutting ceremony is a public ceremony conducted to inaugurate the opening to the general public of a new building or business or a company or any new establishment.Often, the c… Read More
2016-03-14 07:24
1>Oracle EBS R12.2 jobs in EGY , KSA and QAR - For a well known Customer site in EGY , KSA and QA, required Oracle FIN techno functional consultants 3-5 yrs #ORA_EBS_FIN… Read More
2016-03-13 09:01
Urgently looking for Mandarin speaking Oracle Functional Consultant (7+ years of experience) with Oracle EBS R12 having implementation/rollout experience on Finance(AP,AR,FA,GL) and Procurem… Read More
2016-03-12 14:01
--- cursor using where clause in itDECLARE CURSOR ebiz_cursor IS SELECT e.department_id, &n&hell…Read More
2016-03-12 10:09
Example 1:- simple program using index by table/associative array.DECLARE TYPE ebiz_type IS TABLE OF employees%ROWTYPE … Read More
2016-03-12 04:09
AR1. Do you book your receivables on the customer/declare your debtors before delivery of goods or after delivery of goods at the end of stipulated period (To decide on the invoicing Rule to… Read More
2016-03-11 05:11
Data MigrationData Migration is the process of transferring data between one system to another system. Data migration is required when organizations or individuals change computer systems or… Read More
2016-03-10 12:39
What is RICEF?ReportsInterfacesConversionsExtensionsFormsConsidering RICEF strategies, the following tools are proposed for the development of required components. Oracle Developer SuiteOrac… Read More
2016-03-10 11:43
AutoLockBox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.Auto Lock Box eliminates manual data entry b… Read More
2016-03-10 10:57
The purpose of this deliverable is to document the functional requirements for the Oracle Item Category Conversion between flat file and oracle apps.The Item Category Assignment Open Interfa… Read More
2016-03-10 04:01
Example 1: - Simple cursor program.DECLARE p_emp_id employees.employee_id%TYPE; p_name employees.last_name%TYPE; p_sal … Read More
2016-03-09 12:30
Example 1: - Simple cursor program.DECLARE p_emp_id employees.employee_id%TYPE; p_name employees.last_name%TYPE; p_sal … Read More
2016-03-09 06:09
What is User Hooks?By Using ‘Api Hooks’ we can extend the business logic of the standard business rules that are executed by APIs.ie., if we want to add the extra val… Read More
2016-03-08 13:54
Forms 12c release:New browser-less client configuration optionsCustomizable runtime Color SchemesIntegration with BI-PublisherForm Builder productivity improvementsNew applet parameters for… Read More
2016-03-08 13:50
International Women's Day (IWD), originally called International Working Women's Day, is celebrated on March 8 every year.In different regions the focus of the celebrations ranges from gener… Read More
2016-03-08 06:20
Move orders are formal requests to move material within the same inventory organization.1) MTL_TXN_REQUEST_HEADERS:Move order headers, this stores the move order number in column (REQUEST_NU… Read More
2016-03-07 14:24
What is RICEF?ReportsInterfacesConversionsExtensionsFormsConsidering RICEF strategies, the following tools are proposed for the development of required components. Oracle Developer SuiteOrac… Read More
2016-03-07 13:06
Purchase Order Inbound InterfacePre Requisites1) Supplier sites contact details should be defined2) Organization structure should be defined3) Ship to bill to locations needs to be defined4)… Read More
2016-03-06 06:29
1. Order Entry: This is first stage when Order in enter in system. When the order is entered it basically create a record in order headers and Order Lines table. &n&hell…Read More
2016-03-06 03:37
Technical Query on Purchasing quotationsSELECT pha.po_header_id, pha.segment1 quoteno, pha.quote_type_lookup_code,&nb&hell…Read More
2016-03-05 15:23
We can create concurrent programs usingApplication Developer Responsibility/System Admin Responsibility,You can also create Concurrent programs using API'sHere is the code snippetCCREATE OR… Read More
2016-03-05 01:44
1) Purchase Orders : It is one of the purchasing document at the time of purchasing from the supplier we will create this document by specifying terms and conditions and shipping detai… Read More
2016-03-04 06:02
SQL Loader - Oracle 12C - Express Mode One such feature is the express mode that is available in 12C and in this post let us experiment this new approach with a basic example.To get thi… Read More
2016-03-04 02:57
Purchasing Process1) Requisition: It is one of the purchasing document will be crated by employers when ever they required goods or services or training, we will find 2 types of requisitions… Read More
2016-03-03 10:20
What is the difference between OUM and AIM?Majority of task and deliverable remain same, but they reclassified under different Process.Benefits of OUM» More Focused Effort – OUM… Read More
2016-03-03 05:43
Ravello will join in Oracle’s IaaS (Infrastructure as Service) mission to allow customers to run any type of workload in the cloud, accelerating Oracle’s ability to help customer… Read More
2016-03-03 03:45
Basic Setups to create a Purchase orders1. Items Creation2. Suppliers creation3. Buyer creation 1) Item Creation a. Open the user from in System Administrator Responsibility attac… Read More
2016-03-02 11:49
Mandatory setups in Accounts Receivables: 1. Defining the customer2. Define customer bank3. Payment terms4. Defining the dunning letters5. Defining the statements6. Defining auto… Read More
2016-03-01 23:59
Lets understand how to update existing items.Lets say i have an item 'odc' which has no buyer code in seattle organization (m1 organization code). I want to update and asscoiate 'west, rod'… Read More
2016-03-01 12:01
To import items and material cost associated to it.First check which cost elements are defined for the organization.Select cost_type_id, cost_type, description from cst_cost_types;Output loo… Read More
2016-03-01 12:00
Oracle Apps Order Management Technical overview Read More
2016-03-01 02:54
How to use User Defined Functions in SQL*Loader?CREATE OR REPLACE FUNCTION xxemp_fun (hdate DATE) RETURN VARCHAR2IS l_date VARCHAR2 (10);BEGIN SELE… Read More
2016-02-29 11:09
Union Budget 2016Budget Snippets 2016⦁ No change in personal Income Tax slabs * 4-month Compliance Window for domestic black money holders; tax, interest on them at 45%&nb&hell…Read More
2016-02-29 06:24
To import items and use item templates. To see all template names run the following sql.SELECT template_id, template_name, description FROM mtl_item_templates; To see all the attributes re… Read More
2016-02-29 06:12
Item import overviewUse the item import process to import items from your legacy system . You can import items from any source into oracle inventory and oracle engineering.When you import it… Read More
2016-02-29 03:05
Your year is about to get one day longer. Monday, Feb. 29 is leap day, the day inserted into the calendar every four years to keep our calendar operating smoothly. This extra day makes the y… Read More
2016-02-27 16:01
Test Case ID Feature/ Functionality ID Test Description Expected Behavior Generalised Test Conditions 1 Running the Loader concurrent program. Data has been loa… Read More
2016-02-27 05:49
This blog post gives the technical components required to implement an interface from the legacy system to Oracle Receivables.Auto Invoice is a powerful and a flexible tool that is used to i… Read More
2016-02-26 13:56
Defining Average CostingSubinventory TransfersYou use subinventory transfers to move material from one subinventory to another subinventory in the same inventory organization. An entry is re… Read More
2016-02-25 10:07
Bill Only Order When Creating sales orders , we have many instances where we need to create a BILL Only Sales Order(apply when using the Flow "Line Flow - Generic, Bill Only with I… Read More
2016-02-25 00:20
There are some job interview questions that are guaranteed to come up in most (if not all) of your job interviews — regardless of your industry, your experience level, and job type.&nb&hell…Read More
2016-02-24 11:32
1. Generate Trace FileEnable Tracing For The Concurrent Manager ProgramSelect the Enable Trace Checkbox Enabling trace in Concurrent programTurn On TracingResponsibility: Sys… Read More
2016-02-24 07:51
1)One of Users are getting the following error message when trying to Pick Release"You are not authorized to release sales orders from this Organization".We have the same shipping roles assi… Read More
2016-02-23 09:59
1. Define Common Accounts Receivable ConfigurationCommon Accounts configuration pertains to the Accounting Flexfield setup. This is done in the General Ledger (GL) application. The assumptio… Read More
2016-02-22 13:56
Oracle Applications :Procure to Pay Technical Snapshot Read More
2016-02-21 09:18
Applications Tuning Oracle Applications performance tuning issues take two forms:A) Simple issues that developers can fix themselves with an intermediate knowledge of the applicat… Read More
2016-02-20 09:17
P2p accounting entries· When Inventory / Material is in Transit· When Inventory is delivered to the Inventory Sub Stores· When Invoice is booked / recorded· When… Read More
2016-02-20 09:15
Procure to Pay CycleJoining between RFQ,Quotation and Purchase orderSELECT R.SEGMENT1 AS RFQ_NUM, Q.SEGMENT1 AS QUOTATION_NUM FROM PO_HEADERS_ALL R, PO_HEADE… Read More
2016-02-19 19:36
1 ___________ is an alternative name for a table, view, sequence, procedure, stored function, package, snapshot or another synonym. a] Synonym b] Data block c] View d] Non… Read More
2016-02-19 19:33
1) What is TRUNCATE table ? TRUNCATE table is a DDL command used to remove all the rows from the specified table or cluster instantly. Eg: TRUNCATE TABLE table_name;Advantage over DELETING:… Read More
2016-02-19 15:21
Inventory - Standard CostingPrerequisites • Define Organization Parameters• Costing Method is set to Standard• Transfer Detail to GL is appropriately set• Defa… Read More
2016-02-17 09:39
Sub-inventory Quantities ReportRun this report if you want to count all or certain items in a sub-inventory. You cannot use thisreport to count items by locator.Make sure you are in the desi… Read More
2016-02-16 09:44
This blog post is to describe the strategy and procedure to be undertaken to process PO Receipt information from non-Oracle systems to Oracle applications In addition the documen… Read More
2016-02-16 09:12
Generating Reconciliation Reports⦁ Generate the Aging Report as of the last day of the month to get the month-end balance.⦁ Use the AR Reconciliation Report to help you reconci… Read More
Subscribe to Ebiz Integration Technics
Get updates delivered right to your inbox!