Oracle Fusion - Inventory Item Receiving Quantity SQL Query

  --SQL Query--

SELECT sum(QUANTITY) RECEIVING_INV_ITEM_QTY

FROM INV_SUPPLY_V 

WHERE

supply_type_code = 'RECEIVING'

AND req_line_id IS NULL

AND item_id IS NOT NULL

AND ITEM_ID=300000010379046 

AND to_organization_id =300000002993023 

Oracle Fusion - Inventory Item Inbound Quantity SQL Query

 --SQL Query--

SELECT sum(QUANTITY) INBOUND_INV_ITEM_QTY

FROM INV_SUPPLY_V 

WHERE

supply_type_code <> 'RECEIVING'

AND req_line_id IS NULL

AND item_id IS NOT NULL

AND ITEM_ID=300000010379046 

AND to_organization_id =300000002993023 

Oracle BIP Report Barcode Junk character Issue

 Issue: When we define the BIP report filed as barcode format and assign barcode font (Code 128) report output in pdf still giving junk character or not printing barcode.

Resolution:

Step1: Select the filed which you need to display as barcode.

Step2: Open the BIP property for that field.

Step3: It’s showing the junk character.

Step4: Remove that filed from BIP template and again attached that filed in RTF template using load XML functionality.

Step5: Assign Barcode font (Code 128)

Step6: Attach this template in the report and try. It will work.