Selective Search criteria in oaf

Selective Search criteria in oaf

In this post , We will discuss about Selective Search criteria in OAF. Selective Search criteria uses in the OAF when we are designing the Search Page or creating the List of value. For Example if We have create the List of the with two items Supplier Number and Supplier Name then in the Properties of Both these two items , I can Set the Selective Search criteria to "True". If I will set the Supplier Number item Property for Selective Search criteria to "True" but for Supplier Name I will set this property to False then it means , When user will try to search any thing in this LOV then he or she has to enter some thing either in the Supplier number or in the Supplier name any one of the field to search supplier information's so that system will not go for open search in OAF table. But if you will set both Supplier Number and Supplier Name item Property for Selective Search criteria to "True" then it means. Here bellow how we and where we can set this property for LOV or Search Items in the OAF developer.

 

How to Set Item Property "Selective Search criteria" in oaf

 

 

How to enable sandbox in oracle fusion

How to enable sandbox in oracle fusion

Hi Friends ,in this Post we will discuss about How to enable sandbox in oracle fusion. I am sure you have listened this word before in Oracle r12. In EBS Sandbox related to Server but in Oracle fusion Sandbox is totally different concept. In Oracle Fusion sandbox , We will Use Sandbox to do any kind of Personalizations or Extensions or Page layout changes in Oracle Fusion Web-pages. It means we need to create Sandbox first to make any changes in Oracle Fusion application in terms of Personalizations or Extensions. Here below I will show Detail Steps for How to enable sandbox in oracle fusion and how we can do the changes in the application Layout with sandbox.

 

 

Steps for How to enable sandbox in oracle fusion

Step1:- You need to create a Sandbox In Fusion for the personalization. Go to your user name in the right hand side of you Application home page and click on the user name.

 

click on Manage Sandboxes.

 

Personalizations in Oracle Fusion

 

 

 

Step2:-Create a Sandbox as below

 

 

Step3:- This is the page where you can see Description is a Non- Required Field.

After Enabled the Sandbox again go back to the user name in the Top right hand side of the application and click on Customize Pages as below.

 

Then This Message box will appear click on Edit.

 

Step4:- Now Click on the Structure Tab as below and click on the Description field.

 

Step5:- After Click on The Invoice Description Field then at the bottom of the page you see below settings to change the properties of Description Field.

 

 

 

 

Step6:- Then you can see below the Properties of the description field.

Step7:- click on the Show Required as below and apply the changes as below.

 

 



Now you can see below Description field is showing required in the Invoice Page.

Oracle Fusion cloud sandbox

Oracle Fusion cloud sandbox

Hi Friends ,in this Post we will discuss about Oracle Fusion cloud sandbox. I am sure you have listened this word before in Oracle r12. In EBS Sandbox related to Server but in Oracle fusion Sandbox is totally different concept. In Oracle Fusion cloud sandbox , We will Use Sandbox to do any kind of Personalizations or Extensions or Page layout changes in Oracle Fusion Web-pages. It means we need to create Sandbox first to make any changes in Oracle Fusion application in terms of Personalizations or Extensions. Here below I will show Detail Steps to create Oracle Fusion cloud sandbox and how we can do changes in the application Layout with sandbox.

Method to Implement Oracle Fusion cloud sandbox

Step1:- You need to create a Sandbox In Fusion for the personalization. Go to your user name in the right hand side of you Application home page and click on the user name.

click on Manage Sandboxes.

Personalizations in Oracle Fusion

Step2:-Create a Sandbox as below

Step3:- This is the page where you can see Description is a Non- Required Field.

After Enabled the Sandbox again go back to the user name in the Top right hand side of the application and click on Customize Pages as below.

Then This Message box will appear click on Edit.

Step4:- Now Click on the Structure Tab as below and click on the Description field.

Step5:- After Click on The Invoice Description Field then at the bottom of the page you see below settings to change the properties of Description Field.

Step6:- Then you can see below the Properties of the description field.

Step7:- click on the Show Required as below and apply the changes as below.



Now you can see below Description field is showing required in the Invoice Page.

LDAP Important Tables and SQL query in Oracle Cloud

LDAP Important Tables and SQL query in Oracle Cloud

 LDAP full means Lightweight Directory Access Protocol (LDAP). This is the Separate Directory Available in the Oracle cloud to handle Oracle Cloud application Users and their Privileges and roles. This is the Architecture of the Fusion application to keep the User Account information's details in this separate directory. Here below I will describe more about LDAP in oracle cloud.

 

 LDAP Important Tables

1.per_ldap_requests

2.per_ldap_users

 

 

 LDAP SQL query in Oracle Cloud

 

select plr.ldap_request_id, plr.request_status, plu.request_status user_request_status, plu.request_type,
ppn.last_name, ppn.first_name, plu.username requested_username, pu.username, plr.request_id, plr.active_flag,
      plr.error_code, plr.error_description
from per_ldap_requests plr, per_ldap_users plu, per_person_names_f ppn, per_users pu
where trunc(plr.last_update_date) >= trunc(sysdate-:dayOffset)
and plr.requesting_reference_id = ppn.person_id(+)
and plr.requesting_reference_id = pu.person_id(+)
and plr.ldap_request_id = plu.ldap_request_id
and ppn.name_type(+) = ‘GLOBAL’
and sysdate between ppn.effective_start_date(+) and ppn.effective_end_date(+)
and plr.request_status in (‘FAULTED’,’REJECTED’)
and plr.request_status = ‘COMPLETE’
order by plr.last_update_date desc;

Retrieve Latest ldap changes

Retrieve Latest ldap changes

In this post , We will Discuss about Retrieve Latest ldap changes in oracle cloud. LDAP full means Lightweight Directory Access Protocol (LDAP). This is the Separate Directory Available in the Oracle cloud to handle Oracle Cloud application Users and their Privileges and roles. This is the Architecture of the Fusion application to keep the User Account information's details in this separate directory. Here below I will describe more about Retrieve Latest ldap changes in oracle cloud.

 

 

This is very important that all the User Account information's should be sync with the Oracle application from LDAP directory other wise you will see the issue of not seeing the Roles and user account in the oracle cloud application. To continue sync the User account information's with the oracle cloud application , We need to schedule this below LDAP request in the Oracle Cloud so that all the latest changes done for Users account and its roles should reflect in the oracle application. Here below is the LDAP request for the same.

 

 

Retrieve Latest ldap changes is the process available in the Oracle cloud to sync User Account information's should be sync with the Oracle application from LDAP directory

 

 :Retrieve Latest LDAP Changes process" 

 

You can perform the task Run User and Roles Synchronization Process from either an implementation project or the Setup and Maintenance work area.

 

 

what is ldap in oracle cloud

what is ldap in oracle cloud

In this post , We will Discuss about ldap in oracle cloud. LDAP full means Lightweight Directory Access Protocol (LDAP). This is the Separate Directory Available in the Oracle cloud to handle Oracle Cloud application Users and their Privileges and roles. This is the Architecture of the Fusion application to keep the User Account information's details in this separate directory. Here below I will describe more about LDAP in oracle cloud.

 

 

This is very important that all the User Account information's should be sync with the Oracle application from LDAP directory other wise you will see the issue of not seeing the Roles and user account in the oracle cloud application. To continue sync the User account information's with the oracle cloud application , We need to schedule this below LDAP request in the Oracle Cloud so that all the latest changes done for Users account and its roles should reflect in the oracle application. Here below is the LDAP request for the same.

 

 :Retrieve Latest LDAP Changes process" 

 

You can perform the task Run User and Roles Synchronization Process from either an implementation project or the Setup and Maintenance work area.

 

 

oracle Fusion ap invoice approval

oracle Fusion ap invoice approval

In this post , We will discuss about oracle Fusion ap invoice approval. In Oracle fusion , Oracle had given the BPM tool to design the AP Invoice approval . We need to find the right task in the BPM task list for invoice approval . We need to design our Approval rules in the BPM task list to implement the Invoice approval workflow. Here below I will share the complete setup steps to configure the oracle Fusion ap invoice approval.

 BPM setup of oracle Fusion ap invoice approval

Go to Setup and Maintenance and then Search the ‘Manage Invoice Approval Rules’ as below.

This will bring you in the BPM task list as below

Go to Setup and Maintenance and then Search the ‘Manage Journal Approval Rules’ as below.

This will bring you in the BPM task list as below.

 

 

As below this is the BPM worklist task list as highlighted below.

 

Find the AP Invoice approval Task list as below in the BPM worklist as highlighted below ‘FinApInvoiceApproval’

Click on that Task list and go to the ‘Rules’ tab in the right side.

 

There are many types of approval rules for AP invoice but we need to select only the Invoice Document approvers as highlighted below.

Select the ‘InvoiceApprovalRuleSet’ as below.

 

Design the Fusion Invoice Approval rules as below. You can design the any rules as per your business Requirment as below , we have designed based on the Invoice amount and Invoice Type.

 

Prepayment tables in oracle payables r12

Prepayment tables in oracle payables r12

In this post , We will Discuss about Prepayment tables in oracle payables r12. Prepayment is the advance given to the Supplier before receiving his Final set of Service and the Billed Invoice so when we got supplier Final Invoice then we applied the advance/ Prepayment given to the supplier and then do rest of the left payment to the supplier. In this post , we will Discuss about Prepayment tables in oracle payables r12.

 

 

2 important Prepayment tables in oracle payables r12 

1.AP_INVOICES_ALL

2.AP_INVOICE_LINES_ALL

 

 

Sql query using Prepayment tables in oracle payables r12

SELECT hou.NAME

,aia.INVOICE_NUM Invoice_Number

,aia.INVOICE_TYPE_LOOKUP_CODE

,aia.INVOICE_CURRENCY_CODE Invoice_Currency

,aia.invoice_amount Invoice_Amount -- *

,to_char(aia.INVOICE_DATE, 'RRRR/MM/DD') Invoice_Date -- *

,(

SELECT vendor_name

FROM ap_suppliers

WHERE vendor_id = aia.VENDOR_ID

) Supplier_Name -- *

,(

SELECT segment1

FROM ap_suppliers

WHERE vendor_id = aia.VENDOR_ID

) Supplier_Number -- *

,(

SELECT party_site_name

FROM ap_supplier_sites_all assa

,hz_party_sites hps

WHERE assa.party_site_id = hps.party_site_id

AND assa.vendor_site_id = aia.VENDOR_SITE_ID

) Supplier_Site -- *

,aia.DESCRIPTION Description

,aila.LINE_NUMBER LINE_NO

,aiDA.LINE_TYPE_LOOKUP_CODE LINE_Type

,GCC.CONCATENATED_SEGMENTS

,sum(AIDA.AMOUNT) LINE_AMOUNT

,NVL(ap_invoices_utility_pkg.get_prepay_amount_remaining(

aia.invoice_id ),0) PREPAYMENT_AMOUNT_REMAINING

FROM AP_INVOICES_ALL aia

,hr_operating_units hou,

apps.ap_invoice_distributions_all aida,

apps.ap_invoice_lines_all aila,

APPS.GL_CODE_COMBINATIONS_KFV GCC

WHERE aia.INVOICE_TYPE_LOOKUP_CODE IN ( 'PREPAYMENT')

AND aia.org_id = hou.organization_id

AND aia.payment_status_flag IN ('Y')

AND aia.cancelled_date IS NULL

AND AIDA.DIST_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID

AND aida.INVOICE_ID=AIA.INVOICE_ID

and aida.INVOICE_LINE_NUMBER=aila.LINE_NUMBER

AND aia.INVOICE_ID=aila.INVOICE_ID

AND aia.invoice_amount<>0

AND AIA.CREATION_DATE > '01-APR-2015'

AND NVL(ap_invoices_utility_pkg.get_prepay_amount_remaining(

aia.invoice_id ),0)>0

AND AIA.ORG_ID=:P_ORG_ID

AND aia.invoice_id IN (

SELECT invoice_id

FROM ap_payment_schedules_all

WHERE checkrun_id IS NULL

)

group by

hou.NAME

,aia.invoice_id

,aia.INVOICE_TYPE_LOOKUP_CODE

,aia.INVOICE_NUM

,aia.INVOICE_CURRENCY_CODE

,aia.invoice_amount

,aia.INVOICE_DATE

, aia.VENDOR_ID

, aia.VENDOR_ID

,aia.VENDOR_SITE_ID

,aia.DESCRIPTION

,aila.LINE_NUMBER

,aiDA.LINE_TYPE_LOOKUP_CODE

,GCC.CONCATENATED_SEGMENTS

ORDER BY 1