Convert Oracle Report 6i to BIP

http://bipublisher.blogspot.com/2009/05/bi-publisher-reports6i-to-bip.html

Link between Internal requisition and Internal sales order

1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID =



po_requisition_lines_all.REQUISITION_LINE_ID

2. OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition Number)

3. OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF=

po_requisition_HEADERs_all.SEGMENT1(Requisition number)

Displaying ROWID in TOAD

That’s EXACTLY what it is.



In your data grid, mouse-right-click – SELECT COLUMNS



Enable ‘ROWID’



You also have –



Toad – View – Options – Data Grids – Data – Display – ‘Show ROWID in editable grids’

Query to find the time difference of a concurrent request

SELECT request_id


, x.status_code sts_cod

, (SELECT user_concurrent_program_name

FROM fnd_concurrent_requests a, fnd_concurrent_programs_vl b

WHERE a.request_id = x.request_id

AND a.concurrent_program_id = b.concurrent_program_id)

concurrent_program

, (SELECT meaning

FROM fnd_lookups

WHERE lookup_code = x.status_code

AND lookup_type = 'CP_STATUS_CODE')

status

, fu.user_name

, fu.description

, argument_text parameters

, actual_start_date actual_start_with_time

, TRUNC(actual_start_date) actual_start

, actual_completion_date actual_completion

, DECODE (

actual_completion_date

, NULL, TO_CHAR (

TO_DATE ('00:00:00', 'HH24:MI:SS')

+ (SYSDATE - actual_start_date)

, 'HH24:MI:SS'

)

, TO_CHAR (

TO_DATE ('00:00:00', 'HH24:MI:SS')

+ (actual_completion_date - actual_start_date)

, 'HH24:MI:SS'

)

)

hr_min_sec

, TO_CHAR (SYSDATE, 'ddmm:hh:mi:ss') systime

, completion_text

--,(ROUND(to_number(actual_completion_date -actual_start_date) *60 *60 *24)) dt_dif_in_sec

FROM fnd_concurrent_requests x, fnd_user fu, fnd_responsibility_vl frv

WHERE frv.responsibility_key LIKE '%\_UK\_%' ESCAPE '\'--all UK responsibilities

AND frv.responsibility_id = x.responsibility_id

AND x.requested_by = fu.user_id

AND x.concurrent_program_id IN

( --(170990),

(SELECT concurrent_program_id

FROM fnd_concurrent_programs_vl

WHERE UPPER (user_concurrent_program_name) LIKE 'XX%'))

--and request_id = 27061498

and actual_start_date <= sysdate

Upgrading Form Personalizations and OA Framework Personalizations from Oracle E-Business Suite Release 11i to 12.1 [ID 1292611.1]

Upgrading Form Personalizations and OA Framework Personalizations from Oracle E-Business Suite Release 11i to 12.1 [ID 1292611.1]

Attach responsibility to user from backend

BEGIN

fnd_user_pkg.addresp(username =&gt
,resp_app =&gt 'SYSADMIN'

,resp_key =&gt  'SYSTEM_ADMINISTRATOR'

,security_group =&gt  'STANDARD'

,description =&gt 'Custom System administrator responsibility'

,start_date =&gt  Sysdate

,end_date = &gt Sysdate +100);

COMMIT;

END;

Passing Multiple Paramaters to the form from form personalisation

Type:Built In
Built In Type:Launch a Function
Function Code:
Function Name:
Parameters:
='XXINV_ORDER_NUMBER='


${item.order.order_number.value}

'

XXINV_ITEM_CODE='

${item.line.ordered_item_dsp.value}

' XXINV_ORDER_LINE_ID='

${item.line.ato_line_id.value}

' XXINV_ORIG_LINE_ID='

${item.line.line_id.value}

'

XXINV_CUST_ID='

${item.order.sold_to_org_id.value}

' XXINV_CUST_PART_NO='

'"'

${var.L_CHR_CUST_PART_NO.value}

'"'