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,