Payables Basic setup steps Step 1 Install or upgrade Payables. (Required) Step 2 Create application user sign-ons and passwords. Users Window. System Administrator responsibility: Users (Required) Step 3 Define your chart of accounts. Defining Your Chart of Accounts , (Required) Step 4 Define your accounting period types and accounting calendar periods. Defining Period Types, and […]
Important Profiles 1. Receiving transaction Processor concurrent not visibleTP: INV Transaction processing mode — On-line RCV: Processing Mode — On-Line set to User & Resp. 2. Auto creates tools copy document next document form not pop-up. PO: Display the Autocreated Document — No to Yes PO: Display the Autocreated Quotation — No to Yes PO: […]
DFF: Descriptive Flex Field Descriptive Flex Fields are used to gather additional information about your business entities beyond the information required by oracle Applications. In other words “a mechanism that lets you creates new fields in screens that are delivered by Oracle but Hidden to store your business information”.KFF: Key Flex FieldKey Flex Fields are […]
Convert Number into Words select ename,sal,to_char(to_date(sal,’J’), ‘JSP’) as converted_formfrom scott.emp ENAME SAL CONVERTED_FORMSMITH 800 EIGHT HUNDREDALLEN 1600 ONE THOUSAND SIX HUNDREDWARD 1250 ONE THOUSAND TWO HUNDRED FIFTYJONES 2975 TWO THOUSAND NINE HUNDRED SEVENTY-FIVEMARTIN 1250 ONE THOUSAND TWO HUNDRED FIFTYBLAKE 2850 TWO THOUSAND EIGHT HUNDRED FIFTY
To Find Duplicate Item Category CodeSELECT category_set_name, category_concat_segments, COUNT (*)FROM mtl_category_set_valid_cats_vWHERE (category_set_id = 1)GROUP BY category_set_name, category_concat_segmentsHAVING COUNT (*) > 1ORDER BY category_concat_segments Get Number Of canceled requisitionSELECT a.AUTHORIZATION_STATUS,(a.ORG_ID),(SELECT distinct hr.per_all_people_f.first_name|| ‘ ‘|| hr.per_all_people_f.middle_names|| ‘ ‘|| hr.per_all_people_f.last_name “Employee Name”FROM hr.per_all_people_fwhere hr.per_all_people_f.PERSON_ID in(select employee_id from fnd_user fu where fu.user_id = a.CREATED_BY)) CREATED_BY,count(SEGMENT1 ) FROMpo_requisition_headers_all aWHERE a.creation_date […]
Recent Comments