Order To Cash Cycle – O2C “Order to cash” (O2C or OTC) normally refers to the business process for receiving and processing customer sales. order to cash process steps can be listed as below: Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create Invoice Create the Receipts either manually or using Auto Lockbox. Transfer ...
Oracle Apps Technical interview questions 1—how we can create multi reports in xml publishers Ans:subtemplate 2—how to print multi currency,multi language in xml: using xliff file(transalation) 3—what are the validations in sql*loader : infile,datafile,begindata(when we write infile*),logfile,discarded file,badfile,when clause,TRAILING NULLCOLS 4—where u can get data file : flat file(.csv,.dat,.txt) placed on any path of server 5—where u r putting control ...
Query to find out inventory adjustment made by specific user in specific time Below is the query to find out inventory adjustment made by specific user in specific time : SELECT (SELECT segment1 FROM mtl_system_items_b WHERE inventory_item_id = mpa.inventory_item_id AND organization_id = mpa.organization_id) item_number, ...
How to find Approver of Requisition in oracle Apps R12 SELECT distinct papf.full_name FROM po.po_action_history pah , applsys.fnd_user fu , hr.per_all_people_f papf WHERE object_id = prh.requisition_header_id ...
Cloned Date, Version Details, URL of Oracle Applications,Cloned date of oracle application and Version Query to get Version details.. ++++++++++++++++++++++++++++++++++++ SELECT product, VERSION, status FROM product_component_version; Query to get cloned date of an oracle instance +++++++++++++++++++++++++++++++++++++++++ SELECT resetlogs_time FROM v$database; ======================== Query to get the front end URL from backend ++++++++++++++++++++++++++++++++++ SELECT home_url ...
How to remove End date of specific responsibility for specific user in oracle apps R12 If you want to remove end date for particular user say user ABC and want to have access to that responsibility then run below script in back-end(plsql window) to get access to required responsibility : {**Note-you need to have APPS access to run below script} DECLARE p_user_name VARCHAR2 (50) := 'ABC'; p_resp_name VARCHAR2 (50) := 'Responsibility_Name'; v_user_id NUMBER (10) := 0; v_responsibility_id ...
Workflow Email Override oracle apps R12 If you are testing with for alert.Sending email to required user then you need to enter your email in workflow mailer then and then only you will get email.Also just updating and changing email address wont work until and unless you run below script from backed and commit the changes. --workflow email override BEGIN FND_SVC_COMP_PARAM_VALS_PKG.LOAD_ROW ( x_component_name => 'Workflow Notification Mailer', x_parameter_name => 'TEST_ADDRESS', x_parameter_value ...
Importing journals Oracle Apps R12 To prepare for importing journals: 1. Define all account segment values used in your feeder systems. 2. Define your ledger using Accounting Setup Manager. The accounting setup must have a Complete status to use its ledgers. 3. Define or enable all currencies used in your feeder systems. 4. Define the journal entry sources used in your feeder systems. You can also specify whether you want General Ledger to store journal reference information from your ...
Script for Creating user in oracle Apps R12 You can create user in oracle from front end directly, but user can be created only if you are having Sysadmin responsibility.What if you don't have Sysadmin responsibility. but you have full back-end access (APPS access), then by running following script you can create your user from PL/SQL developer. ...
Reasons for a sales order to get Backordered Back Orders: The Oracle "term" backorder is a "status" on the order line or delivery line indicating that you have tried to release an order for picking in your warehouse, but that the pick release was UNSUCCESSFUL because there was no available inventory.(Backorder can be partial or complete). The Oracle term backorder does NOT mean that you have open purchase orders for the out-of-stock item from your vendors.The term backorder is also used in ...
