Best Of
Re: ORA-39095 - expdp creates more than 99 files
Hello Jack,
and other ideas (%L is perfect, these are just other ways of working):
-a- you might use COMPRESSION (beware that this implies licensing)
-b- you might have multiple expdp sessions using the QUERY clause for various non-overlapping parts of the data, for example if we have a column "mydate NOT NULL", you might have a session "WHERE mydate < DATE '2020-01-01'", another one "WHERE mydate >= DATE '2020-01-01' AND mydate < DATE '2023-01-01'" and a last one with "WHERE mydate >= DATE '2023-01-01'" (just an example, you see the idea). (/!\ note that this way might cause some headaches if you have to import all the data in another target; I mention if because it might be useful especially if you can forsee an impdp of a subset of the original data)
(-c- about impdp of a subset, we can also mention the "SAMPLE" clause of expdp…)
Best regards,
Bruno
Oracle E-Business Suite Enterprise Command Centers - V15 Now Available!!
Oracle is pleased to announce the V15 of the Oracle E-Business Suite Enterprise Command Centers, a set of tightly integrated, information-rich dashboards to help Oracle E-Business Suite 12.2 users identify and act on priority transactions without custom operational reporting.
This latest release – the fifteenth since we introduced Enterprise Command Centers in October 2018 – delivers 2 new dashboards, 3 updated dashboards and many new visualizations and framework features:
New Dashboards:
- Receivables: Receivables Reconciliation dashboard
- Payables: Open Liabilities dashboard
Updated Dashboards:
- General Ledger: Descriptive Flexfields (DFF) in Account Analysis Dashboard
- Inventory: Inventory Discrepancies in Aging Dashboard
- Cost Management: Projected Margins in the Margin Comparison Dashboard
Overall, there are now 36 Enterprise Command Centers with more than 165 role-based dashboards across Oracle E-Business Suite products
New Visualizations and Enhancements:
- Merge Personalizations for Power Users
- Data Set Views
- Use Multiple Data Sets in Pivot Tables
- Filter Data Locally within Pivot Tables
- Download Data from Inline View
Please check ECC V15 Quick Start Guide for detailed information about the V15 release.
Re: How to assign credit analyst to customer standard form in oracle r12.2.9?
Please disregard this question. Looks like the only way to update is through Customer Import Template
Re: SQR PRINT-IMAGE doesn't work on GIF file (PT 8.61.07)
Hello User,
Starting with PeopleTools 8.61, SQR uses PDFLib 10.0.1 for Windows, Linux, Aix and Mainframe and PDFLib 9.1.2 for Solaris and HP to generate the tagged PDF documents by calling the respective tagged PDF API calls.
The pdflib-10 removed support for GIF image, so sqr can not support GIF image while printing sqr pdf report
You can use JPG to print instead of GIF. Please make sure you convert GIF to JPG but just don't rename the file extension.
!type=gif-file
type= JPEG-FILE
Thanks,
Akash
