Showing posts with label R12. Show all posts
Showing posts with label R12. Show all posts

Tuesday, October 18, 2016

FND_PROFILE in R12

FND_PROFILE.value('ORG_ID') will return value only if the 'MO: Operating Unit' is set for the responsibility used.

If you need to get the ORG_ID in a MOAC enabled instance, 
use FND_GLOBAL.org_id or MO_GLOBAL.get_current_org_id instead.

From the reference given below:

"For MOAC-enabled instances, FND_PROFILE.VALUE('ORG_ID') will no longer convey the correct org context for a given session.  The customer *has to change* all FND_PROFILE.VALUE('ORG_ID') calls to either use MO_GLOBAL.get_current_org_id() (which is highly recommended by the MO Team or FND_GLOBAL.ORG_ID().  Do NOT use FND_PROFILE.VALUE('ORG_ID') for any MOAC-enabled instances."


To get the org_id in OA Framework code:

use appModule.getOADBTransaction().getOrgId() or pageContext.getOrgId()
instead of pageContext.getProfile("ORG_ID").

Monday, November 23, 2015

Oracle Converting To Text in R12

Converting Oracle EBS R12 RDF to REX 

Command: 

           rwconverter.sh stype=rdffile source=ARXINVAD.rdf dtype=rexfile dest=ARXINVAD.rex batch=yes

Benefits
            You don’t need to install Reports designer to read RDF code. You can grep the rex file to check code or you can also open the rex file in any text editor to read the code.

 


Converting Oracle EBS R12 FMB  to TXT

Command: 

  frmcmp_batch module=APXINWKB.fmb userid=apps/apps  Script=YES Forms_Doc=YES module_type=FORM

Benefits

          You don’t need to install Forms designer to read FMB code. You can grep the txt file to check code or you can also open the txt file in any text editor to read the code. Another advantage is you don’t need to copy all the plls to your desktop to open the fmb.



Converting Oracle EBS R12 PLL  to PLD

Command: 

 frmcmp_batch module=ARXRWAPP.pll userid=apps/apps  Script=YES module_type=LIBRARY Output_File=ARXRWAPP.pld
Benefits

          You don’t need to install Forms designer to read PLL code.You can grep the pld file to check code or you can also open the txt file in any text editor to read the code. Another advantage is you don’t need to copy all the plls to your desktop to open the pll.