Oracle EBS Items Details Query R12

Inventory Itemes Details Query Sample:

SELECT a.segment1 item_number , a.description item_desc ,msi.description name_other, a.organization_id ,mp.organization_code,a.item_type,inventory_item_status_code status,
,ick.concatenated_segments item_category ,a.inventory_item_flag  ,a.inventory_item_status_code,a.primary_uom_code ,a.primary_unit_of_measure,fa.concatenated_segments asset_category
FROM 
 mtl_system_items a
,mtl_categories_b_kfv ick
,mtl_category_sets_vl cs
,mtl_item_categories c
,mtl_parameters mp
,mtl_system_items_tl msi
,fa_categories_b_kfv fa
 where 1 =1 
 and fa.category_id (+)= a.asset_category_id
   and cs.structure_id = ick.structure_id 
  and ick.category_id = c.category_id

 and a.inventory_item_id = msi.inventory_item_id
 and a.inventory_item_id = c.inventory_item_id
 and a.organization_id = c.organization_id
and msi.language = US''
and msi.organization_id = a.organization_id  
 and a.organization_id = mp.organization_id ;


Hope this query help full .....

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button

Oracle EBS R12.1 installation failure in final step:

Checking URL =http://bbarg-app.ple.com:8000/

RW-50015: Error: – HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page
———-

checking URL = http://bbarg-app.ple.com:8000/OA_HTML

RW-50015: Error: – Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
——————
RW-50015: Error: – Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
—-

checking URL = http://bbarg-app.ple.com:8000/Jsp

RW-50015: Error: – JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
———–


RW-50015: Error: – Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.
Apache logfiles:

Cause:
http web server unable to start due to missing library.  /usr/lib/libdb.so.2

Solution:

1) Shut all application services.

2) create the below link for library file as below

 ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2

3) Startup all application services.

And press the retry button 
And it will works fine.

Screen shot:

Thank you Any thing keep me posted .

Bahaa Barghouti.

11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data

MOS:(Doc ID 549024.1)
11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data

Solution:

To create the records in CE_PAYMENT_DOCUMENTS, the custom format should be created in R12. Do the following: 

1. Create corresponding rtf template for the custom rdf format in ap_check_formats that was used in 11i. 

From Payables responsibility, navigate to Setup/Payments/Payment Administrator 
Payments Setup/Formats/XML Publisher Format Templates 
Click on Create Template 

2. Register the rtf template in Xml Publisher using XDO administrator resp 

3. Define Payment Format (corresponding to ap_payment_program) in Oracle Payments. 

From Payables responsibility, navigate to Setup/Payments/Payment Administrator 
Payments Steup/Formats/Formats 
Select Type: Disbursement Payment Instruction 
Click on Create 
Enter details and save. 
This should create a record in IBY_FORMATS_B 

4. Associate this new rtf template to the format. 

5. Using sqlplus, associate the IBY_FORMATS_B with ap payment program via reference_format_code column. 

To determine the ap Payment Program name to associate with the new IBY format created, do the following.

a) Determine the format payment program used by the 11i format.
Select format_payments_program_id
from ap_check_formats
where name = '&11i format name';
Note down the result.

Example:
Select format_payments_program_id
from ap_check_formats
where name = 'Long Check Format'
FORMAT_PAYMENTS_PROGRAM_ID
--------------------------
10002

b) Determine the program name relevant to this program id.
 select  program_name from ap_payment_programs
    where program_id = &id; ---> Id returned in previous sql.

Example:
select program_name from ap_payment_programs
where program_id = 10002;
PROGRAM_NAME
------------------------------
APXPBFEG


c) Now associate this short program_name to the R12 IBY format created in step 3.

UPDATE IBY_FORMATS_B 
SET Reference_format_code = '<ap program name>' 
WHERE format_code = '<Format_Code of Format created using IBY UI in step 3>' 
and reference_format_code is null; 

Example:
UPDATE IBY_FORMATS_B
SET Reference_format_code = 'APXPBFEG'
WHERE format_code = '<Format_Code of Format created using IBY UI in step 3>'
and reference_format_code is null; 

6. Execute the upgrade script ibypaydocupg.sql in Patch 15895924 
to create payment documents in CE_PAYMENT_DOCUMENTS table. 

Hope this is usefull

Regards,

Installing Oracle EBS R12.2

Installing Oracle EBS  R12.2

Installation is more or less similar to previous R12 version (with few additional screens for WebLogic Server).

If you want to learn more about Oracle E-Business Suite (Oracle Apps) 12.2

Document you must read :

• Oracle E-Business Suite 12.2 Installation Guide is available here
• 1320300.1 Oracle E-Business Suite Release Notes, Release 12.2
• 1376487.1  Oracle E-Business Suite Applications DBA (AD) Release Notes for Release 12.2.2

.

Oracle Apps (E-Business Suite) 12.2 installation steps 

1. Download software from eDelivery .

1.1 Download following zip files for Linux

V29764-01.zip V35231-01_4of5.zip V35806-01_1of3.zip V37515-01_1of6.zip V29856-01.zip V35231-01_5of5.zip V35806-01_2of3.zip V37515-01_2of6.zip V35215-01_1of3.zip V35802-01.zip V35806-01_3of3.zip V37515-01_3of6.zip V35215-01_2of3.zip V35803-01_1of3.zip V35807-01.zip V37515-01_4of6.zip V35215-01_3of3.zip V35803-01_2of3.zip V35808-01.zip V37515-01_5of6.zip V35230-01_1of2.zip V35803-01_3of3.zip V35809-01.zip V37515-01_6of6.zip V35230-01_2of2.zip V35804-01_1of2.zip V35810-01.zip V39615-01.zip V35231-01_1of5.zip V35804-01_2of2.zip V35811-01.zip V35231-01_2of5.zip V35805-01_1of2.zip V35812-01.zip V35231-01_3of5.zip V35805-01_2of2.zip V35813-01.zip

2. Setup staging area (You can either unzip all files downloaded earlier or follow below process)

2.1 unzip StratCD DVD (for Linux)

unzip V35215-01_1of3.zip

2.2 Start buildStage script

[R12.2_SOFTWARE]/startCD/Disk1/rapidwiz/bin

./buildStage.sh

2.3 select option 1 i.e. Create New Stage

2.3 Select Option 2 Linux x86-64

2.4 Please enter the directory containing the zipped installation media: [Enter directory location where all the zip files are downloaded] for example:

/u01/install/

You should see output like

__________
Unzipping V35810-01.zip
Unzipping V35803-01_3of3.zip
Unzipping V35231-01_5of5.zip

.
.
.

Verifying stage area…

Directory /stage/oracle/r12/12.2/TechInstallMedia is valid
Directory /stage/oracle/r12/12.2/TechPatches/DB is valid
Directory /stage/oracle/r12/12.2/TechPatches/MiddleTier is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AppDB is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/Apps is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AS10.1.2 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/database is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/ohs11116 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/wls1036_generic is valid

__________

3. Create Operating System User depending on Single User or Multi UserInstallation :

You can do

a) Single -User  Installation : oracle where both Application Tier and Database Tier are owned by single user

b) Multi-User Installation : oracle & applmgr where Application Tier is owned by one user (applmgr) and Database Tier by another (oracle)

Note: I am doing multi-user installation and using applmgr & oracle both member of group dba

groupadd dba 
useradd -g dba applmgr 
useradd -g dba oracle

4. Start Installer from root user
cd /u01/install/startCD/Disk1/rapidwiz/
./rapidwiz

5. In Wizard Operation screen select : Install Oracle E-Business Suite Release 12.2.0

 Remaining Steps on next post .. 

Fatal Error: TXK Install Service

Fatal Error: TXK Install Service
(Doc ID 1590656.1)
this error occurred if there is a previous failed installation , so you need to cleanup previous installation folders as follow:

A. Restart the server or make sure to kill ALL oracle and applmgr processes.

B. Delete the install directory, oraInventory and /tmp.

Note: If there are multiple EBS Instances or Oracle homes are present on server then central inventory needs to be cleaned up properly so that other existing environment should not get impacted. De-register Oracle homes first for the failed installation and then remove the install directory of failed installation. Also if some other process is running in /tmp directory then make sure that only process and files related to failed installation from /tmp directory needs to be deleted.

C. Run rapidwiz to start installation again.

ORA-20001: System Error: Procedure sort_segment_order at Step 40

ORA-20001: System Error: Procedure sort_segment_order at Step 40

DECLARE

    lc_employee_number            per_all_people_f.employee_number%TYPE; -- := 'tan_01';

    ln_person_id                  per_all_people_f.person_id%TYPE;

    ln_assignment_id              per_all_assignments_f.assignment_id%TYPE;

    ln_object_ver_number          per_all_assignments_f.object_version_number%TYPE;

    ln_address_id                 PER_ADDRESSES.ADDRESS_ID%TYPE;

    ln_asg_ovn                    NUMBER;

    ld_per_effective_start_date   per_all_people_f.effective_start_date%TYPE;

    ld_per_effective_end_date     per_all_people_f.effective_end_date%TYPE;

    lc_full_name                  per_all_people_f.full_name%TYPE;

    ln_per_comment_id             per_all_people_f.comment_id%TYPE;

    ln_assignment_sequence        per_all_assignments_f.assignment_sequence%TYPE;

    lc_assignment_number          per_all_assignments_f.assignment_number%TYPE;

    lb_name_combination_warning   BOOLEAN;

    lb_assign_payroll_warning     BOOLEAN;

    lb_orig_hire_warning          BOOLEAN;

   

    -------------------

    ------------Assignment

    l_assignment_id            NUMBER;

    l_effective_date           DATE := NULL;

    l_supervisor_id            NUMBER;

    lb_correction              BOOLEAN;

    lb_update                  BOOLEAN;

    lb_update_override         BOOLEAN;

    lb_update_change_insert    BOOLEAN;

    lc_dt_ud_mode              VARCHAR2 (100) := NULL;

    l_obj_version_num          NUMBER;

    l_organization_id          NUMBER := 81;

    l_soft_coding_keyflex_id   hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

    l_concatenated_segments    VARCHAR2 (2000);

    l_comment_id               per_all_assignments_f.comment_id%TYPE;

    l_effective_start_date     per_all_assignments_f.effective_start_date%TYPE;

    l_effective_end_date       per_all_assignments_f.effective_end_date%TYPE;

    l_no_managers_warning      BOOLEAN;

    l_other_manager_warning    BOOLEAN;

    error_message              VARCHAR2 (4000) := NULL;

    current_records            NUMBER;

    total_records              NUMBER;

    error_records              NUMBER;

    l_effective_date_valid     NUMBER;

    error_message1             VARCHAR2 (4000) := NULL;  

   

    v_ledger_id              gl_ledgers.ledger_id%type;

    v_job_definition_id      PER_JOB_DEFINITIONS.job_definition_id%type;

    v_position_definition_id per_position_definitions.position_definition_id%type;   

    v_location_id            hr_locations_all.location_id%type;

    v_emp_count              number := 0;

-- Out Variables for Update Employee Assgment Criteria

-- -------------------------------------------------------------------------------

-- ln_people_group_id  NUMBER                     := null;   -- This will cause error  ORA-20001: System Error: Procedure  at Step 40

ln_people_group_id   NUMBER                      := hr_api.g_number;   --  PEOPLE_GROUP_ID

  end;

ln_special_ceiling_step_id                          PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE;

lc_group_name                                       VARCHAR2(30);

ld_effective_start_date                             PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;

ld_effective_end_date                               PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE;

lb_org_now_no_manager_warning                       BOOLEAN;

lb_other_manager_warning                            BOOLEAN;

lb_spp_delete_warning                               BOOLEAN;

lc_entries_changed_warning                          VARCHAR2(30);

Entering: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_B                   10

  hr_api.validate_commit_unit                                           10

Leaving: HR_ASSIGNMENT_BK3.UPDATE_EMP_ASG_CRITERIA_B                   20

Entering hr_kflex_utility set_profiles                                  5

hr_kflex_utility set_profiles                                           10

hr_kflex_utility set_profiles                                           20

hr_kflex_utility set_profiles                                           30

hr_kflex_utility set_profiles                                           40

hr_kflex_utility set_profiles                                           50

Leaving hr_kflex_utility set_profiles                                   100

Entering hr_kflex_utility set_session_date                              5

hr_kflex_utility set_session_date                                       30

Leaving hr_kflex_utility set_session_date                               100

Entering:upd_or_sel_keyflex_comb                                        10

upd_or_sel_keyflex_comb                                                 20

Entering:check_ignore_varray                                            10

Seg3 $Sys_Def$                                                         101

Entering:ins_or_sel_keyflex_comb                                        10

ins_or_sel_keyflex_comb                                                 20

Entering:check_ignore_varray                                            10

ins_or_sel_keyflex_comb                                                 30

Entering:sort_segment_order                                             10

sort_segment_order                                                      20

sort_segment_order                                                      30

sort_segment_order                                                      40

ins_or_sel_keyflex_comb                                                 100

Leaving upd_or_sel_keyflex_comb                                         140

-----RollBack ORA-20001: System Error: Procedure sort_segment_order at Step 40

Cause:        The procedure sort_segment_order has created an error at Step 40. 

Action:        Contact your system administrator quoting the procedure sort_segment_order and Step 40.

i found the solution which is to add at least one value to the key flexfield : " People Group Flexfield" .

Regards,